create a pie chart with percentages in excel

Now, click the Chart Elements button ( the Plus + sign at the top right corner of the pie chart).

Click on the pie chart to make it active.

To active the Format Data Labels window, follow the simple steps below.

We can open the Format Data Labels window in the following two ways. Display Percentage in Pie Chart by Using Format Data LabelsĪnother way of showing percentages in a pie chart is to use the Format Data Labels option. Read More: How to Show Total in Excel Pie Chart (2 Effective Ways)Ģ.

There are more Chart Styles options available that show the percentage data label.

The above steps now make the pie chart showing the percentages for each of the constituent parts.

Choose the 3rd option from the Chart Styles options.

Then click the Chart Design tab from the Excel Ribbon.

First, click on the pie chart to active the edit mode.

To show the percentage in our pie chart for each of the ethnic groups that made up the total population, let’s do the following. Use of Chart Styles to Show Percentage in Pie Chart in Excel The above steps created the following pie chart.ġ.

In the Chart tab, click on the Insert Pie button.

Then go to the Insert tab from the Excel Ribbon.

Here, we have the percentage of population by major ethnic groups in Southern California. To illustrate how to show percentages in a pie chart, we need to create one first. Our task is to visualize the proportional distribution of the males and females in the list.3 Convenient Ways to Display Percentage in Pie Chart in Excel This is a two-column table that contains the names and genders of ten imaginary people. To show you the ropes, we need to start with some initial data. Here’s a quick list of where male/female pie charts may come in handy:

The goal of such charts is not to make accurate or precise comparisons but to help the audience understand how constituent parts of the chart contribute to the overall picture.

Explode a Single Slice (Optional)Ī male/female pie chart depicts a part-to-whole relationship between (surprisingly!) men and women by dividing a circle into proportional segments.

Create a pie chart with percentages in excel