How to Make a Pie Chart in Excel (2026 Guide)
Home›Excel Charts›Make a Pie Chart
ExcelHow-To⏱ 2 min read

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)

  1. Set up your data

    Two columns — categories in one, values in the other. Optional header row.

  2. Select the range

    Include headers. Don't include totals (Excel will treat them as another slice).

  3. 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.

  4. Pick 2D Pie or Doughnut

    Avoid 3D — it distorts slice sizes. Pie-of-pie is rarely useful.

  5. Click to insert

    Chart appears on the current sheet.

Adding data labels

Pie charts without labels are guessing games. Always add labels.

  1. Click the chart → click the + icon

    Chart Elements panel opens.

  2. Tick "Data Labels"

    Basic labels appear on each slice.

  3. Choose what to show

    Right-click labels → Format Data Labels → tick Value, Percentage, or Category Name. For most cases, Category + Percentage is best.

  4. 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:

  1. Right-click the pie → Format Data Series
  2. 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:

  1. Click the pie once (selects all slices)
  2. Click the specific slice you want to explode (selects just that one)
  3. Drag it outward slightly

Use sparingly. Exploded slices can look gimmicky. A different color usually works better.

When NOT to use a pie chart

6+ categories

Slice sizes become too similar to compare visually. Use a horizontal bar chart sorted by size.

Similar-sized slices

If slices are all roughly 20%, the pie tells you almost nothing. Bar chart makes small differences readable.

Precise comparison needed

Humans compare bar heights better than pie slice angles. If exact percentages matter, use a bar.

Multiple pies for comparison

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.

Rule of thumb

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.

Excel Wizard

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).