How to create a combination Chart

Thanks! Share it with your friends!


This video shows you how you can have more than one type of chart type on a single chart (often called a combination chart).  In the video an example is used to show how to have one data set shown as a bar chart and one set of data as a line chart.  Pretty cool!

The trick is to use the second scale option on the graph using the format data series options.

The video gives a clear and easy to follow example – which we can probably related to.

This video is taken from the missing manual books. If you found this clear and useful you may like to check out their cool range of  Excel books on

Amazon US

Amazon UK


Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.