To make a progress doughnut chart in Excel for Microsoft 365 on Windows, enter a completed percentage and its remainder in two cells, select both values, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Format the two slices as progress and remaining, remove unnecessary chart elements, and place a percentage label in the center if you want the value to be immediately clear.
What a progress doughnut chart shows
A progress doughnut chart is a regular doughnut chart arranged to show how much of a whole is complete. It is not a separate built-in Excel chart type: the visual is made from two values, one for progress and one for the uncompleted portion. For example, 63% complete is represented by a progress value of 63 and a remaining value of 37. Together, the two slices make 100% of the ring.
This design works well for a single headline measure, such as a task completion rate, a training course, a project milestone, or a target reached. The ring gives a quick visual impression, while a number in the middle can provide the exact value. It is most useful when the audience needs a compact status indicator rather than a detailed comparison of many categories.
A doughnut can look like a gauge, but it does not automatically communicate a target, deadline, or rate of change. A chart showing 63% complete does not tell a reader whether that is ahead of schedule. If timing matters, include a due date, expected progress, or a short status note elsewhere in the report.
Prepare the values in Excel
Start with a small two-row table. In this example, enter “Progress” in A2 and 63 in B2, then enter “Remaining” in A3. With the progress value in B2, enter this in B3 to calculate the portion left out of 100:
=100-B2
The example returns 37, so the chart will use 63 and 37. Keep both values nonnegative and make sure their total is 100 if you are entering a percentage as a number from 0 to 100. This setup is easy to understand and avoids charting the progress value against an unrelated number.
If you prefer to enter a decimal percentage such as 63% in B2, use a remainder that is also expressed as a decimal. With the progress percentage in B2, enter this in B3:
=1-B2
If B2 contains 63%, B3 returns 37%. Format the cells as percentages if you want the worksheet values to display with percent signs. Either approach works; the key is not to mix a value on a 0-to-100 scale with one on a 0-to-1 scale.
For a goal measured in units rather than a percentage, you can calculate a capped completion share first. Suppose B2 contains the amount completed and B3 contains the target. With those values in place, enter this formula in B4:
=MIN(B2/B3,1)
For a completed amount of 63 and a target of 100, B4 returns 0.63. The MIN function caps the displayed share at 1, so an amount above the target does not create a negative remainder. With the calculated progress share in B4, enter this in B5:
=1-B4
B5 returns 0.37 in the example. Chart B4:B5 for the ring, and format B4 as a percentage for display. If the target cell can be blank or zero, decide how the workbook should handle that case before distributing it; dividing by zero produces an Excel error.
Insert the doughnut chart
- Select the two labels and their values, such as A2:B3. Including the labels helps Excel create a legend if you later choose to keep one.
- On the ribbon, choose Insert > Insert Pie or Doughnut Chart > Doughnut. Excel inserts a doughnut chart using the two categories.
- Move or resize the chart using its border. Keep it large enough that the remaining slice and any center label can be read clearly.
- Use the chart’s buttons or the Chart Design tab to add or remove elements, depending on the version and layout of the ribbon.
If Excel plots the values in an unexpected order, check that the selected range contains just the two intended categories and values. You can also use Chart Design > Switch Row/Column if the data has been interpreted in the wrong orientation. For this simple two-row table, selecting the labels and values together is usually the clearest starting point.
On Excel for Mac, the chart is also created from the Insert tab’s chart controls, though the ribbon arrangement and some contextual options can look different. Excel for the web supports creating charts, but detailed formatting controls may be more limited or arranged differently from the Windows desktop application.
Format the ring and its slices
Give the progress slice a strong color and the remaining slice a subdued neutral color. To format a slice, select the chart, click the relevant slice, and open the formatting pane by right-clicking and choosing Format Data Point. Selecting a slice once may select the whole series; selecting it again targets the individual point. The exact selection behavior can take a little care, so confirm which part of the ring is highlighted before changing its fill.
To adjust the thickness of the ring, right-click a slice and choose Format Data Series. In the formatting pane, adjust Doughnut Hole Size. A larger hole leaves more room for a center number but makes the colored ring thinner. A smaller hole makes the ring more prominent but leaves less space inside. Choose a proportion that remains legible at the chart’s final display size.
The first-slice angle can rotate the ring if the progress segment begins in an awkward position. In Format Data Series, adjust Angle of first slice and inspect the result. A small change can make a compact chart easier to scan, but avoid rotating the chart so far that viewers cannot tell which arc represents progress. Keep the colors and slice order consistent across a dashboard.
For a clean indicator, remove the legend if the two colors are self-explanatory and the center label or nearby text identifies the measure. You can remove a chart element by selecting it and pressing Delete, or use the chart element controls. A short chart title such as “Course completion” may be more informative than a generic “Progress” title, especially when several charts appear together.
Add a clear percentage in the center
A doughnut chart does not automatically place the progress percentage in its hole. One option is to insert a text box over the center and type a value such as “63%.” This is quick for a static graphic but must be updated manually whenever the source data changes. For a changing dashboard, link a text box to a worksheet cell instead.
For example, with progress in B2 and remaining in B3, enter this in D2 to calculate the share as text formatted with a percent sign and no decimal places:
=TEXT(B2/SUM(B2:B3),"0%")
With values 63 and 37, D2 displays 63%. Select the chart, choose Insert > Text Box, draw the text box in the hole, select the text box, click the formula bar, type =D2, and press Enter. The text box then displays the cell’s result and updates when the source values change. Center the text and use a readable font size; a large number with a smaller label beneath it can work well if the text box is wide enough.
Because a linked text box sits on top of the chart, it can shift if the chart is resized or the layout changes. Recheck its position after changing the chart’s dimensions. If the label is essential, make sure it remains visible when the workbook is opened on another screen or exported to PDF.
Choose the chart for the question
A progress doughnut chart is best when there is one completion figure and a clear whole. It becomes less effective when used to compare many projects, show small differences, or communicate several measures at once. Several rings can create an attractive dashboard, but readers may struggle to compare angles and distinguish similar colors.
- Use one doughnut for a single percentage such as 63% of a project completed.
- Use a bar chart when comparing completion across teams, projects, or months. Bar lengths are generally easier to compare precisely than ring segments.
- Use a line chart when the important story is how progress changes over time.
- Use a table or KPI card when readers need exact values, targets, owners, or dates more than a visual proportion.
A common misconception is that a doughnut chart can show progress beyond 100% simply by making the progress slice larger. In a two-value chart, the slices represent parts of a whole, so values above the target need a deliberate design choice. The capped formula shown earlier keeps the ring at 100% and lets a separate label report an over-target result. Alternatively, show the actual amount and target in a bar chart or KPI, where exceeding the target is easier to represent honestly.
Common problems and practical fixes
The ring looks completely filled: Check that the chart includes both the progress and remaining values. If the remaining cell is blank, zero, or outside the selected range, the chart has no visible remainder. Confirm that the two values add to the intended whole.
The wrong slice has the highlight color: Check the labels and order in the source data. Excel assigns colors by data point, so changing the row order can change which category receives a color. Select and format the intended point rather than assuming the first slice always means progress.
The displayed percentage is wrong: Decide whether the cells contain whole numbers such as 63 and 37, or decimal percentages such as 63% and 37%. Do not apply an extra percentage conversion to whole-number inputs. For a linked center value, calculate the share from the progress and total, or link to a cell already containing the intended display value.
The label does not fit: Increase the doughnut hole, reduce the font size, or shorten the label. Avoid shrinking the chart until the ring becomes too thin to distinguish. If the exact percentage and measure name are both necessary, place the name above or beside the chart rather than forcing several lines into the center.
The chart is hard to understand without color: Add a clear title or nearby text identifying the measure, and do not rely on color alone when the distinction matters. Use strong contrast between the progress and remaining slices. A chart intended for printing should also be checked in grayscale.
Frequently Asked Questions
Can Excel make a progress doughnut chart automatically?
Excel has a Doughnut chart type, but not a dedicated progress-doughnut command. Create the effect by charting two values: the completed amount and the remainder of the whole.
How do I show 0% or 100% progress?
Use a progress value of 0 and remainder of 100 for 0%, or progress of 100 and remainder of 0 for 100%. The ring may appear as a full neutral circle at 0% or a full progress circle at 100%, so add a center label to make the state explicit.
Can the center percentage update when the data changes?
Yes. Calculate the display value in a worksheet cell, insert a text box over the doughnut hole, select the text box, enter a cell reference in the formula bar, and press Enter. The linked text updates with the cell.
Can a progress doughnut show more than 100%?
A standard progress-versus-remainder ring represents a whole, so it is not a good way to show an amount beyond the target. Cap the ring at 100% and report the actual over-target value separately, or choose a chart type designed to compare actual values with a target.
Is a doughnut chart better than a progress bar?
Not in every case. A doughnut is compact and works well as a single dashboard indicator; a bar is usually easier to compare across several items or to read precisely. Choose the one that makes the intended comparison clearest.
Related
- Open a New Excel Spreadsheet: Quick Steps and Options
- OpenOffice Excel Files: How to Open, Edit, and Save
- Open Excel Files Online: Your Options Explained
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Microsoft Excel Sparklines: How to Add and Format ThemMicrosoft Excel sparklines are small charts displayed inside individual worksheet cells, making it easy to spot a trend…
- Excel Sparklines Examples for Sales, Trends, and KPIsExcel sparklines are tiny charts placed inside worksheet cells, useful for showing a trend beside the number it…
- Add a Line to a Clustered Column Chart in ExcelTo add a line to a clustered column chart in Excel, select the chart, choose Chart Design >…
- Excel Histogram Frequency Table: How to Make OneAn Excel histogram frequency table shows how many numeric values fall within each interval, or bin. In Microsoft…
- Excel Comparison Chart Examples and How to Build ThemExcel comparison chart examples include clustered column charts for comparing sales across products, bar charts for ranking categories,…
- Pivot Power Skating: How to Turn, Train, and ImprovePivot power skating is the practice of changing from forward to backward skating, or backward to forward, while…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.