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