Dot Progress Chart in Excel: Create One Step by Step

Excel does not include a built-in chart type called a dot progress chart, but you can create the same visual with a row of filled and unfilled dots. For a quick dashboard, put progress values in cells and use a formula to display one dot per unit; for a conventional plotted chart, use an XY scatter chart with dot markers.

What a dot progress chart shows

A dot progress chart represents completion as a sequence of dots: filled dots show completed units, and empty dots show the remaining units. A project at 6 of 10 units, for example, appears as six filled dots followed by four empty ones. Labels can identify projects, targets, or people, while the dot row makes relative progress easy to scan.

The phrase can also describe other dot-based visuals, such as a dot plot comparing separate values. Here, the focus is a progress indicator with a defined target. The distinction matters because Excel does not offer a dedicated “dot progress” command in the chart gallery. A formatted worksheet range is often the simplest and most readable solution; it behaves like a chart in a dashboard, but is not technically an Excel chart object.

Choose a layout that fits the data

First decide what each dot will mean. If progress is naturally counted in whole items—tasks completed out of 20, for instance—use one dot per item. If progress is a percentage, choose a fixed scale such as 20 dots, with each dot representing five percentage points. A fixed scale lets readers compare rows consistently.

One dot per unit: useful when the target is a small, meaningful count, such as 8 of 12 milestones.
Fixed number of dots: useful for percentages or projects with different totals. Twenty dots make the visual easy to interpret in five-point increments.
Actual chart: useful when you need a chart object that can be resized, copied, or placed separately from the worksheet cells.

Avoid using one dot for every item when targets differ greatly. A project with 5 of 10 tasks would then have fewer possible dots than one with 5 of 100, making the display harder to compare. In that case, show the percentage on a common dot scale or put the completed and target counts beside each row.

Build a dot progress display with cells

This example uses 20 possible units. In a new worksheet, enter Project in A1, Completed in B1, Target in C1, and add dot positions across D1:W1. Put a project name in A2, the number completed in B2, and the target in C2. For example, enter Website launch, 12, and 20. The values in B and C should be numbers, and completed should not exceed the target.

With completed units in B2 and the target in C2, enter this formula in D2, then fill it right through W2:

=IF(COLUMNS($D2:D2)>$C2,"",IF(COLUMNS($D2:D2)<=$B2,"●","○"))

The formula counts its position across the row. Positions up to the completed value show a filled dot; later positions up to the target show an empty dot; positions beyond the target stay blank. With B2 equal to 12 and C2 equal to 20, D2:W2 displays 12 filled dots and 8 empty dots. Copy the formula down for other projects. Keep the same 20 dot columns for every row if you want a common visual scale.

The formula uses the COLUMNS function to count across the range from D to the current cell. The dollar signs keep the starting column fixed when you fill right, while the row number can change when you copy the formula down. In some regional Excel settings, list separators are semicolons rather than commas; use the separator expected by your installation if Excel rejects a formula copied from another region.

Format the dots for readability

Select the dot cells and center-align them. Choose a font size large enough to distinguish the symbols without making the rows too tall. A common sans-serif font usually displays the filled circle ● and open circle ○ clearly, but appearance can vary by font and operating system. If a symbol appears as a square, change the font or use a simpler character such as a filled bullet and a hyphen.

Set the dot columns to a consistent, narrow width and turn off wrapping for those cells. Keep project names and numeric values outside the dot area rather than squeezing labels into it. A clean example might show “Website launch,” “12 / 20,” then the row of dots. The count remains important: color and symbol appearance alone may not communicate the exact value, especially in a printed report or for readers who cannot distinguish the colors.

For stronger visual contrast, use a darker font color for completed dots and a lighter gray for remaining dots. You can apply formatting to the formula results or use conditional formatting, but test the symbols in the workbook’s intended font and display environment. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 opens the corresponding formatting dialog. The exact appearance may differ on Excel for the web, where available controls can also depend on the browser.

Use percentage progress instead of counts

For percentages, a fixed 20-dot scale gives each dot a value of five percentage points. Enter a percentage such as 60% in B2 and use 20 dot cells from D2:W2. With the percentage stored in B2 as a normal Excel percentage value, enter this formula in D2 and fill right through W2:

=IF(COLUMNS($D2:D2)<=ROUND($B2*20,0),"●","○")

At 60%, the formula calculates 12 filled dots because 0.60 multiplied by 20 is 12; the remaining eight are open. Excel stores 60% as 0.6, so do not enter 60 as a plain number unless you change the formula to match that scale. ROUND converts the result to a whole number of dots. At percentages that fall between increments—for example, 62%—the display rounds to the nearest dot, or 60% on a 20-dot scale. Show the exact percentage in a neighboring cell if that distinction matters.

For targets that change, keep the percentage scale fixed rather than allowing the number of dot columns to vary by row. This makes a 60% project look the same whether its underlying target is 10 tasks or 100. You can retain the underlying completed and target counts in adjacent columns for auditing and detail.

When to use a real Excel chart

If the visual must be a separate chart object, an XY scatter chart can plot one marker for each progress value. Create helper data with a numeric horizontal value for progress and a separate numeric vertical position for each category. Select the helper data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Format the series to use markers and no connecting line. The horizontal axis can run from 0 to 100% (or from 0 to the common target), and the vertical positions separate the projects.

A scatter chart requires more setup than the cell method: category labels need to be associated with the vertical positions, and a progress target may need its own series or reference line. It is worthwhile when you need chart-level resizing, a legend, or a visual that updates as a chart object. For a compact project status table, dot-filled cells are usually easier to maintain and keep labels aligned with the data.

Another common alternative is a data bar. Select the percentage cells, then choose Home > Conditional Formatting > Data Bars. Data bars show length rather than discrete dots, so they are often more suitable for continuous progress. They do not create a dot chart, but may communicate a percentage more directly. You can display both a data bar and a number, or use the dot row when the discrete steps themselves are meaningful.

Common problems and useful checks

Too many or too few dots: confirm that the entered completed count is a number and is within the target. Text that looks numeric may not compare as expected.
Dots run past the target: check that the formula includes the target test and that the formula was filled across the intended number of columns.
Every project looks equally complete: verify that each row references its own completed and target cells. When copying down, relative row references should adjust automatically.
Percentage display is off: check whether the source value is a percentage such as 60% (stored as 0.6) or a whole number such as 60. The formula above assumes the percentage format.
Symbols look inconsistent: use a consistent font, size, alignment, and column width. Check the result after exporting or printing because symbol rendering can change.

Also decide how to handle a zero target. A zero denominator cannot produce a meaningful completion percentage, so do not silently treat it as complete. Correct the source data or define a separate status such as “Not started” or “Not applicable.” If progress can exceed a target, decide whether that should be capped visually or shown as over target; the basic cell formula displays only as many dots as the target columns allow, so put the over-target amount in a separate value or status field.

Frequently Asked Questions

Does Excel have a dot progress chart template?
No dedicated chart type with that name is built into Excel. You can create a dot-style progress display with worksheet formulas and formatting, or use an XY scatter chart if you need a separate chart object.

How do I make a dot show progress as a percentage?
Choose a fixed number of dots, such as 20, and use the percentage value to determine how many are filled. With 20 dots, each represents five percentage points. Display the exact percentage next to the dots if rounding would hide useful detail.

Can I use different targets for different projects?
Yes. For a count-based display, place each project’s completed count and target in separate columns and use the target-aware formula above. For comparing projects visually, a common percentage scale is usually clearer than giving every row a different number of possible dots.

Can I change the dot color automatically?
Yes. You can format formula cells directly or apply conditional formatting rules to the dot range. Keep enough contrast between completed and remaining symbols, and include a numeric value or label so the status is not communicated by color alone.

Will the dot display update when the values change?
Yes. The formulas recalculate when the completed value, target, or percentage changes, provided Excel calculation is enabled. The dot row has a fixed number of cells, however, so add more dot columns if you want to support a larger maximum target.

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.