Creating a pie chart in Excel takes four steps: select your data, insert the chart type, choose your layout, and adjust labels so the slices are readable
A pie chart shows how parts add up to a whole. Each slice represents a percentage of the total, and the size of the slice matches that percentage. Excel builds the chart automatically once you tell it which numbers to use and where to place it on your sheet.
The fastest route is to highlight your data, click Insert, pick Pie, and then add labels so readers know what each slice means. The chart updates if your numbers change, so you can use it as a living document rather than a static image.
Key Takeaways
- Your data needs two columns: one with category names and one with the numbers that represent each slice.
- Excel's Insert menu has a Pie option that creates the chart in seconds once you select your data range.
- Data labels showing percentages or values make pie charts readable; without them, viewers cannot tell which slice is which.
- You can move the chart anywhere on your sheet and resize it by dragging the corners, and it stays linked to your original data.
Setting up your data the way Excel expects it
Excel needs two columns to build a pie chart. The first column holds the category names — the labels that will appear on or near each slice. The second column holds the numbers that determine slice size. If you are tracking sales by region, your first column might say "North", "South", "East", "West", and your second column would show the dollar amount or unit count for each.
Put your category names in one column and numbers in the column right next to it. Do not leave blank rows between entries. If your data has a header row — a row at the top that says "Region" and "Sales" — include that row when you select your data. Excel recognizes headers and keeps them out of the chart itself.
The numbers in your second column should all be positive. Negative numbers or zeros can create charts that look broken or misleading. If you have a zero value, the slice straightforward will not appear, which is usually what you want.
Selecting your data and inserting the chart
Click on the first cell of your data — the top-left cell of your category column — and drag to the last cell of your numbers column. This selection should form a rectangle that includes all your categories and all your numbers. If you included a header row, make sure it is part of your selection.
Once your data is highlighted in blue, go to the Insert tab at the top of the ribbon. Look for a button labeled Pie Chart or straightforward Pie. Click it. Excel will show you several pie chart styles: a standard pie, a doughnut (which is a pie with a hole in the middle), and a few variations. Click the standard pie chart — the first option — unless you have a specific reason to use a different style.
Excel inserts the chart right on top of your data. It is not permanent in that location. You can click and drag the chart to move it anywhere on your sheet, or drag the small squares at its corners to make it larger or smaller.
Adding labels so people can read the chart
A pie chart without labels is nearly useless. Readers cannot tell which slice is which just by looking at colors. Right-click on the chart and select Add Chart Element, or look for a small plus sign that appears when you click the chart. From there, choose Data Labels.
Excel will add small text boxes to each slice. By default, these show the raw numbers from your data. You usually want to change this to show percentages instead, because percentages tell the story of a pie chart — they show what portion of the whole each slice represents. Right-click on one of the data labels and select Format Data Labels. Check the box next to Percentage and uncheck the box next to Value. Click Close.
If your chart has many small slices, the labels can overlap and become unreadable. In that case, consider using a legend instead. Remove the data labels, then right-click the chart and add a Legend. A legend is a box that matches each color to a category name, placed outside the pie so it does not crowd the slices.
Adjusting the title and appearance
By default, Excel gives your chart a generic title like "Chart Title". Right-click the title text and select Edit Text, then type a title that describes what the pie shows — for example, "Sales by Region" or "Budget Breakdown by Department". This title helps anyone viewing the chart understand what they are looking at.
You can change the colors of the slices by right-clicking the chart, selecting Change Colors, and picking a color scheme. Excel offers several built-in palettes. You can also right-click a single slice to change just that one color, which is useful if you want to highlight one category.
If you want to rotate the pie so a particular slice starts at the top, right-click the pie itself and select Format Data Series. Look for Angle of First Slice and change the number. This is mostly for appearance and does not change the data.
Updating the chart when your data changes
The chart is linked to your original data. If you change a number in your data column, the pie chart updates automatically. The slice sizes shift, and the percentages recalculate. This means you can build the chart once and then update it by editing the numbers in your spreadsheet.
If you add new rows of data below your original selection, the chart will not include them automatically. You need to tell Excel about the new data. Right-click the chart, select Select Data, and change the data range to include the new rows. After that, the chart will update to include the new categories and numbers.
Common reasons pie charts look wrong
If your pie chart shows only one giant slice and the rest are invisible, check your data. This usually means one number is much larger than all the others — for example, if one region has sales of 10,000 and all others have sales under 100, the large slice will dominate. The chart is correct; the data is just unbalanced. You can still read it if you use data labels showing percentages.
If the chart shows no slices at all, your data column probably contains text instead of numbers. Excel cannot build a pie from words. Check that your numbers column contains actual numbers, not text that looks like numbers. Numbers are right-aligned in their cells; text is left-aligned.
If labels are overlapping or hard to read, switch to a legend or reduce the number of categories. A pie chart with more than five or six slices becomes difficult to read no matter what you do. If you have many small categories, consider grouping them into an "Other" category.
Frequently Asked Questions
Can I make a pie chart from data that is not in two columns?
Yes, but you may need to rearrange it first. Excel expects categories in one column and numbers in another. If your data is spread across multiple columns or rows, select only the two columns you want to chart. You can always create multiple charts from the same data if you want to show different breakdowns.
What is the difference between a pie chart and a doughnut chart?
A doughnut chart is a pie with a hole in the middle. It shows the same information but takes up less visual space. Some people find doughnuts easier to read because the slices are wider. The choice is mostly about appearance — both show percentages of a whole equally well.
How do I remove a pie chart I no longer need?
Click the chart once to select it, then press Delete. The chart disappears, but your original data stays in place. Deleting a chart does not affect the numbers in your spreadsheet.
Can I export the pie chart to use in a document or presentation?
Yes. Right-click the chart and select Copy. Then open your document or presentation software and paste it. The chart will appear as an image. If you later change the numbers in Excel, the chart in your document will not update automatically — you would need to copy and paste the new version.
What if I want to show the actual numbers instead of percentages on the slices?
Right-click a data label and select Format Data Labels. Check the box next to Value and uncheck Percentage. The labels will now show the raw numbers from your data instead of percentages. You can show both by checking both boxes, though this can make the chart crowded.