How to Create a Pie Chart in Excel (Step-by-Step)
Pie charts are a native Excel chart type available in all versions. Two columns of data — category labels and values — are all you need. This guide covers inserting the chart, adding percentage labels, exploding a slice to draw attention, and formatting colors. It also covers when a bar chart is the better choice.
What is a pie chart in Excel?
A pie chart in Excel displays proportional data as circular slices. Each slice's angle and area corresponds to its share of the total — a slice representing 25% occupies a quarter of the circle. Pie charts are most effective with 3–6 categories where at least one category is notably larger or smaller than the others. Excel supports 2D pies, 3D pies, pie-of-pie, and bar-of-pie variants from the same Insert menu.
6 steps to make a pie chart in Excel
Prepare your data
Create two columns: category labels and values. Values must be positive numbers — pie charts cannot display negative values. Keep to 3–6 rows for a readable chart. If you have more categories, combine the smallest ones into a single 'Other' row before inserting.
Select your data range
Click and drag to select both columns including the header row. If your data has a total row at the bottom, do not include it in the selection — it would create an extra slice equal to the sum of all others.
Insert the pie chart
Go to Insert → Charts → Insert Pie or Donut Chart → 2-D Pie. Excel creates the chart immediately with default colors. The slices are sorted by the order of your data rows, not by size — you may want to sort your data largest-to-smallest before inserting for a cleaner layout.
Add percentage labels
Click the chart → Chart Elements (+) → Data Labels → check the checkbox. Right-click any label → Format Data Labels → check Percentage → uncheck Value. Labels now show calculated percentages. Optionally check Category Name to show both the label and percentage on each slice.
Explode a slice for emphasis
To pull one slice out for visual emphasis: click the pie once (selects all slices), then click the specific slice you want to highlight (selects only that slice). Drag it outward from the center. Alternatively, right-click the selected slice → Format Data Point → Point Explosion → enter 10–20%. Only explode one slice — exploding multiple defeats the purpose.
Format colors
Excel assigns default colors automatically. To change them: click once to select the series, then click a specific slice → Format Data Point → Fill → select your color. Repeat for each slice. For a consistent look, keep adjacent slices clearly distinguishable. Remove the chart border: Format Chart Area → Border → No Border.
When to use a pie chart in Excel
Market share and competitive breakdown
Show how a market is divided among competitors. Works best when one or two players dominate — the large slice is immediately obvious.
Budget and expense allocation
Visualize how a total budget is split across departments or categories. Each slice shows what percentage of the whole that cost center represents.
Survey results with a dominant answer
If one answer choice accounts for 60%+ of responses, a pie chart communicates that dominance more viscerally than a bar chart.
Simple composition for general audiences
Pie charts are universally understood. For audiences unfamiliar with data visualization, a pie is often the least intimidating format.
Components of a pie chart in Excel
Slices
Each slice represents one category. Slice angle and area are proportional to the category's value as a share of the total. Excel calculates proportions automatically.
Data labels
Text annotations on or near each slice showing value, percentage, category name, or a combination. Added via Chart Elements → Data Labels.
Legend
Color-coded key matching slice colors to category names. Can be repositioned or replaced entirely by adding category name labels directly on the slices.
Exploded slice
A single slice pulled away from the center for visual emphasis. Used to highlight a key finding, winner, or problem area. Only one slice should be exploded at a time.
Frequently Asked Questions
Related