Md. Asaduzzaman
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.
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.
- 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.
- 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.
- Hence, you will see the 100% stacked column chart of your data like the following image.
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.
- 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.
