How to Make a Pie Chart in Excel (With Percentages)

To make a pie chart in Excel, put your labels in one column and your numbers in the next, select both columns, click the Insert tab, click Insert Pie or Doughnut Chart, and choose 2-D Pie. To show percentages on the slices, click the chart, go to Chart Design > Quick Layout, and pick a layout that puts a percentage on each slice.

These steps cover Excel for Microsoft 365 and Excel 2016 through 2024 on Windows, as listed on Microsoft’s Add a pie chart page. Mac differences are noted, and Excel 2016 labels Chart Design as Design. Not sure of yours? Check your Excel version.

Check That Your Data Fits a Pie Chart

A pie chart shows how parts make up one whole, like a monthly budget or survey answers. Microsoft says a pie works best when:

  • You have one data series. A data series is one set of related numbers, such as one column of monthly costs. A pie can only draw one.
  • No values are zero or negative. A negative number can’t be drawn as a proper slice, and a zero leaves a 0% label with no visible slice.
  • You have seven categories or fewer. More slices get hard to tell apart. If you have many small items, add them together into one “Other” row.
  • The categories are parts of one whole. All the slices should add up to a single total.

If your data doesn’t fit, a bar, column, or line chart will be easier to read. Data with levels inside levels, such as regions split into cities, fits a Sunburst chart better, which is on the Insert > Recommended Charts > All Charts list. When a full chart is more than you need, Excel sparklines show a trend inside a single cell.

How to Make a Pie Chart in Excel

  1. Type your categories in one column, such as Rent, Groceries, and Utilities, and the matching numbers in the column to the right. Put a short header at the top of each column, such as Expense and Amount.
  2. Select both columns, including the header row. Don’t include a total row. Excel would draw the total as one extra, oversized slice.
  3. Click the Insert tab at the top of the window.
  4. In the Charts group, click Insert Pie or Doughnut Chart. It’s the small round pie icon.
  5. Click the first option under 2-D Pie.
Excel Insert Pie or Doughnut Chart menu with 2-D Pie option
Select your data, then choose 2-D Pie.

Excel adds the chart to your sheet with one slice per row of data. It uses the header of your number column as the chart title and adds a legend (the color key) that shows which color belongs to which category.

Other Ways to Insert the Chart

  • Recommended Charts: Select the data and click Insert > Recommended Charts. Excel previews chart types that fit your data, and the All Charts tab lists every type, including Pie.
  • Quick Analysis (Windows): Select the data, then click the Quick Analysis button that appears at the lower-right corner of the selection, or press Ctrl + Q. Open the Charts tab and click Pie. This tool isn’t in Excel for Mac.
Excel Quick Analysis menu with the Charts tab open and Pie highlighted
On Windows, Quick Analysis offers a pie chart in two clicks.
  • PivotChart for raw lists: If the same category appears on many rows, such as one row per purchase, click a cell in the data, then click Insert > PivotChart and OK. In the field list, drag the category field to Axis (Categories) and the number field to Values, and Excel totals each category for you. Then click Design or Chart Design > Change Chart Type and pick Pie. Microsoft covers the basics in Create a PivotChart.

How to Show Percentages on a Pie Chart

You don’t need to calculate anything. Excel works out each slice’s share of the total from your raw numbers.

The Quick Way: Quick Layout

  1. Click the chart to select it. The Chart Design tab appears in the ribbon.
  2. Click the Chart Design tab.
  3. Click Quick Layout and point to each layout to preview it. Layout 1 shows the category name and percentage on each slice. Click the one you want.

Some presets in the Chart Styles gallery on the same tab also add percentage labels, so you can preview those too.

The Detailed Way: Format Data Labels

Data labels are the bits of text attached to each slice. Use this method when you want to choose exactly what they say.

  1. Click the chart, then click the + (Chart Elements) button next to its upper-right corner. On a Mac, use Chart Design > Add Chart Element instead. You can also right-click the pie and choose Add Data Labels.
  2. Point to Data Labels, click the arrow, and choose a position such as Outside End or Data Callout (which puts each label in a text bubble). For full control, choose More Data Label Options, or right-click a label and choose Format Data Labels.
  3. In the Format Data Labels pane, under Label Options > Label Contains, check Percentage. Check Category Name if you want the name on the slice too, and uncheck Value to hide the raw number.
Excel Format Data Labels pane with Percentage checked
Check Percentage under Label Contains.

For more data label options, read Microsoft’s Add or remove data labels in a chart. If every slice shows its category name, you can click the legend and press Delete to free up space.

Percentages in data labels are rounded, so they won’t always add up to exactly 100. To show decimals, open Number in the Format Data Labels pane, choose Percentage, and set Decimal places to 1 or 2.

For the same fix in worksheet cells, read about keeping the second decimal place in Excel.

Finished Excel pie chart with percentage labels
Excel calculates each slice’s percentage for you.

How to Customize Your Pie Chart

  • Change the title: Click the title and type a new one.
  • Change colors or style: Click the chart, click the paintbrush (Chart Styles) button next to it, and pick from the Style or Color tabs. Chart Design > Change Colors does the same thing from the ribbon.
  • Recolor one slice: Click the pie once, then click the slice again so only it’s selected. Click the Format tab and choose a new Shape Fill color.
  • Pull out one slice: Click the pie, double-click the slice you want, and drag it away from the center.
  • Pull apart the whole pie: Right-click the pie, choose Format Data Series, and drag the Pie Explosion slider or type a percentage (Microsoft’s steps).
  • Rotate the pie: Right-click a slice, choose Format Data Series, and change Angle of first slice from 0 to another number of degrees, such as 90. At 0, the first slice starts at the top and the rest follow clockwise. Rotating helps when labels crowd together.
  • Hide a category: Click the funnel (Chart Filters) button next to the chart, uncheck the category on the Values tab, and click Apply. The data stays in your sheet.
  • Put slices in size order: Excel draws slices in the same order as your rows. Sort the number column with Data > Sort Largest to Smallest (keep the labels with their numbers when Excel asks), and the chart follows.

Other Pie Chart Types

The same Insert Pie or Doughnut Chart menu has a few variations. To switch an existing chart, select it, click Chart Design > Change Chart Type, and pick another one.

Type What it does Good for
2-D Pie A flat circle split into slices Most charts. It’s the easiest to read.
3-D Pie The same pie drawn with depth Decoration only. The tilt makes slices harder to compare.
Pie of Pie Moves small slices into a second, smaller pie Data with several tiny values
Bar of Pie Moves small slices into a stacked bar Several tiny values that are easier to label in a bar
Doughnut A ring with a hole in the middle More than one data series, one ring each

Pie of Pie and Bar of Pie move the smallest values into the second chart by default. To choose what goes there, right-click the chart, choose Format Data Series, and pick Position, Value, or Percent value in the Split Series By box. With Position, set how many items move in Values in second plot. With Value or Percent value, enter a cutoff in Values less than.

Update or Delete the Chart

The chart stays linked to its cells. Change a number in your sheet and the slice and its label update on their own. To change which cells the chart uses, right-click it, choose Select Data, and adjust the range. New rows typed below the data aren’t added on their own. Turning the data into a table first (Ctrl + T) means the chart picks up new rows automatically. To learn how tables work, read about making an Excel spreadsheet update automatically. A PivotChart needs a refresh instead: right-click it and choose Refresh Data after you add rows. A chart copied into Word can be pasted as linked or embedded, as explained in making a graph in Word.

To remove the chart, click its border and press Delete. Your data stays in the sheet.

Troubleshooting Pie Chart Problems

  • The pie is one solid circle or one giant slice. Excel is reading your data the wrong way, or a total is included. Click Chart Design > Switch Row/Column, or delete the chart and select only the labels and one column of numbers.
  • Only part of the data shows. A pie draws one data series, so only the first number column is used. Make a separate pie for each column, or use a column chart.
  • A category is missing. Check that its value isn’t zero, blank, or text that only looks like a number, and open Chart Filters to make sure it’s still checked.
  • The percentages look wrong. A negative number throws off the total. Remove it or use a bar chart, which can show values below zero.
  • There’s no + button next to the chart. Use Chart Design > Add Chart Element instead. This is the normal route on a Mac.
  • The labels overlap. Make the chart larger, rotate the pie, drag individual labels, or move small slices into a Pie of Pie chart.
  • The chart buttons are grayed out. Press Enter to finish editing the current cell, and make sure the sheet isn’t protected or open as read-only.

To summarize the same data by category before you chart it, see how to create a pivot table in Excel.

Excel Pie Chart Questions

How do I rename a slice in the legend?

Edit the category name in its cell. The legend and any data labels update to match.

Can I show both the number and the percentage?

Yes. In the Format Data Labels pane, check both Value and Percentage under Label Contains. Excel separates them with the character set in the Separator box.

Can I use percentages I already calculated?

Yes, but Excel calculates them for you from the raw numbers. If you need them in cells too, use a percentage formula in Excel. To show text from cells on the slices, check Value From Cells under Label Contains and select those cells.

How do I make a pie chart from two columns of numbers?

You can’t in a single pie, because a pie plots one data series. Make two pies, use a doughnut chart with one ring per series, or use a clustered column chart to compare them side by side.

Can I make the same chart in Google Sheets?

Yes. The steps are different, so follow the steps for making a graph in Google Sheets and pick Pie chart as the chart type.