Yes. In Excel for Microsoft 365 on Windows, create a doughnut chart, calculate the total in a worksheet cell, then place a text box over the hole and link it to that cell. The label will update when the source values change, making the center a useful place to show a sum, count, or other summary.
What a doughnut chart shows
A doughnut chart displays categories as slices of a ring. Each slice represents a share of the whole, so the chart works best when the values are non-negative and have a meaningful total. For example, a department might use a chart to show how 125 requests were divided among four teams. The ring gives a quick sense of each team’s share; a total in the middle tells readers how many requests the shares represent.
Excel can show category names, values, or percentages as data labels, but it does not provide a dedicated built-in setting that automatically puts the sum of all slices in the hole. The usual solution is to add a text box to the chart and connect it to a cell. This is different from turning on data labels: the text box can display one overall figure instead of a separate figure for every slice.
A center value is most useful when its meaning is explicit. A number such as 125 could be a total, a count, or a target, so label it accordingly. If the slices already represent percentages that add to 100%, a center value of 100% may be redundant; a more informative figure might be the total underlying count.
Prepare the data and calculate the total
Put category names in one column and their values in the next. For a simple example, enter North, South, East, and West in A2:A5, and enter 40, 35, 30, and 20 in B2:B5. Keep the total outside the rows used for the chart, so Excel does not mistakenly treat it as another slice.
With category names in A2:A5 and the four values in B2:B5, enter this formula in B6:
=SUM(B2:B5)
The formula returns 125 because 40 + 35 + 30 + 20 = 125. If you change a regional value, the sum recalculates. For data that grows over time, you can use an Excel Table as the chart source and choose a suitable location or table formula for the total; the key is to avoid including the total itself among the plotted categories.
If you want the center to show words as well as a number, use a helper cell. With the total in B6, enter this formula in B7:
="Total: "&TEXT(B6,"#,##0")
That cell displays Total: 125. The number format in TEXT adds a thousands separator when needed. If your audience needs decimal precision, change the format string—for example, to include one decimal place. For a label that needs to remain numeric for further calculations, keep the numeric total in B6 and use B7 only for display.
Create the doughnut chart
- Select the category and value cells, A1:B5 in this example. Do not select the total in B6.
- Choose Insert > Insert Pie or Doughnut Chart > Doughnut.
- Check that each category is shown as one slice and that the legend or category labels make the slices identifiable.
- Move or resize the chart as needed, leaving enough space to work with the hole in its center.
Excel may choose colors and a hole size automatically. To change the hole, click a slice to select the data series, right-click it, choose Format Data Series, and adjust Doughnut Hole Size under Series Options. A larger hole leaves more room for a label but makes the ring thinner; a smaller hole gives the slices more visual weight. There is no single best setting, so choose a size that keeps both the center text and the slices legible.
Add a live total to the center
For the clearest label, use the helper cell B7 from above. Click the chart, then choose Insert > Text > Text Box. Draw the text box over the hole. If the box is created outside the chart, cut it, select the chart, and paste it so it becomes part of the chart object and moves with the chart.
Click the text box border—not inside the text—so the whole box is selected. Click the formula bar, type the cell reference below, and press Enter. This example assumes the worksheet is named Sheet1 and the display text is in B7:
=Sheet1!$B$7
The text box should show Total: 125. If your worksheet has a different name, use that name in the reference; for a sheet name containing spaces, enclose it in single quotation marks, as in ='Sales Data'!$B$7. The dollar signs keep the reference fixed if the linked shape is copied. When the source values change, B6 recalculates, B7 updates, and the linked label follows.
Format the label after linking it: select the text, choose a readable font size and weight, and set the text alignment and box fill or outline as appropriate. Remove the fill and outline if you want the slices visible around the text. Keep the box within the hole; text that extends over the ring can obscure slice boundaries or make small slices harder to compare.
Choose what the center should communicate
The center does not have to show a sum. Pick a measure that adds context rather than repeating what the chart already says. For instance, a budget chart might show the total budget, while a chart of issue categories might show the number of records represented.
- Total quantity: Show the sum of the values when the chart breaks a whole into parts.
- Record count: Show how many observations are represented if the slices are proportions or grouped counts.
- Period or scope: Add a short label such as a year or reporting period when readers might otherwise miss it.
- Key outcome: Use a carefully defined figure, such as completed items, only if it is clearly related to the slices.
Be cautious with averages, targets, or percentages that are not the sum of the slices. A doughnut chart visually implies parts of a whole, and the center number may be read as that whole’s total. If the displayed metric is a separate measure, label it precisely and consider whether another chart type would communicate the relationship more clearly.
Keep the chart readable and trustworthy
Use a small number of categories where possible. A ring split into many thin slices is difficult to compare, even if the total in the middle is prominent. Combine minor categories only when that grouping is meaningful, and identify the combined group honestly. A doughnut chart is generally better for showing composition at a glance than for comparing nearly equal values precisely.
Choose distinct slice colors and avoid relying on color alone to identify categories. A legend, direct labels, or both can help readers who cannot distinguish the colors easily. Check the chart at the size it will appear in a report or presentation: a label that fits on a large worksheet may become cramped when the chart is reduced.
Also distinguish a total from a percentage. In the example, the values sum to 125, but their shares sum to 100%. The center can show 125 requests, while percentage data labels around the ring show each team’s contribution. If the chart is filtered or its source changes, verify that the plotted rows and the total formula still refer to the same categories.
Common problems and fixes
- The label does not change: Confirm that the text box is linked to the intended cell, not merely typed with a fixed number. Select its border and inspect the formula bar.
- The label appears outside the chart: The text box may be a worksheet object rather than part of the chart. Cut it, select the chart, and paste it back before positioning it.
- The text box shows a formula or reference: Select the box border and enter the reference in the formula bar, then press Enter. Typing a reference while editing the text inside the box can insert characters instead of linking the shape.
- The total is counted as a slice: Edit the chart’s source data so it includes only category rows, not the total row. In this example, use A1:B5 rather than A1:B6.
- The center text is clipped: Enlarge the hole, reduce the font size, shorten the wording, or make the chart larger. Check that the text box itself is wide enough too.
- The chart and total disagree: Check for blank, hidden, filtered, or newly added data. Make sure the SUM range covers the same values that the chart plots.
Excel for Mac has similar chart and text-box tools, though ribbon grouping and labels can vary by release; create the doughnut from the Insert tab and add a text box from Insert. The linking method is to select the shape and enter a cell reference in the formula bar. Excel for the web may have fewer editing options for chart objects, so use the desktop app if you cannot link or position the text box as described.
When a different chart or label is better
A doughnut chart is a reasonable choice for a small set of categories whose values form a whole. A bar chart is often clearer when the main task is comparing category sizes, especially when there are many categories or values are close together. A stacked bar can show composition while retaining a common baseline for comparisons. For a single metric such as a current total against a target, a simple KPI card or a cell with large formatted text may be more direct than a ring.
If you need the total to be easy to update and reuse, keep it in a worksheet cell rather than typing the number into the chart. A linked text box combines the visual layout with a cell-based source of truth. It also lets you change number formatting, wording, or calculation separately from the chart design.
Frequently Asked Questions
Can Excel put a total in the middle of a doughnut chart automatically?
Not as a dedicated doughnut-chart total option. Calculate the total in a worksheet cell and add a text box linked to that cell over the chart hole.
How do I make the total update when the data changes?
Use a formula such as SUM for the source values, link the text box to the total or a display cell, and ensure the chart source covers the same categories. The linked label updates when its cell recalculates.
Can I show “Total: 125” instead of just 125?
Yes. Create a helper cell containing the wording and formatted number, then link the text box to that cell. This separates the display label from the numeric total used in calculations.
Why is my total showing as another doughnut slice?
The chart source likely includes the total row. Change the source range to include only the category names and their values, leaving the total outside the plotted range.
Can the center show a percentage rather than a count?
Yes, but make the meaning clear. A chart of shares normally totals 100%, so showing 100% in the center may add little; a count of the underlying records may be more informative.
Related
- Comparison Excel Sheet Template: Build a Clear Side-by-Side
- Comparison Plot in Excel With R²: Steps and Meaning
- Company Invoice Template in Excel: Setup and Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Donut Chart: Change Colors by Slice or ThemeTo change colors in an Excel donut chart, select the chart and choose Chart Design > Change Colors…
- Excel Pivot Table Dates Not Grouping? How to Fix ItIf dates in an Excel PivotTable will not group, first check that every cell in the source date…
- Can You Cluster a Stacked Bar Chart in Excel?Yes, but Excel does not offer a built-in chart type that both clusters and stacks bars. In Microsoft…
- Best Free Excel Gantt Chart Templates: 5 PicksFor most people, Vertex42’s Gantt Chart Template is the best free Excel Gantt chart template: it gives you…
- Excel Online Waterfall Chart: How to Set a Bar as TotalIn Excel for the web, select the individual waterfall column and check its right-click menu for Set as…
- Excel Histogram Is Blank? Fix the Chart and Data IssuesAn Excel histogram is usually blank because its source range contains no usable numeric values, the chart points…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.