A pie chart shows how a whole is divided into parts, such as the share of sales by product or the share of a budget by category. Excel can build one in seconds, and with a few formatting steps it becomes clear enough for a client report or a presentation. This guide shows how to prepare your data, insert a pie chart, add percentage labels, change colors, pull out a slice, build a pie of pie for small categories, and fix common problems. It also explains when a pie chart is a poor choice, because a bar chart often communicates better, and gives rules for keeping your charts honest and easy to read.
Updated November 2026
In this guide
- When to use a pie chart
- Prepare your data
- Step 1: insert the pie chart
- Step 2: add percentage labels
- Step 3: change colors and style
- Step 4: sort the data and set the first slice angle
- Step 5: explode or pull out a slice
- Pie of pie and bar of pie for small categories
- Doughnut charts and 3-D pies
- Make the chart update automatically
- Pie chart or bar chart
- Worked example: budget report for a client
- Quick recap
- Common mistakes
When to use a pie chart
A pie chart works when you have one data series, a small number of categories, all values are positive and together they make a meaningful whole. A good example is a monthly budget of 2,000 split into rent 800, food 500, transport 300, savings 250 and other 150. Those parts add up to 2,000, and each slice shows a share of the total. A pie chart is a poor choice when you have more than five or six categories, when values are close together, or when you want to compare values over time. In those cases, use a column or bar chart, which is easier to read accurately.
Prepare your data
Put the category names in one column and the values in the next, with a header in the first row. Use the sample budget below in A1:B6.
| Category | Amount |
|---|---|
| Rent | 800 |
| Food | 500 |
| Transport | 300 |
| Savings | 250 |
| Other | 150 |
Check that the values add up to the expected total with =SUM(B2:B6), which returns 2,000. Remove blank rows and make sure there are no negative numbers, because a pie chart cannot show them. If the numbers are stored as text, convert them first, as shown in our guide to converting text to numbers in Excel.
Step 1: insert the pie chart
Select A1:B6, go to the Insert tab, click the Pie or Doughnut chart button, and choose 2-D Pie. Excel places a chart on the sheet, with a title that you can edit. The chart title usually says Amount, so click it and type a clearer one, such as Monthly budget by category. Do not select the total row if you have one, because the total would appear as the largest slice and make the chart wrong.
Step 2: add percentage labels
Click the chart, then click the plus button at the top right, which is Chart Elements, and tick Data Labels. Click the arrow next to Data Labels and choose More Options. In the pane, tick Percentage and untick Value if you want only percentages, or keep both. For the sample, the slices are rent 40 percent, food 25 percent, transport 15 percent, savings 12.5 percent and other 7.5 percent, because 800 divided by 2,000 is 0.4, and 500 divided by 2,000 is 0.25. Set the label position to Outside End or Best Fit, and make the font large enough to read. You can also show the category name in the label and remove the legend, which makes the chart cleaner.
Step 3: change colors and style
Click the chart and open Chart Design on the ribbon. Click Change Colors to switch the palette, or choose a style from the gallery. To color one slice, click the slice twice, so that only that slice is selected, then use Format, Shape Fill. Use a limited set of colors. A common approach is to use one strong color for the slice you want to emphasize and softer greys or blues for the others. If the chart will be printed in black and white, choose a style that uses patterns or sort the slices so that labels explain the meaning without color.
Step 4: sort the data and set the first slice angle
Pie charts are easier to read when the slices go from largest to smallest, clockwise. Sort the data table in descending order before you insert the chart. Our sample is already in descending order, from rent at 800 down to other at 150. Then right-click a slice, choose Format Data Series, and set Angle of first slice to a value such as 0, so that the largest slice starts at the 12 o’clock position. Consistent starting angles across several charts make them easier to compare.
Step 5: explode or pull out a slice
To highlight one category, click the slice twice and drag it away from the center. Alternatively, use Format Data Series and set Point Explosion to a small percentage, such as 10 percent. Use this for one slice only. Exploding every slice makes the chart harder to read and can distort the sense of proportion. Pulling out the savings slice, for example, draws attention to how much of the budget is saved.
Pie of pie and bar of pie for small categories
If you have many small categories, use Pie of Pie or Bar of Pie, found under the 2-D Pie options. These charts combine the smallest slices into one slice named Other, and then show that slice broken down in a second pie or bar. Right-click the chart, choose Format Data Series and set how many values go to the second plot, such as the last 3 values. This keeps the main pie readable while still showing the details of small categories. Use it when the small slices would otherwise be too thin to label.
Doughnut charts and 3-D pies
A doughnut chart is a pie with a hole in the middle. It can show several series in rings, but the outer rings are harder to compare, so use it with one series unless there is a clear reason. A 3-D pie looks decorative, but the perspective makes front slices look bigger than back slices, which distorts the data. For client reports, use 2-D charts. Keep the design simple, avoid shadows and gradients, and use the same fonts as the rest of the document.
Make the chart update automatically
The chart is linked to the cells, so if you change a value, the slices change right away. If you add a new category at the bottom of the table, a normal range will not include it, so convert the data to an Excel table with Insert, Table. A chart based on a table grows when you add rows. You can also build the data with formulas, such as SUMIFS from a transaction list, as shown in our SUMIFS guide, so the chart updates when new transactions are added. For a monthly report, link the chart to a summary table and refresh it by changing a month in a drop-down cell, as shown in our drop-down list guide.
Pie chart or bar chart
A bar chart is better when categories are close in size, when there are many categories or when exact comparison matters. People judge lengths on a common baseline more accurately than angles or areas. If your audience needs to compare food at 25 percent and transport at 15 percent, a bar chart shows the gap clearly, while a pie shows only a rough difference. Use a pie when the point is a share of the whole, such as that rent takes 40 percent of the budget. If you are unsure, build both and decide which one makes your point faster.
Worked example: budget report for a client
A client wants a one-page summary of a monthly budget of 2,000. Build the table in A1:B6, add a total cell with =SUM(B2:B6), and a share column with =B2/$B$7 formatted as a percentage, where B7 holds the total. Insert the pie chart from A1:B6, add category names and percentages as labels, and delete the legend. Give the chart the title Monthly budget: 2,000. Use a dark blue for rent, because it is the largest item, and lighter tones for the rest. Place the chart next to the table, so the reader sees the numbers and the picture together. Add a short note below, such as Rent is 40 percent of the budget and savings are 12.5 percent. Finally, set the print area and check the page in Print Preview. This simple layout is often all that a client needs, and it can be built in about ten minutes once you know the steps.
Quick recap
Prepare one column of categories and one of positive values, insert a 2-D pie, add percentage labels, sort from largest to smallest, and keep colors simple. Use Pie of Pie for small categories, avoid 3-D effects, and switch to a bar chart when you need accurate comparison. Base the chart on an Excel table so that it updates when you add data.
Common mistakes
The most common mistake is to include the total row in the selected range, so that the total becomes a slice. Another is to use too many categories, which creates thin slices that cannot be read. A third is to use negative values or zeros, which pie charts cannot show properly. A fourth is to rely on color alone to identify slices, without labels. A fifth is to use 3-D effects. Finally, always check that the percentages add up to 100 percent, and mention the total in the title or a note so readers know what the whole represents.
Frequently asked questions
How do I make a pie chart in Excel?
Select the categories and values, go to Insert, choose Pie, and then add data labels.
How do I show percentages on a pie chart?
Add Data Labels, open More Options and tick Percentage.
How many categories should a pie chart have?
Use no more than five or six, otherwise a bar chart is clearer.
Can a pie chart show negative values?
No. Pie charts cannot display negative numbers correctly.
How do I make the chart update when I add data?
Use an Excel table as the source of the chart.


