Pages

Showing posts with label charts on excel. Show all posts
Showing posts with label charts on excel. Show all posts

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.

Sunday, November 27, 2011

Comparison Charts With Excel


Today we are going to learn how to make a chart which compares two or more data in a table. It is very useful when we want to compare between two values very easily within no time. As you will agree that comparing data with a graph is far more better than digging into a lot of data in a table. So lets get started. this is what we are going to create.

Follow these easy step by step method to create the chart as in the above image. Lets say we want to compare a list of items A to E for number of units in stock, purchased and sold.
Step 1
Create a sample data as below.

Step 2
Go to Insert > Charts > Column and then select Clustered Column chart from 2D Column.


Step 3
Select Layout 5 from Chart Layouts in Chart tools in Design tab.


Step 4
Right click on chart area and click on Select Data.

Step 5
In the Select Data source window click on Add.


Select the title "In Stock" for Series Name and Data below In Stock title for Series Values and click OK.


Notice a series In Stock is added in the Legend Entries (Series) list box. Now click on Edit button.


Select Item names A to E for Axis label range and click OK.


Similarly Add Two more series Purchased and Sold  as illustrated above for Purchase and Sold units.

Step 6
After completing above five steps you should get a graph as shown in the image.


Right click on Axis Title and choose Edit Text. Delete the text and write "Number of Units". Select the text and change the font size to 12 and the result is. . . 


Leave me a comment if you like this post.
HostGator Promos