There is a difference in trying to create COMBO charts on the Mac. In windows, you can change the CHART TYPE and select Combo. In Mac you are unable to do that and have to follow a convoluted means to add a second axis. The windows version is very intuitive, Mac not so much.
Thanks for the suggestions and support for combo charts. You can create a wide variety of combo charts already on Mac, even if only a few are available on the menus.
1. Create any chart that shows 2 series of data, such as one of the Line charts or combo charts.
2. Click on the series that you want to change to a different type, so that the series is highlighted.
3. Click the Change Chart Type button and pick a new chart type.
The new type will only be applied to the selected series, so you end up with whatever combination you want.
Some chart types can’t be used in Combo charts, and you’ll see that if you pick one that won’t work. We will take this feedback into consideration and perhaps make combo charts easier to discover.
Thanks – Steve K [MS Excel]
2 commentsComments are closed
Dwight Erskine commented
It would be excellent if, in addition to the current combo chart option (Clustered Column + Line), three other options were available.
The first would be a Stacked Column + Line option.
The second would be a Clustered Bar + Line.
The third would be a Stacked Bar + Line.
Totally agree. The Mac version does not have the "Change Chart Type" tab for "All Types" and Combo type is missing. Interestingly, I created a two axis chart in Excel for Windows then opened in Excel for Mac (both 2016) and now several menu items are available! For instance, in creating it in Mac the "Add Chart Element" only showed primary axis as an option. But after opening the Windows spreadsheet, now the Mac version shows both the Primary and Secondary axis as a menu option. So there is a lot of functionality on the Mac version that just is not exposed to the native interface. This cannot be a major thing to simply expose menu items and controls that already exist in the Mac version.