The basic steps to make a pie chart

To create a pie chart in Excel, you first select the data you want to visualize, then use Excel's chart tools to convert it into a pie shape. The process takes about two minutes once your numbers are in place. Excel handles the math — you just tell it which cells to use and what kind of chart you want.

Start by highlighting the data you want to show. This usually means selecting a column of labels (like "Sales", "Marketing", "Operations") and a column of numbers next to it (like 15000, 8000, 12000). Click and drag to select both columns, or click the first cell, hold Shift, and click the last cell. Make sure your labels and numbers are in adjacent columns.

Once your data is selected, go to the Insert tab at the top of the ribbon. Look for the Charts section — you'll see several chart icons. Click the one that looks like a pie (a circle divided into slices). Excel will show you different pie chart styles. The standard pie chart is usually the first option. Click it, and Excel creates your chart right on the spreadsheet.

Key Takeaways

  • Select your labels and numbers in two adjacent columns before inserting a chart — Excel needs both to build the pie.
  • Use the Insert tab and the Charts section to find the pie chart option, then pick the standard pie style unless you need a donut or 3D variant.
  • After the chart appears, you can click it to edit the title, move it around the spreadsheet, or resize it by dragging the corners.
  • Right-click on any slice to change colors, add data labels (the numbers or percentages on each slice), or explode a slice outward for emphasis.

Preparing your data the right way

Pie charts work best when you have a small number of categories — usually between three and six. If you have ten categories, the slices become too thin to read. Excel will still make the chart, but it becomes hard to interpret.

Your data should be organized straightforward: one column for what each slice represents (the category), and one column for the size of each slice (the number). If you're showing sales by region, put region names in one column and sales amounts in the next. Don't include totals or extra rows — Excel will try to chart them as separate slices, which creates confusion.

If your data has a header row (like "Region" and "Sales Amount" at the top), include it in your selection. Excel recognizes headers and uses them to label the chart automatically. If you skip the headers, Excel treats the first row as data instead.

Editing the chart after it appears

When Excel creates your pie chart, it lands on the spreadsheet as an object you can move and resize. Click the chart once to select it — you'll see a border around it with small squares at the corners and edges. Drag a corner square to resize the chart while keeping its proportions. Drag the chart itself to move it to a different spot on the spreadsheet.

To change the title, double-click the chart to enter edit mode. The title appears at the top. Click on it directly and type a new one. When you're done editing, click outside the chart to exit edit mode.

If you need to change which data the chart uses, right-click the chart and select Select Data. This opens a dialog where you can add or remove data series, change the labels, or swap out the entire dataset. This is useful if you realized you selected the wrong columns or need to update the chart with new numbers.

Adding labels and changing colors

By default, a pie chart shows only the slices with no numbers or percentages on them. To add labels, double-click the chart to enter edit mode, then right-click directly on one of the pie slices. Select Add Data Labels. Excel adds a label to each slice — usually the category name.

If you want percentages instead of names, right-click the labels themselves (not the slices) and choose Format Data Labels. A panel opens on the right side. Check the box next to Percentage and uncheck Category Name if you want only the percentage. You can also show both by checking both boxes.

To change slice colors, right-click a slice and select Format Data Point. A panel appears on the right where you can pick a new color. If you want to change all slices at once, right-click any slice and choose Format Data Series instead — this opens options for the entire pie.

When a pie chart is the wrong choice

Pie charts look clean and are straightforward to understand at a glance, but they have real limits. If you're comparing numbers that are close to each other — say 22%, 24%, and 26% — a pie chart makes those differences nearly invisible. A bar chart shows the same data much more clearly.

Pie charts also struggle when you have more than six categories. The slices become too small to label, and the chart becomes cluttered. If you have ten or more groups, a bar chart or column chart is almost always better.

If you need to show change over time, a pie chart won't work at all. Use a line chart or column chart instead. Pie charts show a snapshot of how something breaks down at one moment — they're not designed to show trends.

Pie chart variations in Excel

Excel offers a few pie chart variations beyond the standard pie. The donut chart looks like a pie with the center cut out — it works the same way but takes up less visual space. Some people find it easier to read because the slices are thicker.

The 3D pie chart adds depth and angle to make the chart look three-dimensional. It's visually interesting but can distort how you perceive the slice sizes — a slice that looks larger in 3D might actually be smaller than it appears. Use 3D pie charts only when appearance matters more than accuracy.

The exploded pie chart pulls one or more slices away from the center to emphasize them. You can create this by right-clicking a slice and dragging it outward, or by using the exploded pie option when you first insert the chart. This is useful when you want to highlight one category.

Moving and copying your chart to other places

Once your chart is finished, you might want to move it to a different worksheet or copy it into another file. Click the chart once to select it, then use Ctrl+X to cut it or Ctrl+C to copy it. Navigate to the new location and use Ctrl+V to paste it there.

If you paste a pie chart into a different Excel file, it brings the data with it — the chart stays connected to the original numbers. If you later change the numbers in the original file, the chart in the new file won't update automatically. To keep charts synchronized across files, you need to set up a link, which is more advanced. For most purposes, copying the chart is enough.

You can also copy a pie chart into Word or PowerPoint. The process is the same: select the chart, copy it, and paste it into the other program. In PowerPoint, the chart becomes an object you can resize and move around your slide.

Frequently Asked Questions

What if my data is in rows instead of columns?

Excel can handle data arranged either way. When you select your data, include both the row labels and the numbers. Excel usually figures out the correct orientation automatically. If the chart comes out wrong, right-click it, select Select Data, and swap the rows and columns using the button in the dialog.

Can I make a pie chart from data that's not next to each other?

Yes, but it's more work. Select the first column of data, then hold Ctrl and click the second column to add it to your selection without selecting everything in between. Then insert the chart as normal. Excel will use only the cells you selected.

How do I change the order of the slices?

Right-click the chart and select Select Data. In the dialog, you'll see a list of data series. Click an item and use the up and down arrows to reorder it. The pie will redraw with the slices in the new order.

Why does my pie chart have a slice labeled "Other"?

Excel creates an "Other" slice when you have too many small categories. It groups the smallest slices together to keep the chart readable. To fix this, you can manually combine those small categories in your original data, or right-click the chart, select Select Data, and remove categories you don't need.

Can I save a pie chart as an image?

Yes. Right-click the chart and select Save as Picture. Choose where to save it and what format you want (PNG or JPG are common). The chart becomes a standalone image file you can insert into documents or share separately.