An Excel donut chart template is a reusable chart design for showing how categories make up a whole. In Microsoft Excel for Microsoft 365 on Windows, enter category names and values, choose Insert > Insert Pie or Doughnut Chart > Doughnut, then format the chart; to reuse its styling, right-click the finished chart and choose Save as Template.
What an Excel donut chart template contains
People use the phrase “donut chart template” in two ways: they may mean a starter worksheet with example data and a doughnut chart, or a saved Excel chart template that can be applied to other data. Excel’s chart template is a formatting and chart-type file, typically saved with the .crtx extension. It does not act as a live connection to the original workbook or automatically bring the original data along when applied elsewhere.
A doughnut chart displays values as slices around a central hole. Each slice represents its proportion of the total values included in the chart. This makes the chart useful for a small number of categories that together form one meaningful whole, such as a budget, survey responses, or sales by product line. The empty centre can hold a short label or simply give the graphic a lighter appearance.
It is not a good choice for every dataset. A chart of unrelated measures, values that do not add up to a useful whole, or many tiny categories can be difficult to interpret. A bar chart often communicates comparisons more clearly when readers need to compare similar-sized values.
Starter data for a simple template
Start with one column of category names and one column of positive values. For example, a household spending summary could use the following sample figures, which total 1,000:
| Category | Amount | Share of total |
|---|---|---|
| Housing | 430 | 43% |
| Food | 220 | 22% |
| Transport | 140 | 14% |
| Utilities | 110 | 11% |
| Other | 100 | 10% |
Put the category names in A1:A6 and the amounts in B1:B6, with the headings in row 1. Select A1:B6 when inserting the chart. The chart should include the five category rows, not a separate grand-total row: adding the total as another slice would make it part of the chart’s denominator and distort every share. The figures are illustrative, not a recommended budget.
Keep labels short enough to fit in a legend or beside the slices. If the source data changes regularly, use a clearly organized Excel Table (select the data and choose Insert > Table) so the data range can expand when new category rows are added. Check the chart after adding rows to confirm the new categories are included.
Create the doughnut chart in Excel
- Arrange the category names and values in adjacent columns, with one heading per column and no blank rows within the data.
- Select the complete range, including its headings. In Excel for Microsoft 365 on Windows, open Insert > Insert Pie or Doughnut Chart and select Doughnut.
- With the chart selected, use the Chart Design tab to add a title, legend, and data labels. For example, choose Chart Design > Add Chart Element > Chart Title to add a title.
- Review the plotted categories and values. If Excel chose the wrong orientation, use Chart Design > Switch Row/Column or adjust the selected data range.
The exact chart tools appear contextually when the chart is selected. On Mac, select the chart to show the Chart Design tab; the available commands are broadly similar, though ribbon layout and context-menu wording can differ by Excel version. Excel for the web can create and edit charts, but saving and applying desktop .crtx chart templates is a desktop Excel workflow.
Format labels, colours, and the centre hole
Formatting should make the proportions easier to read, not decorate the chart at the expense of clarity. Give the chart a descriptive title such as “Spending by Category.” A title like “Summary” does not tell readers what the slices represent. If the units matter, show them in a subtitle, nearby text, or appropriately formatted labels.
To add labels, select the chart and choose Chart Design > Add Chart Element > Data Labels. Choose a position, then select More Data Label Options if you want to control which details appear. Depending on the selected options, labels can show the category name, value, percentage, or a combination. For the sample data, the housing slice should represent 43% of the total. Avoid displaying so many details that labels overlap; a legend plus percentage labels can be clearer than putting every name and amount around the ring.
To change the hole size, right-click a slice and choose Format Data Series. In the Format Data Series pane, open Series Options and adjust Doughnut Hole Size. A larger hole creates a thinner ring; a smaller hole creates a thicker ring. Choose a size that keeps the slices visible and labels readable. The hole is a design feature, not an additional data field, so text placed there should not imply a separate value unless you have a clear way to explain it.
For colour, use distinguishable shades and keep category colours consistent across related charts. Do not rely on colour alone: category names or a readable legend help people who have difficulty distinguishing colours and readers viewing a printout in grayscale. In the Format Data Series or Format Data Point controls, individual slices can be formatted separately. Keep visual emphasis for the category that matters rather than making every slice equally vivid.
Save and reuse a chart template
Once the chart has the appearance you want, save it as a reusable chart template in desktop Excel for Windows:
- Right-click the chart area and choose Save as Template.
- In the save dialog, give the template a descriptive name and save the .crtx file.
- To use it later, select a new data range, insert a chart, and open Chart Design > Change Chart Type. In the dialog, select Templates and choose the saved design.
A template is useful when several reports should share the same chart type, colours, labels, and other formatting. It is not a substitute for checking the new chart: category names, number formats, label positions, and the number of slices may differ from the original. If the new data has many more categories, for example, the saved label layout may become crowded and need adjustment.
Keep the .crtx file somewhere colleagues can access if they need the same design. The chart in a workbook and the template file are separate: saving the workbook does not by itself make the template available to other workbooks or users. On Mac, the ribbon and context menus can vary by build; check whether Save as Template is offered in your desktop version rather than assuming that every version exposes the command in the same place.
Choose the right data and chart design
A doughnut chart works best when the data describes one whole divided into a handful of categories. There is no universal ideal category count, but a chart becomes harder to scan as the number of slices grows, especially when many values are small. Combine minor categories only when doing so is meaningful and transparent; do not hide important differences inside an unexplained “Other” category.
- Use consistent units: do not mix dollars, percentages, and counts in the same series.
- Check the denominator: the displayed proportions are relative to the values included in the chart. Excluding a category changes the shares.
- Order slices deliberately: a consistent order, such as descending value, can help readers see the largest categories quickly.
- Use labels with care: labels are useful for a small chart, while a legend can be easier to maintain when category names are long.
- Provide context: identify the period, population, or scope when those details affect what the total means.
For a percentage-based dataset, check that the values represent the intended parts of a whole. They need not add to exactly 100 if they are rounded, but the underlying categories should have a coherent relationship. For example, a chart of survey answers can be misleading if respondents could select multiple answers: those response counts do not necessarily represent mutually exclusive parts of one whole.
Common problems and how to fix them
- The chart shows the wrong labels or values: select the chart and use Chart Design > Select Data to review the chart data range and category labels. Confirm that the heading row was interpreted correctly.
- A category is missing: check that its row is inside the selected range. If the source list has grown, edit the range or use an Excel Table as the source.
- Labels overlap: show fewer label fields, move labels to a legend, enlarge the chart, or remove categories that are not useful to the message. Shrinking the font until it is difficult to read is not a good fix.
- The chart looks almost like a solid ring: one category may dominate the total, or the smaller slices may be too similar to distinguish. Consider a bar chart if comparing the smaller values is important.
- The shares look unexpected: verify that the chart excludes the total row and includes every intended category. Remember that percentage labels are calculated from the values plotted, not necessarily from a separate total elsewhere in the worksheet.
- A saved template does not look right with new data: inspect the new chart’s labels, colours, and series options. A template carries styling, but different data can require different formatting.
Donut chart versus pie chart and other alternatives
A pie chart and a doughnut chart both show parts of a whole. The doughnut’s open centre can make it feel less visually dense and provides space for a short central annotation, while a pie chart uses the entire circle. Neither format makes precise comparisons easy when slices are similar in size; readers must judge angles or arc lengths.
Use a bar chart when the main task is ranking categories or comparing close values. Use a 100% stacked bar when comparing the composition of several groups, such as the share of spending categories across multiple months. A single doughnut chart is generally better for one composition at one point in time than for showing a trend across many periods. Adding concentric rings for multiple series is possible, but it can be difficult to compare rings accurately, so consider whether separate charts or a different chart type would communicate the information better.
Frequently Asked Questions
Does Excel have a built-in donut chart template?
Excel includes the Doughnut chart type, which you can insert from the Insert tab. You can also save a formatted chart as a .crtx template in desktop Excel and reuse its design. A ready-made sample workbook and a saved chart template are different things.
How do I show percentages on an Excel doughnut chart?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels. Open More Data Label Options and select Percentage. Check the labels against the intended categories, because Excel calculates percentages from the values plotted in that chart.
Can I put a total in the centre of the doughnut?
Yes. You can add a text box to the chart and position it over the hole, or add a brief annotation in the worksheet. If the total changes, update the text as well; a manually entered annotation does not automatically stay synchronized with worksheet values.
How many categories should a doughnut chart have?
There is no fixed limit that guarantees readability. A few clearly named categories are usually easier to understand than many thin slices. If the chart needs a long legend or readers must compare small differences, a bar chart may be a better choice.
Can I use a doughnut chart template in Excel for the web?
You can create and work with charts in Excel for the web, but saving and applying desktop .crtx chart templates is a desktop Excel task. For a consistent design in a browser-based workflow, keep a formatted example chart in a workbook and check the available chart options in your version.
Related
- Change Text to Numbers in Excel: Easy, Reliable Methods
- Center Across Selection in Excel: Add It to Quick Access
- Change Block Capitals to Lowercase in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: Hide Filter Buttons, Keep FiltersTo hide the filter buttons in an Excel PivotTable without clearing its current filter selections, click anywhere in…
- How to Change a Column Name in an Excel ChartTo change a column name shown in an Excel chart, rename the chart’s data series: select the chart,…
- Excel Waterfall Chart Help: Build, Format, and Fix OneTo create a waterfall chart in Excel for Microsoft 365 on Windows, place each step of your change…
- Excel Histogram Bin Range: Meaning and How to Set ItIn Excel’s Data Analysis Histogram tool, the bin range is a worksheet range containing the upper limits of…
- Excel Chart Color Based on Value: How to Set It UpYes. In Excel for Microsoft 365 on Windows, the most reliable way to color chart points according to…
- Half-Circle Charts in Excel: Create a Semi-DoughnutExcel does not have a dedicated half-circle chart button, but you can make one with a doughnut chart:…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.