Stylish Doughnut Chart in Excel: Design Tips & Steps

Charts & pivot tables · Updated November 20, 2026

To make a stylish doughnut chart in Excel for Microsoft 365 on Windows, select a clean category-and-value table, choose Insert > Insert Pie or Doughnut Chart > Doughnut, then refine its colors, labels, and hole size on the Chart Design and Format tabs. A restrained palette, readable labels, and a clear explanation of the total usually matter more than decorative effects.

What a doughnut chart shows well

A doughnut chart divides a circle into slices, with each slice representing a category’s share of the whole. It is useful when you want to show a small set of parts that add up to a meaningful total: for example, how a team’s monthly support requests are distributed across five topics, or how a project budget is split among departments.

The open center gives the chart a distinctive look and can make room for a short total or key figure. But the hole does not change the underlying data or make the chart more precise. Readers still compare slices mainly by their angles and areas, which is harder than comparing aligned bars. Use a doughnut chart when the part-to-whole message is the point, not when exact comparisons between many similar values are essential.

Prepare the data before charting

Arrange the source data in two adjacent columns: one for category names and one for numeric values. For instance, a table might list “Email,” “Phone,” “Billing,” and “Other” in the first column, with the corresponding request counts in the second. Include one header row, keep each category on its own row, and avoid blank rows inside the range. Select the headers and data together so Excel can identify both the labels and values.

Check that the numbers are the values you intend to compare. A doughnut chart shows each number as a share of the sum of the plotted values; it does not automatically know whether a value is a percentage, a count, or a currency amount. If the rows do not represent parts of one sensible whole, the chart can suggest a relationship that is not really there.

  • Use a short, descriptive label for every slice.
  • Combine tiny categories into “Other” only when that grouping is meaningful and you can explain it.
  • Decide whether the chart should show all categories or only a selected subset; excluded rows change the denominator and therefore every displayed share.

Create the doughnut chart in Excel

  1. Select the category and value cells, including their headers.
  2. On the ribbon, choose Insert > Insert Pie or Doughnut Chart, then select Doughnut. Excel inserts the chart on the worksheet.
  3. Click the chart to show the Chart Design and Format tabs. Use the chart title area to enter a specific title, such as “Support requests by topic — October,” rather than leaving a generic label.
  4. On Chart Design, use Add Chart Element to add data labels or a legend, and use Change Colors or the Chart Styles gallery as a starting point for visual formatting.
  5. Right-click a slice and choose Format Data Series to adjust the Doughnut Hole Size. Try a moderate opening first, then check whether the slices remain substantial and easy to see.

These commands apply to desktop Excel for Microsoft 365 on Windows. In Excel for Mac, the chart is also inserted from the Insert tab and its design and formatting controls appear when the chart is selected; the ribbon layout and pane placement can differ. Excel for the web has chart tools too, though some detailed formatting controls may be less convenient or unavailable compared with desktop Excel.

Choose colors, spacing, and chart style

For a professional result, start with a small palette. Use related shades when categories have equal status, and reserve one contrasting accent for the slice that deserves attention. Excel’s Change Colors choices can quickly apply coordinated palettes, but check the result against the worksheet background and your organization’s color conventions. A rainbow of unrelated colors can make a simple chart feel busy.

To emphasize one slice, click the doughnut once to select the series, then click the slice again to select that individual data point. Use the Format tab or the formatting pane to change its fill. Keep the emphasis purposeful: highlighting one category should direct attention, not imply a different value. Avoid relying on color alone to communicate meaning, since readers may have color-vision deficiencies or print the chart in grayscale.

The hole size is a design choice, not a data setting. A larger hole creates room for a center label but leaves thinner slices; a smaller hole gives the ring more visual weight. You can also adjust the first-slice angle in Format Data Series to arrange a key slice more neatly, but do not rotate the chart in a way that makes comparisons or category order confusing. Remove unnecessary borders, shadows, and 3-D effects; flat fills and clear spacing are generally easier to read.

Add a useful number in the center

A center label can summarize what the chart represents, such as “240 requests” or “72% resolved.” It should clarify the graphic rather than compete with the slices. If you add a total, make sure it really is the sum represented by the displayed categories. If the chart shows selected categories rather than the complete dataset, a grand total from the full dataset could mislead readers.

To add fixed text, choose Insert > Text Box, draw the box over the chart’s open center, and type a short label. To keep the center value connected to a worksheet cell, select the text box’s border, click the formula bar, type a cell reference, and press Enter. For example, assuming the Summary worksheet’s B2 cell contains the text “72% resolved,” enter =Summary!$B$2 while the text box is selected; the linked box displays that cell’s contents and updates when the cell changes. Format the text box with no fill and no outline if those settings suit the chart, and ensure it stays centered when the chart is resized.

Labels and legends: make the slices understandable

Data labels are often more useful than a legend when a chart has only a few categories. Select the chart, choose Chart Design > Add Chart Element > Data Labels, and select a position. For more control, choose More Data Label Options to open the formatting pane. There you can choose which elements to show, such as category name, value, or percentage, and adjust label placement where the chart type and Excel version permit it.

Use percentages when the reader’s main question is “What share does each category represent?” Use raw values when the number of items matters, and show both only if the labels remain uncluttered. Percentages are calculated from the values in the chart, so verify the selected source range. Rounded labels may add up to 99% or 101% even when the underlying shares total 100%; this is a rounding effect, not necessarily a data error.

A legend can work well if slice labels overlap or the category names are long. If you use one, put it close to the chart and make its text large enough to read. Avoid forcing labels into tiny slices. Instead, group categories sensibly, use a legend, or choose another chart type.

When to choose another chart

A doughnut chart is most effective with a few categories and one clear total. As the number of slices increases, labels crowd and readers struggle to compare similarly sized segments. There is no universal category limit, but if viewers need a legend to decode many thin slices, a sorted horizontal bar chart is often clearer. Bars make it easier to compare values because their lengths share a common baseline.

Excel can plot multiple data series as concentric rings in a doughnut chart. That option may look appealing for comparing groups, but each ring uses its own series and can be difficult to compare accurately across rings. If the main task is comparing values across groups or time periods, clustered bars, a line chart for a time trend, or a table may communicate the result better. Choose the chart for the question, not just for its appearance.

Common problems and practical fixes

  • The chart uses the wrong labels or values: Select the chart and use Chart Design > Select Data to check the chart data range and series. Confirm that category names and numeric values are assigned as intended.
  • A slice is missing: Check for a zero, blank, or text value in the source. Zero has no visible slice, and text is not a numeric chart value. Also check whether the row falls outside the selected range.
  • The percentages seem unexpected: Excel calculates shares from the plotted values. Review whether all intended categories are included and whether the values are parts of the same whole.
  • Labels overlap: Reduce the number of displayed label elements, enlarge the chart, use a legend, or group minor categories. Shrinking the font until it is hard to read is rarely a good fix.
  • The chart looks crowded or misleading: Remove decorative effects, use fewer colors, and reconsider whether a doughnut is the right comparison. Negative values are not meaningful slices in a standard doughnut chart; use a chart designed for values that can fall below zero.

Frequently Asked Questions

How do I change the size of the hole in an Excel doughnut chart?
Select or right-click a slice, choose Format Data Series, and adjust Doughnut Hole Size in the pane. A larger hole leaves a narrower ring, so check that small slices remain visible.

Can I put a total in the middle of a doughnut chart?
Yes. Insert a text box and position it over the center, or link the text box to a worksheet cell through the formula bar. Keep the number tied to the categories actually shown.

How do I show percentages instead of values?
Select the chart, add data labels, and open More Data Label Options. In the label options, select Percentage and clear Value if you do not want both. Check the plotted range because the percentages use its total.

Can an Excel doughnut chart have more than one ring?
Yes. Excel can display multiple data series as concentric rings. However, readers may find it hard to compare the same category across rings, so use this only when the additional series genuinely help tell the story.

Why do the percentages not add up to exactly 100%?
Excel’s underlying shares can total 100%, while the displayed labels may not because each value is rounded. Showing fewer decimal places makes labels cleaner but can increase the visible rounding difference.

Related

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.