| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Secondary axis alignment
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 kilometers on 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Secondary Axis - Alignment of Dollar Values | Charts and Charting in Excel | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Linear Mode
