How to Make a 100% Stacked Column Chart in Excel

100% Stacked Column charts are a great way to compare proportions within categories. When using this chart type, it is important to consider the order of the data, as the 100% Stacked Column chart will stack the columns in the order that the data is provided. This can be helpful when trying to compare data across different categories, as the 100% Stacked Column chart will provide a clear visual of the relationships between the data. In this article, I will show you how to make a 100 percent (100%) Stacked Column chart in Excel with easy steps.


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


What Is a 100% Stacked Column Chart?

If you want to compare parts of a whole, then a 100% Stacked Column chart is the way to go. This type of chart shows how each category contributes to the total and what its percentage is of the total.

For example, let’s say you wanted to compare the revenue of four different product lines for your company. A 100% Stacked Column chart would let you see not only the revenue for each product line but also what percentage of the total revenue each product line brings in.


Steps to Make a 100% Stacked Column Chart in Excel

I will use the following Sales Report to show you how to make a 100% Stacked Column chart in Excel. The dataset contains the sales data in percentage for 4 countries. The dataset explains the change in sales over a period of 10 years.

Dataset to Make a 100% Stacked Column Chart in Excel


Step-1: Insert a 100% Stacked Column Chart

After preparing the dataset, it’s time to insert a 100% Stacked Column chart.

To insert,

❶ Select the entire dataset.

❷ Go to Insert Charts.

❸ Click on the Insert Column or Bar Chart drop-down.

❹ Then select the 100% Stacked Column in the 2-D Column section.

Insert a 100% Stacked Column Chart in Excel

Then Excel will generate a column chart based on your data selection.

In this case, the stacked columns have been generated based on counties.

To change this stack representation,

  • Click on the chart first.
  • Then go to Chart Design ➤ Data ➤ Switch Row/Column.

Now the stack columns are showing based on Sales in 2010 and Sales in 2020.

Make a 100% Stacked Column Chart in Excel

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


Step-2: Format 100% Stacked Column Chart

To format a 100% Stacked Column chart, first of all, you need to insert a proper title.

To add a title,

  • Edit the texts in the Chart Title.

Here,  I used Sales Report as a chart title.

Make a 100% Stacked Column Chart in Excel

To remove the vertical axes,

  • Click on the plus icon at the top-right corner of the chart.
  • From the Chart Elements, select Axes.
  • Then deselect Primary Vertical.

To remove the gridlines,

  • Again click on the plus icon at the top-right corner of the chart.
  • From the Chart Elements, deselect the Gridlines.

Make a 100% Stacked Column Chart in Excel

Read More: How to Create a Column Chart in Excel (2 Suitable Ways)


Step-3: Add Data Labels to Chart

After the formatting is done, it’s time to add the Data Labels to the column chart.

To add data labels on the stacked columns,

  • Click on the plus icon at the top-right corner of the chart.
  • In the Chart Elements, go to Data Labels.

Now you will see different positioning options such as,

  • Center
  • Inside End
  • Inside Base
  • Data Callout

You can select any of them as per your requirement, but I’m selecting Center here.


Step-4: Apply a Chart Style

Excel offers some built-in chart styles to apply to your column chart.

To apply a chart style,

  • Click on the chart first.
  • Then go to Chart Design.
  • From the Chart Styles group, select any of the chart styles.

Apply a Chart Style to Make a 100% Stacked Column Chart in Excel

After applying a built-in chart style, the 100% Stacked Column chart will look like this:

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


Practice Section

You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the topics discussed in this article.


Conclusion

To sum up, we have discussed steps to make a 100% Stacked Column chart in Excel. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website ExcelDemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo