How to Put a Percent Into a Pie Chart

Written by foye robinson
  • Share
  • Tweet
  • Share
  • Email

Displaying the percentage of values in a chart makes it easier to compare data. You can put a per cent into a pie chart by using Microsoft Excel. Thanks to the built-in formulas, you won't have to calculate your values by hand. You can copy a table from another program and paste it into Excel. Excel will help you create a chart based on those values and update your chart whenever the values change. The completed chart can then be placed into your current worksheet, a different worksheet, or added to another program.

Skill level:


  1. 1

    Open Microsoft Excel and enter the data you want to include in your pie chart.

  2. 2

    Click on "Insert, Chart." To use the standard pie chart, click on "Standard Types" tab. Then choose "Pie" for the "Chart type" and select a thumbnail under "Chart subtype." To use a customised chart, select the "Custom Types" tab instead and scroll through the list of pie charts. Leave "Built-in" selected under "Select from."

  3. 3

    Click on "Next >" and select the "Data range" button to choose the range of values you want to use in the pie chart. Then click on "Next >."

  4. 4

    Enter the chart title you want to use under the "Titles" tab and select the "Data Labels" tab. Choose the label contents and place a checkmark by "Percentage" to put a per cent into the pie chart. Then click on "Next."

  5. 5

    Choose where you want your chart added--within the current Excel worksheet or as a new worksheet. Then click on "Finish." The pie chart with percentage will be placed into Excel.

  1. 1

    Enter your data into Microsoft Excel 2007 and select the data you want to create a pie chart for.

  2. 2

    Click on the "Insert" tab and choose "Pie" from the "Charts" group. Select a pie chart from "2-D Pie" or "3-D Pie" to place it onto your page.

  3. 3

    Select the pie chart in Excel, then click on the "Design" tab and go to the "Chart Layouts" group. Use the scrollbar on the right-hand-side of the "Chart Layouts" section to scroll through the thumbnail layouts and pick a layout with a percentage. Your pie chart will now include percentages.

  4. 4

    Choose the location you'd like the pie chart placed in by selecting "Move Chart" from the location group under the "Design" tab. You may add the chart to a new sheet or as an embedded chart in the current worksheet.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.