Add Data Labels to a Pie Chart

<div dir="ltr" style="text-align: left;" trbidi="on"> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> In the previous tutorial, you created an Excel Pie Chart that looks something like this:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="An Excel 2007 Pie Chart" height="302" src="http://www.homeandlearn.co.uk/excel2007/images/pieChartPie2.gif" width="494" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <br /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> 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:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The Data for the Excel 2007 Pie Chart" height="224" src="http://www.homeandlearn.co.uk/excel2007/images/pieSelectedData.gif" width="228" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> To add the numbers from our E column (the viewing figures), left click on the pie chart itself to select it:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The Selected Pie Chart" height="230" src="http://www.homeandlearn.co.uk/excel2007/images/pieChartSelected.gif" width="232" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> 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:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The Right Click Menu" height="184" src="http://www.homeandlearn.co.uk/excel2007/images/pieAddLables.gif" width="198" /></div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Data labels in Excel 2013" height="200" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section2/pie_data_labels.gif" width="353" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> From the menu, select <b>Add Data Labels</b>. New data labels will then appear on your chart:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Data Labels added to the Pie Chart" height="202" src="http://www.homeandlearn.co.uk/excel2007/images/pieAddLables2.gif" width="200" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> The values are in percentages in Excel 2007, however. To change this, right click your chart again. From the menu, select <b>Format Data Labels</b>:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Format Data Labels" height="162" src="http://www.homeandlearn.co.uk/excel2007/images/pieAddLables3.gif" width="244" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> When you click Format Data Labels , you should get a dialogue box. This one:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The Format Data Labels dialogue box" height="301" src="http://www.homeandlearn.co.uk/excel2007/images/pieFormatLables.gif" width="388" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> If there's a tick in Percentage, untick this and select Value:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Select the Value option" height="147" src="http://www.homeandlearn.co.uk/excel2007/images/pieFormatLables2.gif" width="161" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Your chart will then have the correct numbers:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The correct Viewing Figures are now on the chart segments" height="200" src="http://www.homeandlearn.co.uk/excel2007/images/pieChartPie3.gif" width="200" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> 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.</div> </div>

Add Data Labels to a Pie Chart

In the previous tutorial, you created an Excel Pie Chart that looks something like this: At the moment, though, there's no infor...

Read more »