how to create a pie chart with percentages in excel

Now, you can right click one of the numbers and select Format Data Labels from the list.

This will add the values for each of the slices in the pie.

Right click any of the slices in the pie chart, and select Add Data Labels from the list.A pie chart typically shows labels next to each slice. Click the chart legend once and press the DELETE key on your keyboard.Resize the pie chart so the left side is locked to the left side of Column E, the right side is locked to the right side of Column L, the top is locked to the top of Row 2, and the bottom is locked to the bottom of Row 10 (see Figure 4.19).Click and drag the pie chart so the upper left corner is in the middle of cell E2.Click off the slices and into the white canvas to deselect the pie and select the entire chart.

Use the Undo button to undo this if you want to try again. This can be another option for displaying your data. Note: if you let go of the mouse button before dragging, you may only get one slice to move when you drag it out from the center.

How to create a pie chart with percentages in excel