Sunday, December 11, 2011

Excel: Combine Charts

What are combination charts?

Combining charts are charts made by combining two types of charts in one single chart.

What is the use of combining charts?

It makes the data more interpretable. In my previous tutorial I covered comparison chart. It compared three data in one graph, but it lacks interpretability. Combination charts are very easy to understand, especially when a comparison is made between two data.

Creating Chart

Let us make a comparison between inflation and unemployment rate in India during the period of year 2002 to 2010. These are the actual data I found at Index Mundi. Start with making a table in the picture.

Go to Insert > Charts > Line and click Stacked Line with Markers to make a graph as in the picture below. See create simple charts in excel on how to make graphs in excel.

Combining Chart

  1. Right click on line representing inflation (blue line) in the graph.
  2. Select "Change series chart type".
  3. Click " Clustered Column " from change chart type pop-up.
  4. Click OK.

Formatting Chart

  1. Click "Chart Tools".
  2. Select layout 3 form chart layouts.
  3. Right click on chart title and select edit text.
  4. Type Inflation Vs Unemployment.
The final result is:

From the above chart you can compare inflation and unemployment with ease as compared to above line chart. It can easily be interpreted that column chart is showing inflation rate and the line graph is showing unemployment rate over the years. If you like this post leave a comment and share with your friends.

1 comment:

  1. here are few interesting points into a subject that many are struggling to get more knowledge on.Any way keep it up you have really done an expertisely.Author Customized dashboard


HostGator Promos