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 have 6 sets of data for 5 buildings and a total row. Every time I switch the chart to Combo with Secondary Axis, only 3 columns appear for 3 data sets. The informal format pane showing bin widths is not accessible (no matter why pathway I choose from double-clicking to using the Chart Design menu and features). Please help.
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.
