Data Series on 2nd Axis Blocking Other Columns?

[bucksnut]

I have a column chart with 3 data series. When I move the third data series to a 2nd axis it moves to the center of the other columns, blocking them?? I want the series tied to the 2nd axis to be the third column. TIA!

 

[Jon Peltier]

Using secondary axes in charts seems like a great idea, at least until someone else has to read the data from the chart. I wrote about this in Secondary Axes in Excel Charts. Aside from the usual confusion, when you have a column chart with series on different axes, the secondary series obscure the primary series. You can play games with dummy series that have zero values, and pad each axis with enough of these dummy series to push the real data to one side or the other, but you will still have the problem of comprehending which data goes with which axis.