Forum Discussion
Excel 2021 Combo Chart with 2nd axis not accessible on Mac
Hi, I have Excel 2021 on a Mac. My project has an already existing column chart with vertical (value) axis and line with a =SERIES formula. I need to add a secondary axis with titles. Right now, I ...
LeeAn_8507 Can you share a file demonstrating the issue? Upload it to Onedrive or similar and post the link that gives access here.
When you are talking about 'bin widths' it suggests you are dealing with a histogram. And that doesn't work in a combo chart.
If you have clustered column chart with 6 series, click the one that you want to show as a line. On the 'Chart design' tab click 'Change chart type' and select line. Now, with the line still selected, right-click (or 2-finger press on the touch pad) and select 'Format data series...' and then 'Secondary axis' in the Series options tab.