How To Show Percentages In Stacked Column Chart In Excel

With a stacked column chart in Excel, you can view partial numbers, but what do you do when you want to show percentages? Excel's pie charts show percentages, but stacked column charts do not. We are going to use a mixed reference to create a column chart with percentages.

Chapters / Timestamps:
0:00 Intro
1:00 Stacked column with numbers
2:38 Pie Chart w/ percentages
3:26 Add totals
3:53 Mixed Reference w/ percentages
5:00 Stacked column with percentages

#chrismenard #chrismenardexcel #msexcel #microsoftexcel #excelcharts

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[pareshwadgaonkar]

Can we do it without manipulating the data table?

[titsyanasharyi]

thanks a lot for your videos!! such simple actions, but when you know where to search for!! 😊😊😊 your knowledge helps so much 🍀🍀🍀

[EhsanQasemipour]

Excellent thank you for this. This way you cannot make a comparison between years if they come with different total values, which I think it's most likely in quite everything.

[zarimjeiserrano]

How do you do it with only one column?

[John_F]

You’d think excel could convert the numbers to percentages automatically in the chart