how to create a percentage pie chart in excel

Then, go to the PivotChart > Pie as shown in the image below.

Secondly, select any cell in the PivotTable.In this case, we chose 0 decimal places for the Sales value. Following, click the Number Format button.In turn, you can format the numeric values by right-clicking the mouse and selecting the Field Value Settings.Just like that, a table is generated, it’s that easy. Then, on the PivotTable Fields pane drag the Category and Sales fields into the Axis (Categories) and Values fields respectively.Next, a dialog box appears in which you have to check the New Worksheet option and press OK.Firstly, select the dataset as shown below and go to the Insert > PivotTable.So, without further delay, let’s see the process step-by-step. Here, the first column shows the Item name, followed by the column for Category, and lastly, the Sales column in USD.Įxcel makes it simple to make a PivotTable and insert charts. Throughout this article, we’ll consider the following dataset shown in B4:D14 cells. Generally speaking, in Microsoft Excel’s terminology, making a chart from a PivotTable is called a PivotChart, although it is the same as a normal chart. We'll change the colour of one segement, and separate it.2 Ways to Create a Pie Chart from Pivot Table in Excelįirst, let’s dwell a little upon what is a Pie Chart?Ī Pie Chart is a circular graph where each slice of the pie represents the proportionate part of the entire data. in the next part, you'll see how to format each individual segement of the Pie Chart. Your chart will then have the correct numbers: If there's a tick in Percentage, untick this and select Value: When you click Format Data Labels, you should get a dialogue box. From the menu, select Format Data Labels: To change this, right click your chart again. The values are in percentages in Excel 2007, however. New data labels will then appear on your chart: You should get the following menu:įrom the menu, select Add Data Labels. The chart is selected when you can see all those blue circles surrounding it.

To add the numbers from our E column (the viewing figures), left click on the pie chart itself to select it:

We're going to add the numbers from our ITV viewing figures. In the previous tutorial, you created an Excel Pie Chart that looks something like this:Īt the moment, though, there's no information about what each segment represents.

How to create a percentage pie chart in excel