Trouble with secondary axis

[RJGordon]

I have two data series, one for 'this month' and one for 'year to date'. I am plotting these in a clustered column type graph. I am try to plot the 'year to date' series on a secondary axis but whenever I select the series and use 'format data deries' 'axis' 'plot series on - secondary axis' the graph converts to a stacked column. I am using Excel 2003 via a thin client to Windows server 2003.

 

[Jon Peltier]

No, it's still a clustered column chart, just that some columns on the primary axis are taller than those on the secondary axis, and peek out over the top of them. The problem is that the columns for each axis appear in the same horizontal position. You need to fake out their spacing using this kind of technique:

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

 

[RJGordon]

Thanks, that works!

 

[sean33]

Wow that fixed one of my biggest issues that I face at work all the time. Thank you!