Tips in MS Excel

Column Chart and its 7 sub-types!!

Here, in this Lesson Blogpost, we take a look at the Column Chart and its 7 sub-types…

Column Charts – the Default Chart Type in Excel is most frequently used to visually compare values by using vertical bars (columns) in one or more categories (data series). Here, Categories or groups are commonly plotted on the horizontal axis (axis X) and a quantitative or numerical scale is plotted on the vertical axis (axis Y).

Let’s look at an example:
Consider the below sample data of Participant Names and their Scores in Maths and Science in one of the Quarterly Unit Test.

1. With the below dataset selected (including the data column headers).
2. Click on the Insert Menu Tab >>> Charts Cluster >>> Insert Column Chart.
3. Click on the drop-down arrow to view the 7 different Column Chart sub-types.
Pause the pointer on each of the icons to preview them in the active worksheet.
Name Maths Science
Satish 75 60
Rahul 65 71
Ashwini 51 48
Raman 40 33
Sheetal 80 92
Ravi 67 85
Mayuri 71 83
Veena 89 80
Ritika 79 91
Rohan 55 52

The 7 Column Chart sub-types are:

2-D Column:
2-D Clustered Column (or Clustered Column)
2-D Stacked Column (or Stacked Column)
2-D 100% Stacked Column (or 100% Stacked Column)

3-D Column:
3-D Clustered Column
3-D Stacked Column
3-D 100% Stacked Column
3-D Column

• The advantage of Stacked Column over Clustered Column is that they show the Total Value and the contribution of each of the individual categories to a total.
• 100% Stacked Column helps us in representing this as percentage contribution of the categories to the Total (shown as 100%).
• 3-D Column Chart allow us to depict the categories on a third series (3D).
• Additionally, Changes over time can be shown using Clustered Column (For a single category / data series) and using Stacked & 100% Stacked Column (For multiple categories / data series).

So, with the above sample dataset, we can use…
• Clustered Column Chart (2-D, 3-D) to depict the Scores of Participants for Maths & Science (Categories / Data Series).
• Stacked Column Chart (2-D, 3-D) to depict the Total Score of Participants along with the individual contribution of the 2 subjects (Maths & Science) stacked one above the other.
• 100% Stacked Column Chart (2-D, 3-D) to depict the percentage contribution of individual subjects (Maths & Science) to the Total Score of the Participants (shown as 100%).
• Changes over time can be depicted for example: Quarterly – Unit Test Scores for the 2 subjects for Individual Participants.

A visual summary of the 7 sub-types of Column Charts has been provided below fo
r reference.dghdd

Posted in Techtips and tagged , .

Leave a Reply

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