EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Stacked Column Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Stacked Column Chart

By Madhuri ThakurMadhuri Thakur

Stacked Column Chart in Excel

Stacked Column Chart in Excel (Table of Contents)

  • Stacked Column Chart in Excel
  • How to Create Stacked Column Chart in Excel?

Stacked Column Chart in Excel

A stacked Column Chart 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 sales data of Mobile, Laptop and TV for six months. Using the Stacked Column Chart, we can show the coverage of all 3 products in a single column for each of the six-month data. This saves space, and the chart created using this is type looks compact as well.

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

Stacked Column Chart

Start Your Free Excel Course

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

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

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,596 ratings)

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 basically make the column charts one on another column chart, and the charts that are prepared as stacked are like fixing one bar chart on another chart.

Sales Report Stacked Chart

How to Create Stacked Column Chart in Excel?

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

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

In Column chart options, you will see several options; choose the stacked column stack option to create stacked column charts.

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

Stacked Column Chart Example 1-2

Step 4: You can also use the DESIGN option to make the chart more presentable.

Click on the Format option and then 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, and this will add more of the information to the normal usual stacked charts.

Here one of the chart elements, such as legend, is used. Click on legend. Select 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 our utmost use. In this option, we can simply hover on the icons in the quick layout elements and can see what elements are inserted by these options.

  • Change colors

Sometimes this become important that the 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 to 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 Chart title go to Layout>Chart title>select Above chart.

Example 1-14

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 have been 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

After selecting the data as mentioned above and selecting a stacked column chart, you can see the below 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 when it comes to deeper analysis of data.
  2. Stacked column charts are useful only if there are limited segments in a group; if there are many inputs that belong to the same group, then the stacked column chart will be very congested, making the analysis difficult.
  3. Overlapping of data labels, in some cases, this is seen that the data labels overlap each other, and this will make the data to be difficult to interpret.

Things to Remember 

  • A stacked column chart in Excel can only be prepared when we have more than 1 data that has to be represented in a bar chart. If we have only one data that is to be displayed, then we can only make a Bar chart and not the stacked column chart.
  • Each column in the bar represents the data that belongs to that group only. Suppose if we have to show the data of two products 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 be represented in the bar chart of the stacked column charts.

Recommended Articles

This has been a guide to Stacked Column Chart in Excel. Here 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
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
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

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

EDUCBA Login

Forgot Password?

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

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

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

EDUCBA

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

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

Let’s Get Started

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

EDUCBA

Download Stacked Column Chart Excel Template

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