Thread: 2 questions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 2 questions


I don't understand what you mean by choosing a value for the axis. All I
want is to display it on the other side, and not change anything else. In
much older versions of Excel, you used to be able to just drag the info
from
the left axis to the right, but that doesn't work anymore.


Dragging an axis from side to side of a chart was never possible in any
version of Excel I've ever used (starting in about Excel 2).

If you want the Y axis on the opposite side of the chart, double click the X
axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I
don't know why this didn't work for you.

And no, your link did not show what I am trying to do. I want stacked
column chart desplayed on two axis...you know...the columns are striped
horizontally with the different data. The examples in your link were
either
bar or column charts, but they weren't stacked.


How does a stacked chart refer to different axes? Each item in the stack has
to be plotted against the same scale.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______