Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Secondary Axis
How to change where the category (x) axis crosses the value (y) in secondary
axis. There are 2 chart type (bar and line) in the same chart: Primary axis: Bar chart Secondary axis: Line chart |
#2
|
|||
|
|||
Iris -
You can change where the primary X axis crosses the primary Y axis, and where the secondary X axis crosses the secondary Y axis, through the Scale tab while formatting the respective Y axes. To make the primary X axis cross at a given place on the secondary Y axis, you need to adjust the scales of the primary and secondary Y axes together until they cross where you want. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ iris wrote: How to change where the category (x) axis crosses the value (y) in secondary axis. There are 2 chart type (bar and line) in the same chart: Primary axis: Bar chart Secondary axis: Line chart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
Secondary Axis Without Data Points? | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Secondary Axis? | Charts and Charting in Excel | |||
Problems with true value on secondary Y axis | Charts and Charting in Excel |