How To Make A Pie Chart In Excel 2010

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?

  • Select the pie chart.
  • Right-click on it. A pop-down menu will appear.
  • Click on the Format Data Labels option.
  • 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?

  • Enter the formula =C2/B2 in cell D2, and copy it down to as many rows as you need.
  • Click the Percent Style button (Home tab > Number group) to display the resulting decimal fractions as percentages.
  • 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.

    Posted in FAQ

    Leave a Reply

    Your email address will not be published. Required fields are marked *