Secondary Axis

I

iris

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
 
J

Jon Peltier

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/
_______
 

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

Finding asymptote equation and how to draw them in excel 0
Circular Bar chart? 4
column charts with set set of data 0
Coordinate secondary y axis to primary y axis 2
Make Y-axis values correspond to x- axis value 1
Primary X axis to Secondary X axis 1
simple chart 0
Chart distorts secondary axis when the x-axis is logarithmic 5

Top