View Single Post
  #1   Report Post  
napofrog
 
Posts: n/a
Default 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