EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign up
Home Excel Excel Resources Excel Charts Excel Stacked Column Chart

Excel Stacked Column Chart

Madhuri Thakur
Article byMadhuri Thakur

Updated August 24, 2023

Stacked Column Chart in Excel

Stacked Column Chart in Excel

A stacked Column Chart in Excel is used when for a single time period; we want to show the data with the coverage of each parameter over the same period, which is available in the Insert menu tab. For example, we have six months of sales data for Mobile, Laptop, and TV. Using the Stacked Column Chart, we can show the coverage of all 3 products in a single column for each six-month data. This saves space, and the chart created using this type also looks compact.

ADVERTISEMENT
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The stacked chart represents the sales of products in different quarters.

Stacked Column Chart

A column chart that only represents the sales of a different product but not allows us to easily know the share of different products in the total sales.

Sales Report Column Chart

Stacked column charts are those chart options that allow a user to combine one group’s data and then show that data in different segments that correspond to different sections amongst the same group. Stacked charts make the column charts one on another, and the charts that are prepared as stacked are like fixing one bar chart on another.

Sales Report Stacked Chart

How to Create a Stacked Column Chart in Excel?

Creating a stacked column chart is not as difficult as it seems; it involves only some clicks, and you will be done creating it.

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

Stacked Column Chart in Excel Example #1

Let’s consider a case in which the company sold four types of products in a year, and we have data on the sales of these products.

Now we want to know what type of product has contributed what percentage to the total sales. We can use a stacked column chart.

Step 1: Firstly, enter the data for which you want to create a stacked column chart and select the data.

Stacked Column Chart Example 1

Step 2: Then go to the toolbar tab. Here, you can see the “insert” option.

Click on Insert and then click on column chart options as shown below.

Stacked Column Chart Example 1-1

You will see several options in Column chart options; choose the stacked column stack option to create stacked column charts.

Step 3: After selecting the above data and a stacked column chart. You can see the below chart.

Stacked Column Chart Example 1-2

Step 4: Use the DESIGN option to make the chart more presentable.

Click on the Format option and choose the font that suits the chart.

Stacked Column Chart Step 1-3

Step 5:

By this step, a stacked column chart is already prepared, but by using this step, we can add life to the old spreadsheet charts and make them look different.

Stacked Column Chart Example 1-4

  • Add chart elements

Stacked Column Chart Example 1-5

In the chart elements, we can add all the above-listed elements in our stacked column chart, adding more information to the usually stacked charts.

Here one of the chart elements, such as legend, is used. Click on legend. Select the legend at the bottom.

Stacked Column Chart Example 1-6

Now the Legend will look at the bottom of our Chart.

Stacked Column Chart Example 1-7

  • Quick layouts.

Stacked Column Chart Example 1-8

If we are confused about what elements should be in our stacked column chart, this option will be of utmost use. In this option, we can simply hover on the icons in the quick layout elements and see what elements are inserted by these options.

  • Change colors

Sometimes this becomes important that color plays an important role in the graphs, especially if the data belongs to the paint industry.

Right-click on the Chart Select Format Chart Area.

Stacked Column Chart Example 1-9

By Selecting Format Chart Area, go to Fill> Gradient Fill. Select your color.

Stacked Column Chart Example 1-10

To change the Color of the Plot Area, Right-click on Format Plot Area.

Stacked Column Chart Example 1-11

Select fill> Gradient Fill and Select your color.

Example 1-12

Using the change color option, we can simply change the chart’s theme and choose more comfortable colors for our stacked column chart.

1-13

To add the Chart title go to Layout>Chart title>select the Above chart.

Example 1-14

A chart tile is added to the above chart.

Example 1-15

Finally, the Stacked Column Chart looks like this.

Example 1-16

Stacked Column Chart in Excel Example #2

Suppose now we have a case of a college where we want to know how many lectures are taken by which lecturer. In this case, we use a stacked column chart.

Example 2

Then go to the toolbar tab; here, you can see the “insert” option.

Click on Insert and then click on column chart options as shown below.

Example 2-1

You can see the chart below after selecting the data mentioned above and selecting a stacked column chart.

Example 2-2

Follow the steps as per the above Example, i.e., Example 1, to get the desired Stacked Column Chart.

Example 2-3

Pros of Using Stacked Column Chart in Excel

  1. They help in easily knowing the contribution of a factor to the group.
  2. They are easy to understand.
  3. Easy to visualize results on bar graphs.
  4. Easy to depict the difference between the various inputs of the same group.

Cons of Using Stacked Column Chart in Excel

  1. These charts do not give good results regarding deeper data analysis.
  2. Stakeholders find assembled column charts useful only when small segments are in a group. If many inputs belong to the same group, the stacked column chart will be very congested, making the analysis difficult.
  3. Overlapping of data labels in some cases is seen in that the labels overlap each other, making the data difficult to interpret.

Things to Remember

  • You can only prepare a stacked column chart in Excel if you have more than 1 data to represent in a bar chart. If we have only one data to be displayed, then we can only make a Bar chart and not a stacked column chart.
  • Each column in the bar represents only the data that belongs to that group. Suppose we have to show the data of two product sales in Q1, then the bar will represent the data of product A, and the same bar will have the data of Product B.
  • Only one data from one row can represent in the bar chart of the stacked column charts.

Recommended Articles

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

  1. Interactive Chart in Excel
  2. Freeze Columns in Excel
  3. Excel Clustered Column Chart
  4. Excel Column Chart
ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
  • Blog as Guest
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

EDUCBA

Download Stacked Column Chart Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

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

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

Forgot Password?

EDUCBA

Download Stacked Column Chart Excel Template

EDUCBA

डाउनलोड Stacked Column Chart Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Cyber Monday Reloaded Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW