How to Create a Stacked Column Chart in Excel (4 Suitable Ways)

A stacked column chart is an Excel basic chart that can show comparisons over time or categories. It can stack one data on top of the other in vertical columns and make a graphical comparison of data of different categories. In this article, we will see how to create a stacked column chart in Excel.


Download Practice Workbook

You can download the Excel workbook from here.


4 Suitable Ways to Create a Stacked Column Chart in Excel

In order to create a stacked column chart in Excel, we will need a dataset like the below image. Here Student ID numbers of eight students are shown in column B and their obtained marks in Math and Biology are shown in columns C and D respectively. We will create a stacked column chart to show all the students’ Math and Biology marks in one chart. From the chart, we will also be able to compare their obtained marks. There are four ways to create a stacked column chart in Excel. Now we will see all the ways to do the job.

4 Suitable Ways to Create a Stacked Column Chart in Excel


1. Create a Basic Stacked Column Chart in Excel

This is the most commonly used stacked column chart in Excel. We can easily stack data of different categories in one column and compare the data with this stacked column chart. Let’s see the steps to create a basic stacked column chart in Excel.

Steps:

  • First of all, open the worksheet which contains the dataset.
  • Secondly, select the (C5:D12).
  • After that, click on the Insert tab >> Insert Column or Bar Chart drop-down >> Stacked Column Chart option like the below image.

Create Basic Excel Stacked Column Chart in Excel

  • Finally, you will see the stacked column chart of your data like the following image.

Read More: Column Chart vs Bar Chart in Excel (6 Useful Examples)


2. Make a 100% Stacked Column Chart in Excel

Sometimes, we want to compare our data out of 100%. A 100% stacked column chart can be helpful for this purpose. Now we will see how to create a 100% stacked column chart in Excel.

Steps:

  • Firstly, open the worksheet which contains the dataset.
  • Next, select the (C5:D12) cells.
  • After that, click on the Insert tab >> Insert Column or Bar Chart drop-down >> 100% Stacked Column Chart option like the below image.

Make a 100% Stacked Column Chart in Excel

  • As a result, you will see the 100% stacked column chart of your data like the following image.

Read More: Show Percentage in 100 Stacked Column Chart in Excel


3. Generate Excel 3D Stacked Column Chart

We sometimes want to compare our data of different categories in a 3D chart. At that time, creating a 3D stacked column chart in Excel could be an option for us to serve the purpose. Here is an example of how to generate a 3d stacked column chart in Excel.

Steps:

  • First, open the worksheet which contains the dataset.
  • Next, select the (C5:D12) cells.
  • Subsequently, click on the Insert tab >> Insert Column or Bar Chart drop-down >> 3D Stacked Column Chart option like the below image.

Generate 3D Stacked Excel Column Chart

  • Hence, you will see the 100% stacked column chart of your data like the following image.

Generate 3D Stacked Excel Column Chart

Read More: How to Insert a 3D Clustered Column Chart in Excel (with Easy Steps)


4. Create 3D 100% Stacked Column Chart

If we want to compare our data out of 100% in a 3D chart, then 3D 100% stacked column chart can be a good choice. Now we will see how to create a 3D 100% stacked column chart in Excel.

Steps:

  • First, open the worksheet which contains the dataset.
  • Then, select the (C5:D12) cells.
  • Furthermore, click on the Insert tab >> Insert Column or Bar Chart drop-down >> 3D 100% Stacked Column Chart option like the below image.

Create 3D 100% Stacked Column

  • Finally, you will see the 3D 100% stacked column chart of your data like the following image.


Things to Remember

  • If you want to represent your data and compare them in the 2D chart, then a stacked column chart or 100% stacked column chart would be a better option.
  • If you want to represent your data and compare them in the 3D chart, then 3D stacked column chart or a 3D 100% stacked column chart would be a better option.
  • A stacked column chart becomes visually complex when categories or series are increased.

Conclusion

Hence, follow the above-described methods. Thus, you can quickly learn how to create a stacked column chart in Excel. Hope this will be helpful. Follow the ExcelDemy website for more articles like this. Don’t forget to drop your comments, suggestions, or queries in the comment section below.


Related Articles

Md. Asaduzzaman

Md. Asaduzzaman

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo