Excel Chart question

A

Amj

Is there a way to display both primary and secondary axis on the same side of
a (linear) chart
 
B

Bernard V Liengme

No, that is not possible
Now someone will show you a complicated way to prove me wrong
 
J

Jon Peltier

Bernard -

You're not wrong, of course; Excel can be made to place both Y axes on the same
side, but one will overlie the other. If the various ticks are spaced appropriately
and it's near full moon, you might even see both sets of tick labels, but I think
that's probably a bug.

But you can put the two axes close to each other. One crosses at the minimum of the
X axis, and the other crosses at a value near the minimum. To specify where the Y
axis crosses, you must format the scale of the X axis. To specify where the
secondary Y axis crosses, you must at least temporarily show the secondary X axis
(Chart menu > Chart Options > Axes tab, check Secondary X Axis). If My X axis
spanned 0 to 10, I'd probably change the minimum to -1, and put the Y axes at -1 and 0).

- 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

column charts with set set of data 0
Chart distorts secondary axis when the x-axis is logarithmic 5
Filtered view of Visio Chart 0
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
sideways stacked bar charts with line series on the same axis 0
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
Gantt chart duration not showing 0
vertical scale on both ends of bar chart 1

Top