Add a Pie Chart in Excel: Labels, Slices, and Tips

To add a pie chart in Excel for Microsoft 365 on Windows, arrange category names in one column and their values in the next, select the data, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel inserts a chart you can label, format, resize, and move; the chart updates when its source values change.

Prepare the data before inserting a chart

A pie chart compares parts of one whole. Each slice represents a category’s share of the total, so organize the source as a single series of nonnegative values with a category beside each value. For example, a small shop might list product lines in A2:A5 and quarterly sales in B2:B5: Books, 40; Games, 30; Gifts, 20; and Cards, 10. The total is 100, so the slices correspond to 40%, 30%, 20%, and 10%.

Include clear column headings, such as Product and Sales, above the categories and numbers. Do not include a grand-total row in the selected data: Excel can treat it as another category, making the chart misleading. Select only the heading and category rows, or select the category and value cells without the headings if you prefer to add chart labels yourself.

Keep categories in one column and their numeric values in the adjacent column.
Use one series of values; a standard pie chart is not designed to compare multiple series.
Check for blank cells, text stored as numbers, duplicate categories, and negative values before charting.
Use a meaningful category name for every value so the legend and labels can identify slices.

If the source data is not next to each other, select the category cells, then hold Ctrl while selecting the value cells on Windows. On a Mac, use Command while making the additional selection. A contiguous two-column layout is usually easier to maintain and less likely to produce an unexpected chart.

Insert a basic pie chart

Select the prepared range, including its headings if present.
On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
Under 2-D Pie, select the basic Pie option. Excel places the chart on the current worksheet.
Click the chart title and type a specific description, such as Quarterly Sales by Product Line.

The chart uses the selected values to calculate each category’s share of their sum. In the example, Books makes up 40 out of 100, so it occupies 40% of the circle. The displayed order normally follows the order of the source rows. Reordering the source therefore changes the slice order, which can help put categories in a meaningful sequence.

If Excel creates a chart with the wrong categories or values, select the chart and open Chart Design > Select Data. In the Select Data Source dialog, review the chart data range and the series and category assignments. Adjust the range or use the row-and-column switch option if Excel has interpreted the layout in the opposite direction. For a conventional pie, the result should be one series and a list of category labels.

Show category names, values, and percentages

A pie’s shape shows relative size, but a reader may not be able to estimate a slice precisely. Data labels provide the exact context. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a placement such as Best Fit, Outside End, or Center. You can also use the Chart Elements button, shown as a plus sign beside a selected chart in desktop Excel, and turn on Data Labels.

To choose what a label contains, right-click a data label and select Format Data Labels. In the Format Data Labels pane, use Label Options to select or clear Category Name, Value, and Percentage. For example, a share-of-budget chart may benefit from category names and percentages, while a chart used to report actual quantities may need values. Displaying every option can make labels crowded, particularly when there are many slices.

Excel calculates a displayed percentage as the slice value divided by the sum of the plotted values. If you want percentages to total 100%, use values that represent the complete whole and avoid excluding relevant categories. Rounding can make the displayed labels add up to 99% or 101%, even though the underlying proportions sum to 100%; that is a rounding effect, not necessarily a data error.

A legend can identify categories, but it takes space and may force readers to match colors across the chart. For a chart with only a few slices, category names on the labels can be quicker to read. If you keep both labels and a legend, check that the chart is not visually crowded.

Format slices and make the chart readable

Select the chart to reveal the Chart Design and Format tabs. Chart Design offers chart styles, colors, chart elements, and layout options. Format provides controls for chart components and shape appearance. You can also use the chart’s context menu to format a selected slice or other element. Formatting options vary somewhat with the selected object, so select the chart area, plot area, or individual slice before applying a change.

Choose colors that distinguish categories without making the chart look like decoration. If one category is the focus, you can select its slice and change its fill, or use a pie-chart variation that separates a slice from the rest. Use separation sparingly: pulling several slices outward can imply that those categories are more important or disconnected from the whole. Keep labels readable against their background and do not rely on color alone when the chart needs to be accessible.

To move a chart, drag its border. To change its size, drag a corner handle so the chart retains its proportions. If you want it on a separate sheet, select the chart and choose Chart Design > Move Chart, then choose New sheet or Object in and select a destination sheet. A separate chart sheet can be useful for a presentation or printout; an embedded chart stays near its source data for review.

For consistent reporting, use a clear title, restrained colors, and a sensible number of labels. Avoid 3-D effects when accurate comparison matters: perspective can distort how slice sizes appear. A flat 2-D pie makes the proportions easier to judge.

Know when a pie chart is a good choice

Use a pie chart when the question is how a small set of categories divides one total, and when the categories are mutually exclusive and collectively represent the whole. Examples include how a fixed monthly budget is split among a few expense groups, how survey responses divide among answer choices, or how sales are distributed across a handful of product lines.

Pie charts become hard to interpret when there are many categories or several slices of similar size. Readers compare angles and areas less precisely than aligned bar lengths, so a pie is not ideal when the main task is ranking close values. A large number of small categories also leads to cramped labels and a confusing legend. Combining minor categories into an Other group can sometimes help, but only if that grouping is meaningful and transparent.

A pie chart is also unsuitable for showing change over time. Placing a separate pie for every month makes it difficult to compare slices from one circle to another. A line chart can show a trend, while a column or bar chart often works better for comparing categories or periods. The chart type should match the question, not just the shape of the data.

Common problems and how to fix them

The chart includes a total as a slice: Select the chart and choose Chart Design > Select Data. Correct the source range so it includes the category values but not a separate total row.
There is no chart or a category is missing: Check that the selected cells include the intended values and labels. Confirm that values are numeric and that blank rows have not interrupted the data range.
A negative value causes a problem: Pie charts represent proportions of a positive whole. Investigate why the value is negative and choose a chart that can represent the data accurately rather than treating the negative number as an ordinary slice.
The labels overlap: Show fewer label fields, choose a different placement, enlarge the chart, or move category names to a legend. If there are many small categories, use a bar chart instead.
The percentages seem wrong: Confirm that the chart includes the intended categories and no extra values. Excel calculates shares using only the values in the plotted series, so omitting a category changes every displayed percentage.
New rows do not appear: Check the chart’s source range in Chart Design > Select Data. If the data is a consistently maintained Excel table, adding rows directly below it generally expands the table; verify the chart range if it does not include the new entries.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, the same basic process applies: select the data, open the Insert tab, choose the pie chart option, and select a 2-D Pie chart. Ribbon placement and some dialog details can differ from Windows, and the Windows Ctrl selection key is generally Command on Mac. The Chart Design tab and chart formatting controls provide ways to edit the chart after insertion.

Excel for the web also supports creating and editing charts from selected worksheet data. Select the range, use Insert and the chart options to choose a pie chart, then use the chart controls available in the browser to adjust its title and appearance. Some advanced formatting controls or dialog layouts may differ from desktop Excel. If a particular control is unavailable in the browser, open the workbook in the desktop app and make the change there.

Frequently Asked Questions

How do I add percentages to a pie chart in Excel?
Select the chart, add data labels through Chart Design > Add Chart Element > Data Labels, then right-click a label and choose Format Data Labels. Under Label Options, select Percentage. You can also select Category Name or Value if those details are useful.

Can I make a pie chart with two columns of data?
Yes. Use one column for category names and the adjacent column for the values that form the pie. A pie chart represents one series of values; it is not intended to show two independent value columns as two separate rings or groups.

Why does my Excel pie chart show the total as a slice?
The selected source range probably includes the total row. Select the chart, open Chart Design > Select Data, and adjust the source range to exclude the total. The total is useful for checking the data but should not be counted as another category in the chart.

How do I change the colors of individual pie slices?
Select the chart, then select the slice you want to change. Open the Format tab or the slice’s formatting options and choose a different fill color. Make sure the colors remain easy to distinguish and that the chart still communicates its categories clearly.

Can a pie chart update when I change the numbers?
Yes. A chart linked to worksheet cells updates when those source values change. If you add categories, check whether the chart’s data range includes the new rows; using a well-maintained Excel table can make it easier to keep a changing source range together.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.