How to Make a Pie Chart in Excel (2026)
Pie charts show part-to-whole relationships. This guide covers how to build one, when they work, and — importantly — when to use a bar chart instead. Pie charts are the most misused chart type; using them right matters more than knowing the clicks.
⚡ Quick Answer
Select category labels and values (two adjacent columns). Insert tab → Pie chart icon → 2D Pie. Chart inserts on the current sheet. Best for 2-5 categories with one dominant slice.
Method: Insert tab (standard)
Set up your data
Two columns — categories in one, values in the other. Optional header row.
Select the range
Include headers. Don't include totals (Excel will treat them as another slice).
Insert tab → Pie chart icon
The icon looks like a pie chart. Dropdown shows 2D Pie, 3D Pie, Doughnut, Pie of Pie, Bar of Pie.
Pick 2D Pie or Doughnut
Avoid 3D — it distorts slice sizes. Pie-of-pie is rarely useful.
Click to insert
Chart appears on the current sheet.
Adding data labels
Pie charts without labels are guessing games. Always add labels.
Click the chart → click the + icon
Chart Elements panel opens.
Tick "Data Labels"
Basic labels appear on each slice.
Choose what to show
Right-click labels → Format Data Labels → tick Value, Percentage, or Category Name. For most cases, Category + Percentage is best.
Position labels
Options: Center, Inside End, Outside End, Best Fit. Outside End with lines is most readable.
Rotating slices for emphasis
By default, the first slice starts at the top (12 o'clock). To rotate:
- Right-click the pie → Format Data Series
- Angle of first slice → change from 0° to whatever positions your emphasis slice best (often 90° or 180°)
Rotate so the biggest slice starts at 12 o'clock — that's the first slice the eye sees.
Exploding a slice
To pull one slice out for emphasis:
- Click the pie once (selects all slices)
- Click the specific slice you want to explode (selects just that one)
- Drag it outward slightly
Use sparingly. Exploded slices can look gimmicky. A different color usually works better.
When NOT to use a pie chart
Slice sizes become too similar to compare visually. Use a horizontal bar chart sorted by size.
If slices are all roughly 20%, the pie tells you almost nothing. Bar chart makes small differences readable.
Humans compare bar heights better than pie slice angles. If exact percentages matter, use a bar.
Comparing "market share Q1 vs Q2" using two pies side-by-side is worse than a single stacked bar chart. Never make readers eyeball two pies to find differences.
Donut charts
Same as pie but with a hole in the middle. Functionally identical for reading data — the hole is purely aesthetic.
Central value in a donut
The hole gives you space to place a total or context text. Insert → Text Box, size it to fit the hole, add your total value (e.g., "$1.2M total revenue"). Instant KPI-style donut.
If you can replace your pie with a bar chart without losing information, do it. Bars almost always communicate better. Pie charts earn their place only when the "part of a whole" story is stronger than exact comparison.
The right chart, automatically
Not sure if your data is pie-worthy or belongs in a bar chart? Excel Wizard analyzes your data and picks the right chart type before building it. Describe what you want to show — it handles the choice, the build, and the formatting.
Install Excel Wizard →Frequently asked questions
How do I make a pie chart in Excel?
Select your data range with categories in one column and values in another. Go to Insert tab → Pie chart icon → pick 2D pie or donut. Excel inserts the chart on the current sheet.
When should I use a pie chart?
Use pie charts only when you have 2-5 categories that add up to 100% and one slice is dominant. If you have 6+ categories, similar-sized slices, or need precise comparison, use a bar chart instead.
How do I add data labels to a pie chart?
Click the chart → click the + icon on the right → tick Data Labels. Or right-click any slice → Add Data Labels. Then right-click the labels → Format Data Labels to choose what shows.
What's a donut chart vs a pie chart?
A donut chart is a pie chart with a hole in the middle. Functionally identical for reading data. Donuts have slightly less visual weight and let you place a central value (like a total).