Creating a Pie Chart in Excel: Steps, Labels, and Tips

To create a pie chart in Excel for Microsoft 365 on Windows, arrange category names beside their values, select both columns, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Add or adjust labels with the Chart Elements button or Chart Design > Add Chart Element, then check that the slices communicate meaningful parts of one whole.

Prepare the data before inserting a chart

A pie chart compares categories as shares of a total. The clearest source data has one category column and one numeric column, with a heading at the top of each. For example, a small shop might enter Product in A1 and Units Sold in B1, then list notebooks, pens, folders, and markers with their sales totals in rows 2 through 5. Selecting A1:B5 gives Excel both the category names and values it needs.

Keep the data in a simple rectangular range. Remove completely empty rows or columns from between the heading and the values, and check that the numbers are stored as numbers rather than text. You do not need to calculate percentages first: Excel can derive each slice’s share from the values. If the example values are 40, 30, 20, and 10, the total is 100, so the four shares are 40%, 30%, 20%, and 10%.

Before charting, ask whether the data represents one complete set of parts. A pie chart is suitable for category totals that add up to a meaningful whole, such as a department’s share of a company’s spending in one year. It is less appropriate when values are unrelated, overlap, or refer to different totals. Avoid including a grand-total row as though it were another category: doing so adds the total on top of its components and distorts every slice.

Create the pie chart step by step

Click and drag to select the category labels and the corresponding values, including the column headings if present. In the example, select A1:B5.
On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
Under 2-D Pie, select the standard Pie option. Excel inserts the chart on the worksheet.
Click the chart title and type a specific title, such as Units Sold by Product. If the title is not displayed, use Chart Design > Add Chart Element > Chart Title.
Add labels if they will help readers identify the slices. Select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a position, or click the Chart Elements button next to the chart and check Data Labels.

The exact visual arrangement depends on the chart style and available space. You can move a chart by dragging its border and resize it with the handles at its corners. To move it to its own worksheet, select the chart and choose Chart Design > Move Chart. A separate chart sheet can be useful for a presentation or print layout; keeping it beside the source data is often more convenient while editing.

Show category names and percentages

Labels make a pie chart easier to read when the colors alone are not enough. To display percentages, select the chart, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, and in the Format Data Labels pane select Percentage. You can also select Category Name or Value. Clear options you do not want, so a label does not become crowded with the category, raw value, and percentage all at once.

Percentages are calculated from the plotted values. With values of 40, 30, 20, and 10, the chart shows 40%, 30%, 20%, and 10%. If you choose both Value and Percentage, Excel displays both the original amount and its share. That can be useful when readers need to know that a category represents 30% as well as 30 units. Check the labels against the source data, particularly if the chart uses filtered rows or a customized data range.

For small slices, labels placed inside the pie may overlap or be hard to read. Try an outside label position, enlarge the chart, or remove unnecessary label details. You can format labels by selecting them and using the Format Data Labels pane. Keep the category names visible somewhere if the chart relies on a legend rather than labels next to slices.

Choose a chart style that fits the message

Excel offers several pie-related chart types, but the standard 2-D pie is often the most straightforward. A 3-D pie adds perspective that can make front slices appear larger than slices of the same value toward the back. That visual distortion makes comparisons less reliable, so use 3-D only when the decorative effect matters more than precise reading.

A doughnut chart is similar to a pie chart but leaves a hole in the center. It can work well for a simple display and may leave room for a central label, though it still represents one series and has the same limitations when comparing slice sizes. A pie-of-pie or bar-of-pie chart can separate smaller values into a secondary display, but the split needs to be explained so viewers understand how the smaller categories relate to the main total.

Color choices should distinguish categories without suggesting an unintended ranking. Use a consistent, restrained palette and preserve enough contrast between neighboring slices. If the chart is part of a report, consider whether its colors remain distinguishable for readers with color-vision differences and whether labels can convey the same information without relying on color alone.

Know when a pie chart is not the best choice

Pie charts work best with a small number of categories whose shares are meaningfully compared with one total. There is no universal cutoff for the number of slices, but a chart with many similar-sized slices becomes difficult to scan, label, and compare. Grouping minor categories into Other can reduce clutter, provided that the grouping is transparent and appropriate for the purpose.

A bar or column chart is usually easier when the main task is comparing exact values or ranking categories. People can judge the lengths of bars more accurately than the angles or areas of pie slices, especially when values are close. A stacked bar can show parts of a whole while making it easier to compare categories across several groups. A line chart is generally more suitable for showing change over time. Choose a chart based on the question the reader needs to answer, not just on the shape available in the Insert tab.

Fix common pie-chart problems

The chart has the wrong labels or values: Select the chart and choose Chart Design > Select Data. Check the chart data range and the category labels. Correct the selected range or adjust the series and category entries in the dialog.
Excel plots the headings as a slice: Reopen Select Data and make sure the range includes the heading row in the intended layout. If necessary, edit the category labels and series values so only numeric entries form the series.
A category is missing: Confirm that its row is inside the chart’s data range and that the value is numeric. Also check whether a worksheet filter or hidden data setting affects what the chart displays.
The slices look equal or labels seem wrong: Inspect the source values and confirm that Excel is using the intended numeric cells. A pie chart displays proportions, so different raw values can look similar when their shares are close.
There is a blank or unexpected slice: Look for an extra row in the selected range, an accidental total, or a value that should not be included. Remove or correct it in the source data, or revise the chart’s data range.
Negative values are present: A pie chart cannot represent negative parts of a positive whole in a meaningful way. Check the source and choose a chart type that can communicate the signed values instead.

Zeros do not create visible slices, which can leave a category in the legend without an obvious segment. Blank cells also provide no positive share to display. If these values matter, explain them in a note or choose a different chart that makes missing or zero values clearer.

Edit, update, and share the chart

When the source values change, a chart linked to those cells normally updates with them. If you add new categories below the original range and they do not appear, select the chart and use Chart Design > Select Data to extend the chart data range. An Excel table can make expanding data easier to manage: select the source range and choose Insert > Table, then create the chart from the table. Check the result after adding rows, especially if the workbook has been reorganized or the chart range was set manually.

To change colors or the overall appearance, select the chart and explore the Chart Design tab’s chart styles and color options. To change one slice independently, select the chart and then select the slice again before applying a formatting choice; verify that only the intended point is selected. Avoid pulling slices apart merely for decoration, because exploded slices can imply emphasis that the data does not support.

On Excel for Mac, the ribbon and chart commands are broadly similar, although their placement or wording can vary slightly by release. Excel for the web also supports inserting and editing charts, but some detailed formatting controls may be more limited or arranged differently than in the Windows desktop app. If a particular pane or command is unavailable in the web version, open the workbook in desktop Excel for the fuller set of chart-formatting options.

Frequently Asked Questions

How do I make a pie chart in Excel with percentages?

Select the category and value cells, insert a 2-D pie chart, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options and select Percentage in the Format Data Labels pane.

Can a pie chart show more than one data series?

A standard Excel pie chart represents one data series at a time. If you have multiple groups to compare, use separate pie charts cautiously or choose a bar, column, or stacked chart that can show the groups together more clearly.

Why is my pie chart missing a category?

Check whether the category is included in the selected data range and whether its value is numeric and greater than zero. Also check for filters, hidden rows, or an accidental blank in the source range.

How can I change the order of the slices?

Reorder the category rows in the source data, then check whether the chart updates as intended. The order of pie slices follows the order of the plotted categories, so arranging the source rows can make a desired sequence easier to maintain.

Can I make a pie chart from non-adjacent cells?

It is usually simpler to place labels and values in adjacent columns and select one continuous range. You can select non-adjacent ranges in desktop Excel by holding Ctrl on Windows while selecting, but make sure the label and value ranges correspond; rearranging the data into a compact table is less error-prone.

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.