Thread: Secondary Axis
View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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