Excel Chart question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to display both primary and secondary axis on the same side of
a (linear) chart
 
No, that is not possible
Now someone will show you a complicated way to prove me wrong
 
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/
_______
 
Back
Top