Excel Donut Chart Total in the Middle?

Charts & pivot tables · Updated November 19, 2026

To put a total in the middle of an Excel doughnut chart, calculate the total in a worksheet cell, insert a text box over the chart’s hole, and link the text box to that cell. The text then updates when the source values change; Excel does not add a live grand total to the center automatically.

How the Center Total Works

A doughnut chart shows how categories contribute to a whole, with each slice representing a share of the total. The empty center is part of the chart design, not a special total field. Excel can label slices with category names, values, or percentages, but those options do not create a built-in center-total label.

The usual solution combines three separate pieces: the chart, a formula that calculates the figure to display, and a text box placed over the chart’s hole. Linking the box to a cell keeps the number current without requiring you to edit the chart label every time the data changes. You can show just a number, or put a short label such as “Total” above it.

This is useful for a compact dashboard—for example, a chart of sales by product with the overall sales amount in the middle. It can also prevent a common misunderstanding: the center number should describe the same categories and time period as the slices around it.

Create the Doughnut Chart

Start with a simple two-column table, with category names in one column and the values to chart in the next. For example, list four product categories in A2:A5 and their sales in B2:B5. Select the category and value cells, then choose Insert > Insert Pie or Doughnut Chart > Doughnut on the Excel for Microsoft 365 ribbon in Windows.

Excel creates a doughnut chart from the selected data. If the chart includes an unwanted header or misses a category, check that you selected the intended range and that each category has a corresponding numeric value. You can change the source later by selecting the chart and using Chart Design > Select Data.

Before adding a center total, decide what the chart is meant to show. A doughnut chart is easiest to read when it has a small number of distinct categories that add up to a meaningful whole. If the values represent unrelated measures, a center sum may be mathematically possible but not informative.

Calculate the Total in a Cell

Use a worksheet formula for the number that belongs in the center. With product names in A2:A5 and sales values in B2:B5, enter this formula in D2:

=SUM(B2:B5)

The example assumes the four sales values are 120, 80, 60, and 40; the formula returns 300. If those values are dollars, format D2 as currency so the displayed result is $300. Using a separate total cell makes the calculation easy to inspect and reuse, and lets the chart’s center label follow the data.

Make sure the formula covers the same values represented by the chart. If the chart shows only some categories but the formula sums every row, the center figure will not equal the sum of the visible slices. This can happen when you filter a table or hide rows. Review the chart’s selected data and the total formula together whenever the included categories change.

If the source is an Excel Table and new rows will be added, consider using a structured reference so the total can include the expanding column. For example, with a table named SalesData and a column named Amount, the formula is =SUM(SalesData[Amount]). This assumes those exact table and column names. The result is the sum of all numeric entries in that table column; Excel adjusts the reference when table rows are added.

Add and Link the Center Text Box

  1. Select the chart so the text box will be placed within the chart area.
  2. Choose Insert > Text Box, then drag a box into the doughnut hole.
  3. Click the text box’s border to select the object, rather than placing the cursor inside its text.
  4. Click the formula bar, type =D2 to link the box to the total cell, and press Enter. This assumes the total is in D2.
  5. Drag the box into the center and resize it so the text fits inside the hole.

After it is linked, the text box displays the value from D2. Change a source value and the formula result—and therefore the linked label—updates. If typing in the formula bar changes the text inside the box instead of linking it, select the box by its outer border and try again. The distinction between selecting the object and editing its text is important.

In Excel for Mac, the same general approach applies: insert a text box while working with the chart, select its border, and enter the cell reference in the formula bar. Ribbon labels or placement can vary by release. The instructions here are for Excel for Microsoft 365 on Windows; if a command is not visible in your Mac layout, look on the Insert tab and verify that the text-box object, not its text cursor, is selected.

Format the Number and the Hole

Keep the center label visually distinct from the slice labels. Select the text in the box and use the Home tab to adjust its font, size, bolding, and color. Center-align the text, and, if you use a separate word and number, put them on separate lines. Leave enough whitespace around the label so it does not touch the ring.

To make more room, right-click a doughnut slice and choose Format Data Series. Under Series Options, adjust Doughnut Hole Size. A larger hole gives the center label more space but makes the colored ring narrower; a smaller hole makes the ring wider but may crowd the number. The best setting depends on the chart’s size and the length of the label.

Consider the number format as part of the message. A sales chart may call for currency with no decimal places, while a share-of-budget chart may need a percentage or a currency amount. Avoid displaying more precision than the source supports. For example, $300.00 is not necessarily more useful than $300 when all the categories are whole-dollar amounts.

You can make a combined label in a worksheet cell as well. With values in B2:B5 and the label formula entered in D2, this formula returns “Total” and the summed amount on separate lines:

="Total"&CHAR(10)&TEXT(SUM(B2:B5),"$#,##0")

For the example values 120, 80, 60, and 40, the displayed text is “Total” followed by “$300” on the next line. Link the text box to D2 as described above. This formula assumes a dollar-style display; change the format string if another currency or number style is appropriate. The line break may require a taller text box to display cleanly.

Choose What the Total Should Mean

A center figure is useful only when its definition is clear. Decide whether it represents all values in the chart, the selected period, or a particular subset. If a report includes monthly figures, for example, a total for the current month should not be calculated from an entire year unless that is what the chart shows.

Also consider whether the chart is meant to show proportions or a changing total. The slices communicate relative shares; the center can communicate the absolute sum. If both the total and the proportions matter, label them distinctly rather than presenting an unexplained number. A small caption such as “Q2 sales” can clarify the period, though long wording may be hard to fit in the hole.

For data that changes when a filter is applied, check whether the chart and total respond in the same way. A normal SUM includes values in hidden rows. If the chart omits filtered or hidden rows, that can make the center number larger than the visible slices’ sum. One option for a filtered list is SUBTOTAL. With values in B2:B5, =SUBTOTAL(109,B2:B5) returns the sum of visible values, excluding rows hidden by a filter or manually hidden. Confirm that this matches the chart’s behavior and the intended definition of the total.

Common Problems and Fixes

  • The center number does not update: Confirm that the text box is linked to the formula cell, not just filled with typed text. Select its border and inspect the formula bar for a cell reference such as =D2. Also check that calculation is not set to manual if worksheet formulas appear stale.
  • The total is larger than the slices: Check for hidden or filtered rows, extra categories in the SUM range, or chart data that does not match the formula range. If appropriate, use a visible-row calculation such as SUBTOTAL and verify the chart’s hidden-data settings.
  • The text box moves independently: Make sure it is positioned inside the chart area. If it was created on the worksheet rather than as part of the chart, it may remain in place when the chart moves. Delete it and add a new text box with the chart selected.
  • The label looks cramped: Increase the doughnut hole size, reduce the font size, shorten the wording, or enlarge the chart. A long number with many digits may need a different number format.
  • The label is difficult to select: Click the text box’s edge, not the text itself. If the chart makes selection awkward, use the Selection Pane from the Home tab’s Find & Select menu to locate drawing objects.

One related misconception is that the chart’s data labels can simply be switched to “total.” Standard doughnut data labels identify information about individual slices, such as a category, value, or percentage. A total is an overall figure, so a linked text box is the straightforward way to place it in the center.

Alternatives and Readability

A center total is not always the best design. For many slices, similar colors, or a narrow chart, the number can compete with the data. You could put the total in a chart title, a nearby cell, or a separate card above the chart instead. Those options are often easier to read in a small dashboard or when the chart must be printed.

Remember that a text box may not communicate the chart’s meaning to every reader or assistive technology in the same way as a worksheet cell. Keep the total in a labeled worksheet cell too, and provide clear chart text or alt text describing what the chart shows. Use adequate contrast and do not rely on slice color alone to distinguish categories.

For comparison, a pie chart has no central hole, so a label placed over its middle would obscure the slices. A doughnut chart is better suited to a center figure, though a bar chart may make category comparisons easier when values are close together. Choose the chart type for the comparison you want readers to make, not merely for the space available for a total.

Frequently Asked Questions

Can Excel show a total in the middle of a doughnut chart automatically?
No. Excel does not provide a built-in doughnut-center total label. Calculate the figure in a worksheet cell and link a text box over the chart’s hole to that cell.

How do I make the center total update when values change?
Calculate the total with a formula such as SUM, then link the text box to the cell containing that formula. When the source values change, the formula recalculates and the linked text updates.

Can I show the word “Total” above the number?
Yes. Use a formula that combines text, a line break, and the calculated value in a worksheet cell, then link the center text box to that cell. Alternatively, use a short label in a separate text box.

Why does the center total not match the visible slices?
The formula may include categories that the chart omits, or hidden and filtered rows may be treated differently by the chart and formula. Compare their source ranges and, for filtered data, consider whether SUBTOTAL is appropriate.

Can I put a percentage in the center instead of a total?
Yes, but define what the percentage means. It could be one category’s share, a subset’s share, or another measure. Calculate that value in a cell, format it as a percentage, and link a text box to it.

Can I add the center label in Excel for the web?
Capabilities and editing controls can differ between Excel for the web and desktop Excel. These steps target Microsoft 365 on Windows; if the web interface does not let you create or link the chart text box as needed, open the workbook in the desktop app.

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.