WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Stacked Chart in Excel

Stacked Chart in Excel (Column, Bar & 100% Stacked)

Stacked chart in excel are of three types, stacked column chart, stacked bar chart and 100% stacked column chart and 100% stacked bar chart, in stacked charts data series are stacked over one another for a particular axes, in stacked column chart the series are stacked vertically while in bar the series are stacked horizontally.

Basically, there are four stacked chart options:

  1. Stacked Bar
  2. Stacked Column
  3. 100% Stacked Bar
  4. 100% Column.

There is an option for 2-D and 3-D, which should be selected as per the needs and requirements of the presentation style.

Let us see each of them in detail with an example –

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

You can download this Stacked Chart Excel Template here – Stacked Chart Excel Template

Example #1 – Stacked Column Chart

  • Step 1 – Select all the data for which we have to create the Stacked Chart, like below:

data

  • Step 2 – Click on Insert and then click on Insert Column or Bar Chart like below:

Click on Insert

  • Step 3 – After clicking the above one, one box will appear to select:

STACKED Chart - Step 3

  • Step 4 – Make sure we select Stacked Column only from 2-D or below box:

STACKED Chart - Step 4

  • Step 5 – After selecting, we have like below Stacked Area Chart in the result:

Stacked Area Chart

Likewise, if we have to create in 3- D Format, then we have to select the below one from the 3-D Column:

STACKED Chart - Step 6

After Clicking the circled one, below would be the result, which is nothing but a 3-D column Format:

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

STACKED Chart - Step 7

Example #2 – Stacked Bar Chart

Above are the examples of 2-D & 3-D Column. Now we will see the same in the Stacked Bar Chart format.

Below are the steps which are different from the above one:

  • So, instead of selecting the option from the 2-D & 3-D Column, we have to select the 2-D & 3-D Stacked Bar Chart like below:

STACKED Chart Example 2

Below would be the result for the data:

STACKED Chart Example 2-1

Here we can see the difference. The no. is horizontal here, and the Q1, Q2… are vertically shown. It is the vice-versa of 2-D Column. If we select a 3-D Stacked Bar chart, then it would be the same but in 3-D format. So, we can analyze from above and conclude the various result, if we have to look out the maximum no. of Pune in which quarter. First, see the color of Pune, which is blue, given in the chart. Now, we have to see in which quarter the blue bar is the largest, so it is the Q4 and no. is 26 if we look at data. Hence, it helps in making a decision quickly.

Example 3 – 100% Stacked Chart

There is another type of Stacked Chart which 100% Stacked Chart, in which the bar would be 100% means in above examples the length of Bar or column is the only total of the data, but here the Bar or Column would be 100%, and the colored part is as per data, like below:

STACKED Chart Example 2-2

So, we have to select the below one for the result:

Select chart

Same, like above, we can create for 3-D Column,2-D Bar & for 3-D Bar as well by selecting 3rd one from above.

  • 3-D Column (100% Stacked Column):

3-D Column (100% Stacked Column)

  • 2-D bar(100% Stacked Chart):

2-D bar(100% Stacked Chart)

  • 3-D Bar (100% Stacked Chart) :

3-D Bar (100% Stacked Chart

When to use a Stacked Chart?

  • A Part-to-whole: With the help of the Stacked bar char, we can clarify the difference from part to whole, and we can see what the chart is pointing out.
  • Comparisons: the Stacked chart is used for making comparisons between the given data like values, productions, or many others.
  • Survey Results: To showcase the results of the survey, the stacked chart is used to know the differences and highlighting.
  • Rankings: The stacked chart is also used to show the rankings over a period of time. The column and graph show the data by its length and differentiates it by a different color.

When Not to use Stacked Chart?

In the following situations, we have to avoid using the stacked chart:

  • Deeper Analysis: It should be avoided when one has to make a deep analysis from the chart because it is preferable for quick decision making.
  • Lots of Data: One has to avoid using the stacked chart when there are lots of data because it is very much difficult to analyze after seeing lots of variants.

 Things to Remember

  • One can change the color of the Bar or column by right-clicking and choose the correct option as per needs and requirements.
  • The title of the chart can also be added to better understand or differentiate the data.
  • The variants should be properly selected while creating a stacked chart so that the result and analysis should be done.

Stacked Chart in Excel Video

Recommended Articles

This has been a guide to Stacked Chart in Excel. Here we discuss its uses and how to create Stacked Chart in Excel (Column, Bar, and 100% Stacked) along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • Pie Chart in Excel
  • Funnel Chart in Excel
  • Create Column Excel Chart
  • Pie Chart in Excel
  • Pivot Table Change Data Source
4 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 Chart Excel Template

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