problem with column charts and two Y axes in Excel 2003
 

I've used previous versions of Excel for column charts a fair bit, and
it seems like something doesn't work in Excel 2003. I want to display
two data series next to one another in a column chart, and each data
series needs its own Y axis (they are on different scales). I can get
the two series next to each other if they are both plotted against the
same Y axis, but if I choose Format Data Series - Axis - Secondary
Axis for the second data series, the two columns are on top of each
other. I can't figure out how to change this, and I don't recall ever
having this problem in older versions of Excel.

Any suggestions would be very appreciated!

Thanks,

Roger

problem with column charts and two Y axes in Excel 2003
 

Here's the workaround:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

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

napofrog wrote:

I've used previous versions of Excel for column charts a fair bit, and
it seems like something doesn't work in Excel 2003. I want to display
two data series next to one another in a column chart, and each data
series needs its own Y axis (they are on different scales). I can get
the two series next to each other if they are both plotted against the
same Y axis, but if I choose Format Data Series - Axis - Secondary
Axis for the second data series, the two columns are on top of each
other. I can't figure out how to change this, and I don't recall ever
having this problem in older versions of Excel.

Any suggestions would be very appreciated!

Thanks,

Roger