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.

**Stacked column chart with percentages in Excel**

YouTube vdeo

How To Show Percentages In Stacked Column Chart In Excel

Steps to create a stacked column chart with percentages

1. Copy your data and paste somewhere else on your spreadsheet 3:26 in the video 2. Select and remove the values and use a mixed reference to find the percentages 3:53 in the video 3. Create a stacked column chart - 5:00 in the video|