problem with column charts and two Y axes in Excel 2003

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the full width of an Excel chart with two Y-axes 2
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
multiple series bar and line chart 2
Switch x and y axes 3
Column Chart with 2 axes 7
Two y-axes 4
Moving overlapping bars forwards and backwards 1
follow-up question regarding secondary Y-axes 1

Top