WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Stacked Column Chart

Excel Stacked Column Chart

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Stacked Column Chart in Excel

Stacked column chart in excel is a column chart where multiple series of the data representation of various categories are stacked over each other, the series which are stacked are vertical and the comparison for multiple data series is easy but as the number of data series increases the complexity of representation also increases.

5 Main Parts of Stacked Column Chart

  1. The title describes the information about the Stacked Column
  2. (Horizontal) The x-axis represents an individual entry for which the values are to be presented.
  3. Bars The height of a bar represents the total value as the sum of the values of all the legend.
  4. (Vertical) Y-axis denotes the intervals spanning across the lowest and highest value.
  5. Legend describes the type/category of the dataset that contributes to the column bars.

Types of Stacked Column Chart in Excel

  1. Stacked Column
  2. 3-D Stacked Column Chart
  3. 100% Stacked Column
  4. 3-D 100% Stacked Column

How to Create a Stacked Column Chart in Excel? (with Examples)

You can download this Stacked Column Chart template here – Stacked Column Chart template

Example #1 – Steps to Create a Basic Excel Stacked Column Chart

  • Step 1 – Select the range of cells (rows and columns) containing the data to be presented using a stacked column graph. This would be the input data for the chart.

Stacked Column Chart - Step 1

  • Step 2 – Click on Recommended Charts, as shown in the below figure.

Stacked Column Chart - Step 2

  • Step 3 – Select Columns-> Stacked Column Chart from the given list -> Click OK

insert Chart

Stacked Column

As shown in the above figure, the data consists of 2 columns B and C indicating marks of Maths and Science, respectively.

The chart on the right side is a stacked column graph wherein X-axis represents the sequence of each entry, such as 1, 2, 3, …, 10. The Y-axis indicates marks. The interval is auto-generated by Excel to 50; hence the values are 0, 50, 100, 150, 200, and 250. The height of the bars represents the value. As the name of the chart is “stacked,” the legends are stacked in a single column. As seen in the chart, the blue color indicates column 1, i.e., Maths m marks, and the orange color indicates column 2, i.e., Science marks.

The maximum value shown by each column bar is the total of all the values of each legend. E.g. 50 + 70 = 120 for column 1.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #3 – Steps to Create 3-D Stacked Column

3-D Stacked Column

It is different from the default stacked column graph only in terms of representation of the column bars. This enables a better view of the column bars if compared to the default one. The rest of the features remain like that of a 100% stacked column.

Example #4 – Steps to Create 100% Stacked Column

100% Stacked Column

This chart is slightly different from the default stacked column that the height of every column or bar is 100% by default, and the legends are divided among that 100%. So, the maximum value shown by each column bar will always be 100, unlike the sum of the values of all legends in the default stacked column.

As shown in the above figure, the data consists of 2 columns B and C indicating marks of Maths and Science, respectively. The chart on the right side is a 100% stacked column wherein the X-axis represents the sequence of each entry, such as 1, 2, 3, …, 10. The Y-axis indicates marks. There is no interval in this type of chart. The height of each legend represents the value (i.e., marks here) among 100% occupied by the bar.

Like a normal stacked chart, the legends are stacked in a single column. Blue color represents column 1, i.e., Maths marks, and Orange color represents column 2, i.e., Science marks.

Example #5 – Steps to Create  3-D 100% Stacked Column

3-D 100% Stacked Column

3-D 100% stacked column is different from a 100% stacked column only in terms of representation of the column bars. This enables a better view of the column bars if compared to the default one. The rest of the features remain like that of a 100% stacked column.

Pros

  1. Each column bar represents one value. So, the Stacked Column graph is useful where the entities to be measured are discrete such as Marks.

Cons

  1. A Stacked Column may not be a good choice if the dataset is too large.

Things to Remember

  1. The stacked column graph is based on the column bars, which comprise one or multiple legends.
  2. One column bar is composed of the values of all participating legends.
  3. One column bar represents one row from the given dataset.
  4. They represent a discrete dataset wherein one column represents one individual entry (row) in the dataset.

Recommended Articles

This has been a guide to Stacked Column Chart in Excel. Here we discuss its uses and how to create a Stacked Column graph along with Excel examples and downloadable templates. You may also look at these useful functions in excel –

  • Stacked Bar Chart in Excel
  • Stacked Chart in Excel
  • Chart Wizard in Excel
  • Column Chart in Excel
  • Excel Minus Formula
1 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Stacked Column Chart template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More