I have made a screencast to show how we can combine 2 chart types into one chart when we are using the same data source. This is one of the questions posed to me when we were at Yishun Town Secondary School.
Microsoft Excel 2010 – Combing 2 charts into one ( Using same data source )
If you are looking for different data source, please look here
You can download the sample file here :
Should you have any question, please feel free to contact me at firstname.lastname@example.org