How to create a combination Chart

Thanks! Share it with your friends!

Close

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



Comments

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.