How do I create a pie chart in Excel 2010 with percentages?

Right click any slice on your chart, and select **Format Data Labels**… in the context menu. On the Format Data Labels pane, select either the Value or Percentage box, or both as in the following example. Percentages will be calculated by Excel automatically with the entire pie representing 100%.

How do I add numbers to a pie chart in Excel 2010?

Add data labels

Click the **chart**, and then click the Chart Design tab. Click Add Chart Element and select Data Labels, and then select a location for the data label option. Note: The options will differ depending on your chart type. If you want to show your data label inside a text bubble shape, click Data Callout.

How do you make a pie chart in Excel with percentages?

## Related Question how to make a pie chart in excel 2010

### How do you make a percentage formula in Excel?

Calculating percentages

As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. The basic formula for calculating a percentage is =part/total.

### How do I find the percentage of a number in Excel?

### How do you work out 20% of a number in Excel?

If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of. For example, if you want to calculate 20% of 500, multiply 20% by 500. - which gives the result 100.