Secondary axis alignment

Jeffrey

Guest

Posts: n/a

6th Aug 2012

I want to create a graph with time on the X-axis and distance on the Y-axis..

I want to have two Y-axes: miles on my primary vertical axis and kilometerson my secondary vertical axis. The primary axis will range from 10-90 miles. The corresponding number of kilometers would be 16.0934-144.841. By default, the graph will show tick marks at 16.0934, 21.0934, 26.0934, etc. However, I would rather have tick marks at 20, 25, 30, etc. How can I do that?

I tried changing the "Format axis" - "Horizontal axis crosses" menu option,but it did not help.

Jeffrey

« Copy a worksheet to a new workbook | More Rows/One Sheet vs More Sheets/Less Rows for best performance? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Secondary axis alignment	johjeffrey@hotmail.com	Microsoft Excel Worksheet Functions	0	26th Jul 2012 10:26 PM
Secondary Axis - Alignment of Dollar Values	hans L	Microsoft Excel Charting	2	15th Mar 2010 06:32 PM
Re: Display of secondary axis trendline for a secondary axis plot	Jon Peltier	Microsoft Excel Charting	0	21st Sep 2004 01:10 AM
Display of secondary axis trendline for a secondary axis plot	=?Utf-8?B?aWFuY29tcHV0aW5n?=	Microsoft Excel Charting	0	20th Sep 2004 03:47 PM
x axis alignment w/pos-neg y axis scale	Haldeman	Microsoft Excel Charting	2	16th Sep 2003 08:47 PM