Pie Chart – Show Percentage – Excel & Google Sheets

This tutorial will demonstrate how to add percentages to a pie chart.

Adding Percentages to Pie Chart in Excel

Starting with your Graph

We’ll start this tutorial with a table and a pie chart shown based on the data. As you can see, the pie chart is made by using percentages of the total. Sometimes it is helpful to add percentages so that the end user can easily see what percentage each quarter makes up.

 

Add Data Labels

1. Click on the chart
2. Click the + Sign in the top right
3. Select Data Labels

 

Change to Percentage

This will show the “Values” of the data labels. The next step is changing these to percentages instead.

 

1. Right click on the new labels
2. Select Format Data Labels

 

3. Uncheck box next to Value

4. Check box next to Percentage

 

Final Graph with Percentage

After making these changes, your final graph should look like the one below where it shows the percentage that each slice represents.

 

Adding Percentages to a Pie Chart In Google Sheets

When creating a pie graph in Google Sheets, the percentages will automatically populate for each of the slices of the pie chart.