How to Lookup Entire Row Using Index Match

Stacked chart is good for visualising data as part of whole. They are same as stacked bar chart with only difference of orientation. The stacked bar chart is oriented horizontally, and stacked column chart is oriented vertically.

When you have small number of categories to show, stacked column chart can be used for effective comparison of data. But when the number of categories increase stacked column chart gets complicated to read.
There are two types of stacked column charts. Let’s explore them one by one.
1. Excel Stacked Column Chart

This is good for number comparison.
The stacked column chart is best for comparing data within the group. You can also use it compare with all groups. Like you can compare one group with other.  But you cant compare the part of group to other group. Let’s see how.

Example: 

Here I have this data of drink consumption in different cities of world (this is just for example and numbers does not refer to any actual survey).

Now to plot a stacked chart in excel 2016, follow these steps:

  1. Select data.
  2. Go to insert tab? charts? 2D charts? Stacked column chart. Click on it.
  3. You have your stacked chart.

Now we can see that total consumption of drinks is largest in london. We can easily compare the individual drinks consumption in london. But if we want to compare the individual drink consumption of each drink with other groups, it gets hard. It would be better, if we had a 100% chart.

2. Excel 100% Stacked Column Chart
To compare percentage with other groups, we use 100% stacked chart. This can not be used to compare whole groups data with other but it can be used to compare parts of groups to other groups.

Example:

To plot a 100% stacked column chart in excel, follow these steps.

  1. Select data.
  2. Go to insert tab? charts? 2D charts? 100 %Stacked column chart. Click on it.
  3. The 100% stacked chart is ready.

Now we can see that total consumption of drinks as 100% and all the columns are equal but the parts are representing the percentage of each drink in the group . We can easily compare the individual drinks consumption with other groups and tell which type of drink is more or less consumed in which city. 

So yeah guys, this how you plot the stacked column chart in excel. You can check out some creative charts mentioned below. If you have any doubt regarding this article or any other excel related topic, do let me know in the comments section below.
 

 

Related Articles:

Pareto Chart and Analysis

Waterfall Chart

Excel Sparklines : The Tiny Charts in Cell

Speedometer (Gauge) Chart in Excel 2016

4 Creative Column Chart that Includes Totals

4 Creative Target Vs Achievement Charts in Excel

Popular Articles:
The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube