Add Data Labels to a Pie Chart in Microsoft Excel

Add Data Labels to a Pie Chart in Microsoft Excel

In the previous tutorial, you created an Excel Pie Chart that looks something like this:

At the moment, though, there's no information about what each segment represents. We're going to add the numbers from our ITV viewing figures. These ones:

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

The chart is selected when you can see all those blue circles surrounding it. Now right click the chart. You should get the following menu:

From the menu, select Add Data Labels. New data labels will then appear on your chart:

The values are in percentages in Excel 2007, however. To change this, right click your chart again. From the menu, select Format Data Labels:

When you click Format Data Labels , you should get a dialogue box. This one:

If there's a tick in Percentage, untick this and select Value:

Your chart will then have the correct numbers:

Overall, the chart looks OK. But we can add some formatting to it. in the next part, you'll see how to format each individual segement of the Pie Chart. We'll change the colour of one segement, and separate it.

Posted in: Microsoft Excel,Microsoft Excel 3 (Excel 2007/2010 Charts),Tips,Trick,Tutorial,Tutorial Excel 3