Secondary axis alignment

J

johjeffrey

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. 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Secondary axis alignment 0
Value on horizontal axis 2
Overlap graph multiple axis 1
Make Y-axis values correspond to x- axis value 1
reverse axis not working as before... 0
Secondary X-Axis on Scatter Plot 0
Help with data points in line graph in Chart function in Excel. 0
Use text descriptors as Y axis units 1

Top