Question: Is it possible to combine two or more chart types in a chart?
Answer: Yes
Why: To display the results of different sets of data in one graph
Applies To: Excel 2010, 2007, 2003:
1. Refer to the data given below
2. Select any cell within the data range
3. Select as below
4. The following chart will be displayed
5. To insert the heading select the chart and select as below
6. Select the average price bars in the chart and as below
7. Two charts (line and column will be displayed)
8. Right select the line graph and select as below
9. Select Secondary axis and then the close button
10. The following chart will be displayed
Two graphs with separate axis have been combined in one chart. Therefore one can easily interpret the different sets of data in the chart.