We use essential cookies to make Venngage work. By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.

Manage Cookies

Cookies and similar technologies collect certain information about how you’re using our website. Some of them are essential, and without them you wouldn’t be able to use Venngage. But others are optional, and you get to choose whether we use them or not.

Strictly Necessary Cookies

Always Active

These cookies are always on, as they’re essential for making Venngage work, and making it safe. Without these cookies, services you’ve asked for can’t be provided.

Show cookie providers

  • Venngage
  • Amazon
  • Google Login
  • Intercom

Functionality Cookies

These cookies help us provide enhanced functionality and personalisation, and remember your settings. They may be set by us or by third party providers.

Show cookie providers

  • Venngage
  • Chameleon
  • Intercom
  • Algolia

Performance Cookies

These cookies help us analyze how many people are using Venngage, where they come from and how they're using it. If you opt out of these cookies, we can’t get feedback to make Venngage better for you and all our users.

Show cookie providers

  • Venngage
  • Mixpanel
  • Intercom
  • Google Analytics
  • Hotjar

Targeting Cookies

These cookies are set by our advertising partners to track your activity and show you relevant Venngage ads on other sites as you browse the internet.

Show cookie providers

  • Google Ads
  • Google Tag Manager
  • Facebook
  • Pinterest
  • Product

  • Solutions

  • Templates

  • Learn

  • Pricing

Learn
Educational Resources
Blog
Blog
Webinars
Webinars
Help Center
Help Center

How To Create a Stacked Bar Chart? [+ Examples]

By Letícia Fonseca, Jan 20, 2022

The business world creates a large number of reports. Charts and graphs demonstrate growth, successes, and area of improvement. A stacked bar chart can do all that and more.

While a pie chart or line graph is a great tool for tracking business expenses and savings, stacked bar charts are better to compare and analyze data.

In this post, we’ll show you how to create a stacked bar chart and why you need to use them in your data visualization.

Start making a stacked column chart in minutes with the Venngage Chart Maker, without any design experience.

 

Click to jump ahead:

What is a stacked bar chart?

A stacked bar chart is a type of bar graph that represents the proportional contribution of individual data points in comparison to a total.

The height or length of each bar represents how much each group contributes to the total.

For instance, you can select a stacked column chart type, like the simple example below, to illustrate the percent of a company’s sales come from each region.

Colorful Stacked Bar Chart Template
 

You can also create a stacked area chart that compares each branch’s data points to the entirety of the data from other branches.

Colorful Area Chart Template
 

In short, a stacked column chart is like a standard bar chart except that it is able to show part-to-whole comparisons.

Don’t know how to create a chart? With Venngage, all you need to do is choose a template, and then you can import your chart data from an Excel CSV file or Google sheet.

BarLineChart-New

Return to Table of Contents

How to read a stacked bar graph?

A stacked bar chart is used to show the total or average of each category. The taller a bar is, the larger the volume of those numeric values.

The bars in the stacked bar chart below show how each category compares to the average. The bottom bar shows the total for all of the categories. Note the data labels on the dual-axis charts.

Monthly Savings vs Spending Stacked Bar Chart Template
 

A simple clustered bar chart like this one can show your savings and spending proportions and track trends simultaneously, which is useful for visualizing data in reports.

Return to Table of Contents

When do you use a stacked column chart?

A stacked column chart is a useful tool for determining a trend across a time period. Here are other uses for stacked bar graphs:

  • Marketing (spending vs results)
  • Economy (supply and demand)
  • Vehicle performance (mileage vs performance)
  • Business budgets (spending vs saving)

When you want to compare small aspects and the complete data of any general category, a stacked bar chart can accurately represent your data, like in this net promoter score chart.

Net Promoter Score Stacked Bar Chart Template
 

Return to Table of Contents

When should you not use stacked bar charts?

There are a few situations where you don’t need a combined chart. Simple bar or column charts, a pie or line graph, or other chart types would be a better choice. Here are those instances.

Simple budgeting

Pie graphs and donut charts are better choices for creating simple budget charts, such as this pie chart infographic.

Blue Pie Chart Template
 

This is because pie charts are better at displaying relative or percentage comparisons. They don’t show absolute values, which a stacked column chart can show.

Analyzing stock market trends

Line charts and bar graphs are better tools for analyzing and visualizing trends than a stacked bar chart is.

Line Graph Template
 

Looking for trends in a data series

Scatter plot graphs make trend data much easier to understand than stacked charts.

Comparison Scatter Plot Chart Template
 

Related: 11 Types of Charts and How Businesses Use Them

Return to Table of Contents

4 steps to create a stacked chart

Here are the basic steps to build your own stacked column charts.

Determine what segments you’ll be comparing

The data for a stacked bar chart is determined by the type of data that is on the axes.

The x-axis usually has the ordered values on it, while the y axis will have the list of items. The items list can be a numeric variable (i.e. 1, 2, 3) or qualitative (i.e. A, B, C), like in this example.

stacked bar chart
 

The data for a stacked column chart can be determined by the type of data on the axes. Sometimes, that data is simple enough to compare that it can have just one axis, such as in this example:

Multiple Stacked Bar Chart
 

This is an example of a stacked bar chart that only sits on one axis with all the elements at the same height. But you can adapt it for a column chart with longer or shorter columns.

Choose a bar chart template

Once you’ve determined the ordered values and data type you’ll use on the axes of your stacked bar chart, you can start creating the first bar chart.

Instead of designing from scratch, pick a template, like the one below.

Horizontal Stacked Bar Chart
 
  1. Select the axis on this chart
  2. A pop-up menu will allow you to adjust the colors and visuals according to your needs
  3. Enter your data manually or import it into your stacked column chart from a CSV file or Google sheet.

And you’re done!

It’s that simple to customize a stacked column chart template from Venngage’s library.

Return to Table of Contents

Determine data clarity

Ensure your graph design has enough white space so readers can fully comprehend the data.

A stacked bar chart can use contrasting colors to show variations in data within the total amount, like in the below example.

Visual Content Stacked Bar Chart Template
 

Or use different lengths to show the relative size of segments to each other. This will help the chart make more sense to readers.

Get an external perspective

Lastly, have someone review your stacked bar chart. For example, here’s a comparison of writers as a stacked bar chart. To get this right, a number of people analyzed and edited this stacked bar chart.

Productivity Stacked Bar Chart Template
 

It’s easy to get tunnel vision when creating your stacked column charts, so having a new pair of eyes that haven’t worked on it is an excellent way to see new ideas and find errors.

Don’t be afraid to keep on revising and improving your design until you’ve got the best stacked column chart for your needs.

Related: How to choose the best charts for your infographic

Return to Table of Contents

FAQs about stacked bar charts

What’s the difference between a stacked column chart and a bar chart?

A bar graph is one in which the columns are of different heights. The area of each column is proportional to the size of the data. 

A stacked column chart, on the other hand, typically has columns of equal height. Each column includes segments of varying height, depending on the numeric variable of the data.

In simple terms, a bar chart displays the data as a series of bars that have a height proportional to their value, while a stacked column chart is a type of bar chart where the columns are segmented according to a specific attribute.

Can you create a stacked bar chart in Excel?

Yes, you can create a stacked bar chart in Excel, but you will need some data visualization abilities to do so.

While Excel does give you options for comparing and contrasting data, it’s best to use a stacked bar or column chart template that has done most of the work for you.

We’ve shared numerous examples of Venngage’s templates in this post.

Pick the template closest to your data, change or add values in the stacked charts, change colors, add a chart title, and make the template your own.

Create stacked bar charts and show the differences in your data

Now you know why you should create a stacked column chart or bar chart for your reports and presentations.

And with Venngage’s templates, you don’t need to have design skills to design a memorable data visualization. Choose the template you want and start designing in minutes.