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!
Excel Facts
What do {} around a formula in the formula bar mean?
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.