How to Show Percentages in Stacked Bar and Column Charts

Adding Percentages Manually

It is possible to manually enter the percentages into the stacked chart. This process is slow (you have to do each cell individually), but if you only have a small data set, it might be faster than installing an add-in.

To add the percentage from the table to the chart, do the following in order:

  1. Click on the data label for the first bar of the first year.
  2. Click in the Formula Bar of the spreadsheet.
  3. Click on the cell that holds the percentage data.
  4. Click ENTER.

Set Data Label Source

You will have to repeat this process for each bar segment of the stacked chart to add the percentages.