Step Progress Chart in Excel: Build a Clear Tracker

A step progress chart is a visual way to show how far a project, process, or checklist has advanced through defined steps. In Excel for Microsoft 365 on Windows, the quickest general-purpose version is a stacked bar chart with a completed portion and a remaining portion; for individually named milestones, pair that chart with a step-status table.

What a Step Progress Chart Shows

The phrase “step progress chart” does not refer to one specific built-in Excel chart type. It can mean a progress bar that fills as steps are completed, a tracker that names each milestone, or a staircase-shaped chart showing values that change at discrete points. The right design depends on what a reader needs to understand: overall completion, the status of each step, or changes in a measured value over time.

For a project with five tasks, for example, a progress bar can show that two are complete and three remain. A table beside it can identify the completed tasks and flag the current one. That combination is usually clearer than trying to fit every task label into one small chart.

Choose the Right Visual

Decide what the chart needs to communicate before building it. A single bar works well for one project or one process. Several bars can compare progress across multiple projects, teams, or workstreams. A milestone tracker is more useful when the names and sequence of the steps matter as much as the overall percentage.

One progress bar: Use a stacked bar to show complete versus remaining work.
Several progress bars: Use one row per project, with completed and remaining values for each.
Named stages: Use a table with a status column, and add a summary bar if an overall view is helpful.
Changing values at discrete times: Use a true step chart, which is different from a task-completion tracker.

A percentage can suggest more precision than the underlying information supports. If the steps vary greatly in effort, counting each step equally may be misleading. A project with two small tasks complete out of four is not necessarily half finished if the remaining tasks are much larger.

Prepare the Step Data

For a simple checklist, enter step names in column A and their statuses in column B. For example, put the headings Step and Status in A1 and B1, then list Plan, Draft, Review, Approve, and Publish in A2:A6. Enter Done for Plan and Draft, In progress for Review, and Not started for the other two. Use the same status wording consistently so Excel can count the entries reliably.

For a single project, create a small chart-data table in D1:F2. Put Stage, Complete, and Remaining in D1:F1, and Overall in D2. With step names in A2:A6 and statuses in B2:B6, enter this formula in E2:

=COUNTIF(B2:B6,"Done")/COUNTA(A2:A6)

With the example data, the result is 0.4, or 40%, because two of the five steps are marked Done. This calculation treats every step equally and counts only Done as complete; an In progress task does not contribute a fraction. In F2, with the completed proportion in E2, enter:

=1-E2

The result is 0.6, or 60% remaining. The two values add to 100%, giving the stacked chart its full length. Keep the step-name range free of blank rows when using COUNTA, because blank entries would change the denominator. If no steps have been entered, add the steps before relying on the percentage calculation.

Create the Stacked Bar Chart

Select D1:F2, including the three column headings and the Overall row.
On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.
Confirm that the chart contains one bar divided into Complete and Remaining portions. If Excel plots the data in an unexpected orientation, use Chart Design > Switch Row/Column.
Change the chart title to something specific, such as “Project completion.”
Format the value axis so its minimum is 0 and maximum is 1. Right-click the horizontal value axis, choose Format Axis, and set the bounds if Excel has not already chosen that range. Format its numbers as percentages if the axis labels are visible.

In this example, the first series, Complete, occupies 40% of the bar and Remaining fills the other 60%. Choose contrasting colors that remain readable, such as a strong color for completion and a light neutral for the unfinished portion. You can remove unnecessary gridlines or the legend if the chart title or labels already explain the meaning. Avoid relying on color alone: a legend or direct labels help readers interpret the sections, including people who have difficulty distinguishing colors.

If you add data labels, check that they display percentages rather than decimal values such as 0.4 and 0.6. Right-click a data label and open Format Data Labels to adjust its number format and position. Excel’s formatting controls can vary slightly by update and platform, but the chart type and underlying two-value structure are the same.

Track Several Projects or Workstreams

To compare projects, give each project its own row in a summary table and create Complete and Remaining columns for every row. Select the headers and data rows, then insert a 2-D Stacked Bar chart. Each project appears as its own bar, making it easier to compare completion levels than a collection of pie charts. Keep project names concise enough to fit along the category axis, and sort the table in a meaningful order, such as priority or planned finish date.

Do not compare percentages without considering scope. A project that is 80% complete may still have more work left than a smaller project that is 30% complete. If the comparison informs a decision, show useful context alongside the bars, such as task count, due date, or owner. A chart can summarize progress, but it cannot explain why a project is delayed or whether its remaining work is unusually difficult.

Show Named Steps and Partial Progress

A summary bar answers “how much is complete?” but not “which step is blocked?” Keep the original step table visible near the chart. A useful tracker may include Step, Owner, Status, Due date, and Notes columns. A status drop-down can reduce spelling differences; in Excel for Windows, select the status cells and use Data > Data Validation, then allow a List and provide entries such as Done, In progress, and Not started.

For a process where stages have different weights, calculate a weighted total instead of counting every stage equally. For example, if planning represents 10% of the effort and testing represents 40%, completion of testing should carry more weight than completion of planning. Document the weights and agree on how to score partially completed tasks before presenting the total. Otherwise, people may interpret the percentage differently.

Another option is to create one row per step and use cell formatting to distinguish its status. That format gives each milestone equal visibility and works especially well when the sequence matters. A chart and a status table serve different purposes: use the chart for a quick overview and the table for operational detail.

Refresh, Read, and Maintain the Chart

When a status changes from Not started or In progress to Done, the formula recalculates and the bar updates. If new tasks are added outside A2:A6, update the formula ranges or convert the source list into an Excel table so added rows can be managed more easily. A fixed range that does not include new rows can make the displayed percentage inaccurate.

Write down the rule behind the percentage, especially in shared workbooks. State whether it means the share of tasks completed, the share of estimated hours completed, or a weighted assessment. For a recurring report, include an “as of” date and identify who updates the statuses. This prevents a visually polished chart from being mistaken for a live or independently verified measure.

Common Problems and Misreadings

The bar does not total 100%: Check that Complete and Remaining use the same scale and sum to 1, or 100%.
The percentage seems too high: Check for duplicated or misspelled step names and confirm that the denominator includes all intended tasks.
New tasks do not affect the result: Expand the formula ranges or use a table-based setup that includes new rows.
The chart looks like a staircase: A stacked bar shows portions of a whole; it is not a true step chart of values changing over time.
“In progress” is treated as zero: That is how the example formula is designed. Decide whether partial work should count and define a consistent scoring rule if it should.

For a true staircase-shaped data chart, Excel does not provide a chart type specifically named Step Chart. Such a chart is normally built from prepared data that repeats transition points and displayed with a suitable line or XY scatter chart. Use that design for values that stay constant between events, such as a price or level changing at particular times—not for a checklist where tasks are simply complete or incomplete.

Excel for Mac and Excel for the Web

The instructions above target Excel for Microsoft 365 on Windows. Excel for Mac also supports stacked bar charts and the same basic worksheet formulas, though ribbon placement and some formatting dialogs may differ. Excel for the web can create and edit common charts, but certain detailed formatting controls may be more limited or arranged differently than in the desktop app. If an axis or label option is unavailable in the web version, open the workbook in desktop Excel to make that adjustment.

Frequently Asked Questions

Is a step progress chart a built-in Excel chart type?
No. It is a general description for a chart or tracker that shows progress through steps. A stacked bar is a straightforward way to show the completed and remaining shares.

How do I calculate progress when steps are equally important?
Divide the number of steps marked Done by the total number of listed steps. The example COUNTIF formula does this for a status list, treating every step as equal and not counting In progress tasks as partially complete.

Can I show the names of the steps on the progress bar?
A single stacked bar usually shows summary portions, not a separate labeled segment for every task. Keep a step-status table beside it, or build a separate milestone visualization when each named stage needs to be visible.

How do I count partially completed tasks?
Choose a consistent rule, such as assigning each task a completion value from 0% to 100%, or assigning effort weights. Then calculate progress from those values rather than counting only tasks marked Done. Explain the method because different scoring rules produce different totals.

What is the difference between a progress chart and a step chart?
A progress chart summarizes how much work is finished. A true step chart displays a value that changes in discrete jumps and stays level between changes. They answer different questions and use different data arrangements.

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.