# How to Make a Percentage Pie Chart With Excel

Techwalla may earn compensation through affiliate links in this story.
Image Credit: Hirun Laowisit / EyeEm/EyeEm/GettyImages

Pie charts are one of the most widely used types of graph, and Microsoft Excel is well set up to generate them. Pie charts show data as a proportion of a whole by their nature, so they're well suited to display percentages. However, when you create a pie chart in Excel using the most straightforward method, it doesn't display the percentage for each slice. It's easy to add this information, but you need to either choose a different chart layout or add the percentages to your existing chart as labels.

## Create Pie Chart in Excel

The first thing you need to do to produce an Excel pie chart with percentage values is to produce a basic pie chart. Find or enter some data in an appropriate format. Pie charts require a name for each section and a numerical value associated with each section. For example, you might have a type of product such as fruit, vegetable, meat and dairy as the names for each slice of the pie and the total sales in each category as the numerical value. Enter this data into your Excel sheet in two columns, one with the names and one next to it with the numerical values. Highlight the data.

Create the pie chart by clicking the "Insert" tab at the top of the screen, finding the "Charts" group, and choosing the drop-down arrow beneath the pie chart icon. (On Excel 2007 and earlier, it says "Pie" below the icon.) This brings up the different pie and doughnut chart options in Excel. Choose a basic 2D pie, an exploded pie or any option suitable for your needs. Click on the type you prefer to create a pie chart in Excel.

## Excel Pie Chart With Percentages

The easiest way to create an Excel pie chart with percentage values is to click on the pie chart you just made and navigate to the "Design" tab. In Excel 2007 and earlier, you'll see a group called "Chart Layouts." On later versions of Excel, the same options are found in the "Quick Layout" section. In this group are several choices for displaying a chart, and the ones you're looking for have percentage symbols inside the pie icon. There is an option for percentages to be displayed in the slice or just outside along with the label, and two options for a separate legend with the percentage values displayed in and around the pie. Choose any of these to create a pie chart with percentages.