Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Create Clustered and Stacked Column Charts

We can use clustered column charts or stacked column charts to represent our data in a simple, clean, and visual outlay. Stacked Column and Clustered Column charts make it easier for us to understand and interpret our data. In this tutorial, we will learn how to make a stacked bar chart and a clustered column chart.

Figure 1 – How to make a clustered column chart in Excel

Creating a Clustered Column Chart

When we use the Clustered Column Chart, our data will appear as though it’s flowing from the left to the right side rather than the traditional bar chart, which displays bars flowing upwards. 

  • We will prepare a data table as shown below

Figure 2 – Data for column charts

  • Next, we will highlight the section of the data we want to show in a graph. In this case, we will highlight cell A3:B11
  • Next, we will go to the Insert Tab and click on the option for the bar chart in the charts section
  • When we click on the column chart option, we will see its dropdown list. We will select the first option in the 2D- Column Section, this option is called the Clustered Column

Figure 3 – How to create a clustered column chart in Excel

  • When we select this chart type, we will automatically see our clustered column chart inserted into our worksheet

Figure 4 – How to create a clustered column chart

Creating a Stacked Column Chart

We can also use a Stacked Column graph or chart to represent our data. In this case, our values will appear stacked upon each other.

  • We will prepare a data table as shown below

Figure 5 – Data for stacked column chart

    • We will highlight the section of the data we want to show in a chart. In this case, we highlight cell 
    • Next, we will go to the Insert Tab and click on the option for a bar chart in the charts group

 

  • When we click on the column chart option, we will see its drop-down list; we will select the second option in the 2D-Clustered Column Section, this option is called the Stacked Column

 

Figure 6 – How to stack columns in Excel

  • Excel automatically generates our Stacked Column chart

Figure 7 – How to make a stacked column graph in Excel

  • If we want to view our Stacked Column chart in percentages, especially in cases where the total is less important than the relative proportion, we can use the 100% Stacked Column Chart. This will set the totals to 100% and display data as a proportion of each constituent value. In this case, we will pick the third option from our 2D-Column

Figure 8 – Using a 100% Stacked Column Chart 

  • We will see our chart in this manner.

Figure 9 – How to make a 100% stacked column chart in Excel

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc