problem with column charts and two Y axes in Excel 2003

  • Thread starter Thread starter napofrog
  • Start date Start date
N

napofrog

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
 
Back
Top