To create a doughnut 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 > Doughnut. Add labels and adjust the hole size if needed using the chart formatting tools.
What a doughnut chart shows
A doughnut chart displays parts of a whole as colored segments around a blank center. Each segment represents one category, and its size is proportional to that category’s value compared with the sum of all the values in the series. The shape is similar to a pie chart, but the open center can make room for a short label or simply create a less crowded look.
For example, a department might report 42 service requests for Billing, 28 for Delivery, 18 for Returns, and 12 for Account Access. The total is 100, so the chart segments represent 42%, 28%, 18%, and 12%. If the numbers instead total 250, Excel still calculates each category’s share of that total; the values do not have to add up to 100 before you chart them.
Doughnut charts are most useful when there are a few categories and the data describes one whole, such as a budget breakdown, survey responses, or a product mix. They are less effective for showing precise differences between similar values or changes over time. Readers generally compare lengths more accurately than angles, so a bar chart can be a better choice when exact comparisons matter.
Prepare the data before inserting the chart
Put each category in its own row, with a single numeric value beside it. Include clear column headings, because Excel can use them to identify the chart’s series and legend. A simple worksheet might look like this:
- Cell A1: Category; cell B1: Requests
- Cells A2:A5: Billing, Delivery, Returns, and Account Access
- Cells B2:B5: 42, 28, 18, and 12
Select the headings and all four data rows so Excel receives both the category labels and the values. Avoid including a grand-total row as another category: doing so makes the total itself a slice, which distorts the visual message. If you want to show the total, put it in a separate cell or use a text box rather than adding it to the chart’s source values.
Use nonnegative numbers that represent comparable parts of the same whole. A doughnut chart does not communicate negative values in a meaningful way, and zero values have no visible segment. If all values are zero or blank, there is no meaningful ring to draw. Check that values stored as text are converted to numbers, and remove accidental blank rows or unrelated notes from the selected range.
Insert a doughnut chart in Excel
- Click and drag to select the category names, numeric values, and their headings.
- On the ribbon, select Insert.
- In the Charts area, open Insert Pie or Doughnut Chart, then choose Doughnut. Depending on the window width, the chart options may appear as an icon rather than a full text label.
- Excel inserts the chart on the worksheet. Click its title to replace the placeholder with a specific description, such as Requests by Category.
- Click outside the chart when you have finished editing it. To move the chart, drag its border; use the sizing handles to change its dimensions.
If Excel assigns the categories or series incorrectly, select the chart and choose Chart Design > Switch Row/Column. This changes how Excel interprets the selected data; it does not rearrange the cells on the worksheet. For a basic two-column layout with categories down the rows, the usual result is one ring divided into category segments.
In Excel for Mac, select the data and use the Insert tab’s pie or doughnut chart menu to choose Doughnut. The ribbon layout and wording can vary slightly by Excel build, but the chart type is in the same general Insert-chart area. Excel for the web also offers doughnut charts from its Insert chart options, though some detailed formatting controls may differ from the Windows desktop app.
Add labels that explain the segments
A ring of colors without labels may be hard to interpret, especially if the legend is far from the chart. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a placement such as Center or Best Fit. You can also use the chart’s plus button in Windows, when it appears, to turn on Data Labels.
To choose what a label displays, right-click a data label and select Format Data Labels. In the formatting pane, select options such as Category Name, Value, or Percentage. For a compact chart, category name and percentage are often more useful than raw values alone. If the segments are small, labels may overlap; move the legend beside the chart, use outside-end labels where available, or show fewer labels and explain the figures in a nearby table.
Excel calculates the percentage from each value divided by the total of the plotted series. Thus, if the four example values are 42, 28, 18, and 12, the displayed shares are 42%, 28%, 18%, and 12%. If the values are 42, 28, 18, and 10 instead, the total is 98, and the percentages are approximately 42.9%, 28.6%, 18.4%, and 10.2%. Small rounding differences can make displayed percentages add to 99% or 101%; that does not necessarily mean the underlying data is wrong.
Format the hole, colors, and overall appearance
To change the size of the opening, right-click a segment and select Format Data Series. In the pane, open Series Options and adjust Doughnut Hole Size. A larger hole makes the ring thinner; a smaller hole makes it thicker. Choose a size that keeps the segments visible and leaves enough room for any label placed in the center. Excel’s available range is controlled in the formatting pane, and you can type a value or use its slider.
To apply a coordinated palette, select the chart and use Chart Design > Change Colors. For more control over one segment, click a segment once to select the series and click it again to select that individual data point; then use the formatting options to change its fill. Keep category colors consistent if the same categories appear in other charts. Avoid relying on color alone: direct labels, a legend, or both help readers who have difficulty distinguishing colors.
Use Chart Design > Add Chart Element to add a legend, chart title, or other available chart elements. A useful title states what the whole represents and, where relevant, the reporting period. Remove decorative effects that do not add information, and make sure the chart is large enough for labels to remain legible. If you place text in the hole, keep it brief, such as Total: 100, and ensure it does not compete with the chart title or labels.
Use multiple rings carefully
Excel can plot more than one data series in a doughnut chart. Each series appears as a separate concentric ring. For example, categories could be listed down the first column, with one column of values for this year and another for last year. Selecting all three columns before inserting the chart creates two rings, one for each year.
Multiple rings can suggest how category shares differ between groups, but they are not always easy to compare. Each ring is scaled to its own series total, so the same-sized segment in two rings can represent different absolute amounts. Label the rings clearly, keep categories in the same order, and avoid adding many series: too many rings and slices make the chart difficult to read. If absolute values or small changes are the main point, a clustered bar chart is often clearer.
Keep the chart current and fix common problems
A chart based on a fixed cell range may not include new rows added outside that range. One way to make a source range easier to extend is to convert it to an Excel table: select the data and choose Insert > Table, confirm that the table has headers, and build the chart from the table. When rows are added directly to the table, Excel can extend the chart’s source data with them. Review the chart after changing the table, especially if you add a new category or series.
- The chart is blank: Check that the selected cells contain numeric values, not numbers stored as text, and that the values are not all zero or blank.
- The labels show the wrong categories: Check the selected range and use Chart Design > Select Data to inspect the chart’s data range and category labels.
- The slices look unexpectedly small: Look for an accidental total row, a stray value, or categories that should not be part of the same whole.
- The labels overlap: Enlarge the chart, reduce the number of labels, reposition them, or use a legend and a separate data table.
- The colors are hard to distinguish: Choose a more contrasting palette and retain text labels so the meaning is not carried by color alone.
When the chart is selected, Chart Design > Select Data is also useful for changing the source range without rebuilding the chart. If your chart is meant to show the distribution of a whole, confirm that the source includes every relevant category. Omitting a category changes the denominator and therefore changes every displayed percentage.
When to choose another chart type
Choose a doughnut chart when the main message is the composition of one total and the number of categories is manageable. A pie chart is a close alternative and may suit a simple set of categories, though it has no central opening. A bar or column chart is usually better for comparing values precisely, ordering categories, or showing negative values. A line chart is better suited to trends across time or another continuous sequence.
A common misconception is that the hole in a doughnut chart automatically displays a total. It does not: the center is simply blank unless you add text or another element. You can type a total in a worksheet cell and place a text box over the hole, but check the result after resizing or moving the chart because the text box may not stay centered. For a report that needs exact figures, a nearby table can be more dependable than squeezing details into the chart.
Frequently Asked Questions
How do I show percentages on a doughnut chart?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels. Right-click a label, choose Format Data Labels, and select Percentage. You can also select Category Name so readers can match each percentage to a segment.
Can I make a doughnut chart with multiple rings?
Yes. Include multiple value columns, with one series per column and the category names in the first column, then insert a doughnut chart. Excel generally draws one ring per series. Keep the number of rings modest and label them clearly.
How do I put a total in the center?
The center is not automatically populated with a total. Add a text box over the hole and type the total, or use a linked text box if you want it to reflect a worksheet cell. Recheck its position after resizing the chart.
Why does my doughnut chart show the wrong percentages?
Excel calculates each percentage from the values included in the chart’s source range. Check for an omitted category, an unwanted total row, or a stray value. Also confirm that the source range includes all categories that belong to the whole.
Can a doughnut chart show negative numbers?
It is not an appropriate chart for negative values because its segments represent shares of a whole. Use a bar or column chart when positive and negative amounts, or comparisons around zero, need to be shown.
Related
- Excel Conditional Formatting Based on Color: How It Works
- Conditional Formatting in Excel: Compare Dates
- Comparison Spreadsheet Template Excel: Setup and Examples
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Add Data Labels to a Bubble Chart in Excel with StepsTo add data labels to a bubble chart in Excel for Microsoft 365 on Windows, select the chart,…
- How to Insert a Gantt Chart in Google Sheets Step by StepYou can make a Gantt chart in Google Sheets, but Sheets does not provide a dedicated Gantt chart…
- BI with Excel Power Pivot: Models, Reports, and LimitsYes—Excel Power Pivot can support business intelligence (BI) by combining data from multiple sources into a relational data…
- Excel Waterfall Charts with Multiple Series ExplainedNo—not as separate, independent series in Excel’s built-in Waterfall chart. In Microsoft 365 for Windows, a native waterfall…
- Excel Pie Chart Not Showing? Fix the Data and DisplayIf an Excel pie chart is not showing, first check that its source range contains one series of…
- Excel Chart Fill Between Lines: The Stacked Area MethodTo fill the space between two lines in an Excel chart, add a stacked-area band made from a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.