

Creating charts in Excel is quite easy: Select the data and choose your desired chart type on the ‘Insert’ ribbon. But when it comes to combining two chart types – for example a column chart with a line on top – many users suddenly struggle. But actually, it’s almost as simple as inserting a normal chart. Let’s have a look at how to do it and how to further adjust your chart.
Steps for combining two chart types in Excel
Creating a chart with two different chart types is comparatively simple in newer versions of Excel (the numbers are corresponding with the picture on the right hand side):
Example: Create combo charts with Excel for Mac
Sometimes the combo chart type is not available, for example in Office for Mac. In such case you have to create the combination of the two chart types manually:
These steps work universally – also if you have a stacked or clustered column chart and want to display one series as another chart type.
The chart menu has changed a little bit in Excel 2016. There are also new chart types available. The basic steps for creating combo charts are similar to before. Just follow the steps as shown above or this animation:
Steps for creating combo charts under Excel 2016
The gif above was too fast? Here are the steps in detail:
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Subscribe to our popular Excel newsletter! You get all this:
Your welcome gift: Our big 45 pages keyboard shortcuts package.
Subscribe now! In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Please use this download link to download the Currency Converter Excel add-in!
Please use this download link to download the comment extraction example: http://bit.ly/Extract_Comment_Example
Comments 2
Kevin
How do you do this on the iPad/iPad pro?
Henrik Schiffner
As far as I know it’s not possible at the moment as the options on the iPad version are quite limited. Please let me know if you still find a solution.