This will add all the values we are showing on the slices of the pie. Step 3: Right-click on the pie and select Add Data Labels. Step 2: Now, it instantly creates the 3-D pie chart for you. In the Format Data Point task pane that appears, switch over to the Fill & Line tab. Step 1: Select the data to go to Insert, click on PIE, and select 3-D pie chart. Double-click the pie chart slice you want to recolor. For instance, say you want blue to be used for men and orange for women. We'll change the colour of one segement, and separate it. Now let’s try to change the color of the pie segments.
#HOW TO FORMAT YOUR DATA TO MAKE A PIE CHART IN EXCEL HOW TO#
in the next part, you'll see how to format each individual segement of the Pie Chart. TIP: As you hover over each choice in the drop down menu, it will show you a preview of your data in the highlighted chart format. Your chart will then have the correct numbers: Directly Label the Pie Chart Portions Changing the Label Position Adding the Category Name to the Data Label Format Data Labels Color. 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.
![how to format your data to make a pie chart in excel how to format your data to make a pie chart in excel](https://www.businesscomputerskills.com/images/tutorials/excel-chart17.8.png)
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.