How to Show Percentages in Stacked Bar and Column Charts

Adding Percentages to the Stacked Column Chart

To display percentages instead of volumes on the stacked chart, we first need to calculate them by building another data table. Duplicate the table of volumes we used to create the chart in the first place, and enter a formula to calculate the percent of total for each region in each year.

Sales Percentages

In this example, the formula for the first region and first year is as follows:


The $ locks the Total row for the volume table so that we can drag the formula across and down to complete the data set. When you are finished, the percentage table should look like this:

Percentage Table