To make an Excel donut chart show progress, give it two values: the amount complete and the amount remaining. Select those values and their labels, then choose Insert > Insert Pie or Doughnut Chart > Doughnut; format the completed slice with a strong color and the remainder with a pale one.
What a progress donut chart shows
Excel does not have a separate chart type named “progress donut.” The familiar progress ring is a regular doughnut chart used to compare a completed portion with what is left. Its total should represent the whole task, so a task that is 68% complete has a 68% completed slice and a 32% remaining slice.
This is useful for communicating one proportion at a glance: a project milestone, training completion, survey response rate, or share of a target reached. It is less suited to showing change over time or comparing many categories. A ring can look precise, but it is still a visual summary; include a clear label or the underlying value when readers need exact numbers.
Set up the source data
For a single progress ring, create one series with two categories. For example, put the labels “Complete” and “Remaining” in A2:A3. Enter 68% in B2. With the progress value in B2, enter =1-B2 in B3; if B2 is 68%, the result is 0.32, or 32% when B3 is formatted as a percentage. The arithmetic is 100% minus 68% equals 32%.
Use a simple table like this:
- A2: Complete; B2: 68%
- A3: Remaining; B3: formula for the uncompleted portion
Format B2 and B3 as Percentage if you want the worksheet values to be easy to read. The two values must add to 100% for a standard completion ring. If you enter whole numbers instead, such as 68 and 32, the chart has the same proportions, but percentage formatting makes the source easier to interpret.
Create the doughnut chart in Excel
- Select A1:B3 if the table includes headers, or select A2:B3 if it does not.
- On the Windows ribbon, choose Insert > Insert Pie or Doughnut Chart > Doughnut.
- Move or resize the chart so it does not cover the source data or other dashboard content.
- Check that the chart shows two slices, one for Complete and one for Remaining. If the labels or slices look wrong, use Chart Design > Switch Row/Column or reselect the data range.
Excel uses the category labels to identify the two slices. The chart may initially assign colors that do not distinguish progress clearly, so formatting is usually the next important step. In Excel for Mac, use the Insert tab and choose the doughnut chart from the chart gallery; chart formatting is available through the chart and Format pane, although the gallery and pane layout can differ. Excel for the web can create charts too, but some detailed formatting controls may be more limited or arranged differently than in the desktop app.
Format the ring for quick reading
Click the ring, then click the Complete slice again to select just that data point. Use Chart Design > Change Colors for a quick palette, or right-click the selected slice and choose Format Data Point to set its fill. Choose a color with enough contrast against the remaining slice. Format the Remaining slice separately in a neutral gray or light tint. Avoid two similarly saturated colors, which can make it difficult to tell which slice means progress.
To make the ring thicker or thinner, right-click a slice and select Format Data Series. In the pane, adjust Doughnut Hole Size. A larger hole leaves more space for a number in the middle but makes the colored band thinner; a smaller hole makes the ring heavier. The exact setting is a design choice, not a measure of completion.
The starting position of the ring can also affect how it reads. In Format Data Series, adjust Angle of first slice to rotate the chart. A starting point at the top often makes a small progress value easier to notice, but consistency matters most if the workbook contains several rings. Keep the same orientation across related charts.
Add a percentage or number in the center
A donut does not automatically put the completion percentage in its hole. One option is to add a data label: select the chart, choose Chart Design > Add Chart Element > Data Labels, and select a position. Then use Format Data Labels to choose Percentage or Value as appropriate. Since the two slices together represent 100%, the percentage for the Complete slice will match its share. If labels overlap or clutter the ring, remove them and use a single center value instead.
For a prominent center value, insert a text box over the hole and link it to the cell containing the progress amount. Select the text box, click the formula bar, type an equals sign, select the cell with the progress value, and press Enter. Format the linked source cell as a percentage and style the text box with no fill or outline. The value then updates when the cell changes. Keep the text box positioned within the hole, since it will not necessarily move with the chart if you resize or rearrange objects.
A percentage answers “how much is complete?” A count may be more useful for a concrete task: “17 of 25 items.” If both matter, place the count beside the ring and the percentage in the center rather than trying to fit several labels into the chart.
Keep the chart mathematically honest
The chart is only as meaningful as its denominator. If progress is 17 completed items out of 25 total items, the completed portion is 68% and the remainder is 32%. If the total changes to 30, the chart should reflect the new denominator; otherwise, it can imply a level of completion that is no longer accurate. State what “complete” means when the definition is not obvious.
Do not enter a completed value greater than the total and treat it as an ordinary two-slice ring. A doughnut chart normalizes its slices to their sum, so values such as 110 completed and 100 remaining do not mean “110% complete”; they simply appear as shares of 210. For a target exceeded, consider displaying the actual amount and target separately, or cap the ring at 100% and show the overage as text. Likewise, a negative remainder or a blank source value is a sign to check the calculation and input data before interpreting the chart.
A ring can also hide small differences. A visual gap between 68% and 70% may be hard to judge, especially in a small chart. If the decision depends on a precise comparison, show the number or use a bar chart with a clear scale. Donut charts are best treated as compact status indicators, not measurement instruments.
Show multiple progress measures
For a dashboard with several tasks, one option is to create a separate two-slice doughnut chart for each task. Each ring can have its own Complete and Remaining values, with a nearby title identifying the measure. Reusing the same colors, hole size, label position, and slice orientation helps readers compare them consistently. Make sure each chart has its own correctly calculated remainder; copying a chart does not guarantee that its source references are appropriate for the next task.
Excel doughnut charts can display multiple data series as concentric rings. That can be useful when several measures share the same categories, but it can become hard to interpret when each ring represents a different task with different labels or denominators. For a small number of independent progress measures, separate charts are often clearer. For many tasks, a table with progress bars or a sorted bar chart may use space more efficiently than a wall of rings.
Common problems and fixes
- The ring looks like one solid color: Check that the selected range includes both the completed and remaining values, and that the remainder is not zero.
- The chart shows the wrong labels: Confirm that the category names are beside the values and that the selected range includes both columns. Try Chart Design > Switch Row/Column if Excel interpreted the layout differently.
- Both slices have the same appearance: Select each data point separately and assign distinct fills. Changing the chart-wide color theme may not create the emphasis you want.
- The center number does not update: Check that the text box is linked to the intended worksheet cell and that the cell contains a numeric value. A typed number in a text box is static.
- The percentage label seems unexpected: Remember that chart percentages are calculated from the plotted values. Make sure Complete plus Remaining equals the intended total.
If you replace or extend the source data, verify the chart’s data range using Chart Design > Select Data. This is especially useful after inserting rows, copying a chart, or building the chart from a table that later grows. The worksheet values and the chart should tell the same story.
When another visual works better
Use a progress donut when the audience needs a compact view of one proportion and the completed-versus-remaining split is meaningful. Use a horizontal bar when exact comparisons among tasks matter; the shared baseline makes differences easier to compare. A cell-based data bar can be a better fit inside a detailed table because it keeps each progress indicator next to its task name and value. A line chart is more appropriate when the key question is how progress changes over time.
For accessibility and print readability, do not rely on color alone. Label the chart or its slices, include a nearby text value, and use sufficient contrast. A title such as “Onboarding tasks complete” gives the ring context that the word “Complete” by itself cannot provide. If the chart is part of a report, retain the source data in the workbook so the figure can be checked and updated.
Frequently Asked Questions
Does Excel have a built-in progress donut chart?
No. Create a regular doughnut chart with a completed value and a remaining value, then format the slices to make it read as a progress ring.
How do I show 68% complete in an Excel donut chart?
Use 68% for Complete and 32% for Remaining. Select the labels and values, insert a doughnut chart, and format the two slices with contrasting colors.
How do I put a percentage in the middle of the donut?
Insert a text box over the hole and link it to the cell containing the percentage, or add a data label to the completed slice. A linked text box updates with the cell.
Why does my progress chart show the wrong percentage?
Check that the chart includes only the intended completed and remaining values and that they add to the correct total. Excel calculates slice percentages from the values plotted in the chart.
Can one doughnut chart show several progress rings?
Excel can plot multiple data series as concentric rings, but separate charts are often clearer for independent tasks. Use a consistent style and label each measure so readers know what every ring represents.
Related
- Excel Conditional Formatting for Upcoming Dates
- Conditional Formatting Excel Dates Before a Date Rule
- Excel 3-Color Scale: How It Works and When to Use It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make a Percentage Chart in Excel (With Labels)To make a percentage chart in Excel, select your category labels and percentage values, then choose a chart…
- Excel Pivot Table Mode: Find the Most Common ValueTo find a mode with an Excel PivotTable, put the field you want to analyze in both Rows…
- Excel Line Chart Examples: How to Choose and FormatExcel line chart examples include monthly sales trends, several product lines compared over time, actual results against a…
- Excel Pivot Table: Clear Old Items and Cached ValuesTo clear old values from an Excel PivotTable, open PivotTable Options, choose the Data tab, set Number of…
- Excel Pie Chart With Breakdown of Slices: How to Make OneTo show the detail behind one slice in Excel, create a Pie of Pie or Bar of Pie…
- How to Make a Trendline Solid in Excel and Fix DashesTo make a trendline solid in Excel for Microsoft 365 on Windows, select the trendline, press Ctrl+1, open…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.