How to Create a Progress Chart in Google Sheets

Tracking progress towards a big goal can feel like a slog, but seeing how far you've come can provide the boost you need to cross the finish line. A visual progress chart is the perfect tool for this, transforming a sterile percentage into a compelling, at-a-glance graphic. This article will show you several ways to create dynamic progress charts directly within Google Sheets, from classic donut charts to slick, in-cell progress bars.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Visualize Progress in Google Sheets?

Before jumping into the "how," let's briefly touch on the "why." While a single cell showing "75% complete" is accurate, it’s not particularly motivating. A visual chart, on the other hand, does a few powerful things:

• Motivates Action: Seeing that progress ring get closer to completion or a bar fill up gives you a sense of accomplishment and momentum.
• Improves Clarity: It offers an immediate, intuitive understanding of where a project or goal stands without needing to read numbers.
• Enhances Reporting: Dashboards and reports are far more effective with visuals. A progress chart instantly communicates status to team members, managers, or clients.

Google Sheets offers a surprising amount of flexibility for creating these visuals without needing any complex add-ons. Let's build a few different types.

Method 1: The Donut Progress Chart (or 'Progress Ring')

This is probably the most popular way to show progress toward a single goal. It’s essentially a pie chart with a hole in the middle, creating a clean-looking ring that fills up as you get closer to 100%. We’ll achieve this by setting up a simple pie chart and customizing it to look the part.

Step 1: Set Up Your Data

The donut chart needs two values to work: the progress you’ve made and the portion that remains. This allows Google Sheets to create two distinct slices in the chart.

1. Open your Google Sheet. In two adjacent cells, create your headers. Let’s use A1 for "Category" and B1 for "Value".
2. Underneath, list your two categories: "Progress" in cell A2 and "Remaining" in cell A3.
3. In cell B2 (next to "Progress"), enter your current progress percentage. For this example, let's say a project is 75% complete. You can type 75% or 0.75.
4. In cell B3 (next to "Remaining"), you need a formula to calculate the rest. The formula is simply =1 - B2. This ensures that as you update your progress in B2, the "Remaining" portion updates automatically. If B2 is 75%, this formula will yield 25%.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Insert and Customize the Chart

Now that the data is ready, we can create the chart.

1. Highlight the data range, from A2 to B3. Don’t include the headers.
2. Navigate to the menu and click Insert > Chart.
3. Google Sheets will likely default to a standard pie chart. In the Chart editor panel that appears on the right, under the Setup tab, change the "Chart type" to Doughnut chart.

You’ve now got a basic donut chart, but we need to make a few tweaks to turn it into a true progress indicator.

1. Switch to the Customize tab in the Chart editor.
2. Click on Pie slice. You can change the colors here. The goal is to make the "Remaining" slice less visually dominant. Click on the slice label dropdown, select Remaining, and change its color to a light gray. Then, select the "Progress" slice and choose a more vibrant color, like blue or green.
3. Next, let’s add the percentage to the middle of the chart for clarity. Under the Customize tab, go to Chart & axis titles. Delete anything in the "Chart title" field. In the "Chart subtitle" field, enter the percentage you want to display. The easiest way is to format it to directly pull data from B2 -- however Google Sheets does not officially recognize this functionality directly. So simply type in the percent manually as 75% or whatever it may be. To make things simple (although manual), change the font color and size as needed to match your style.
4. Finally, to remove the "Progress" and "Remaining" text next to the chart, go to Legend and set the "Position" to None.

And you're done! You now have a clean, clear donut progress chart that will automatically update every time you change the value in cell B2.

Method 2: Clean Progress Bars with the SPARKLINE Function

If you have a list of goals or projects and want a compact way to track the progress of each one, the in-cell SPARKLINE function is fantastic. It creates a mini-chart right inside a cell, saving tons of space and keeping your data neatly organized in a table.

Step 1: Prepare Your Project Data

Let's imagine you have a list of projects in Column A and their completion percentages in Column B.

• Column A: Project Name (e.g., "Website Redesign", "Q3 Report", "New Ad Campaign")
• Column B: Completion % (e.g., 25%, 90%, 55%)
• Column C: Progress Bar (This is where our formula will go)

Step 2: Use the SPARKLINE Formula

The SPARKLINE function is incredibly versatile, but we'll focus on its "bar" chart type. Click into cell C2 and type the following formula:

=SPARKLINE(B2, {"charttype","bar","max",1})

Let’s break that down:

• B2: This is the data point we want to visualize - our completion percentage.
• {"charttype","bar"}: This part of the formula tells Google Sheets we want to create a bar chart.
• "max",1: This option sets the maximum value for the bar. Since percentages are fractions of 1 (e.g., 55% is 0.55), setting the max to 1 ensures the bar accurately reflects a scale of 0% to 100%.

Press Enter, and a simple progress bar will appear in the cell. You can then click the small blue square on the bottom-right of cell C2 and drag it down to apply the formula to the rest of your projects.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Add Some Style and Color

A black bar is fine, but color makes it much easier to read. We can add color options right into the SPARKLINE formula.

Let's make the progress bar green. Modify the formula in C2 to:

=SPARKLINE(B2, {"charttype","bar","max",1,"color1","green"})

Now, drag the formula down again to update all your bars. You can use any standard color name or an HTML hex code (e.g., "#4285F4" for Google's blue).

Bonus: Create a Two-Tone Progress Bar

For an even cleaner look, you can create a stacked bar that shows the completed part in color and the remaining part in gray, just like the doughnut chart. Modify your data setup with an additional (Remaining %) column.

1. Column A: Project Name
2. Column B: Progress %
3. Column C: Remaining % (=1-B2)
4. Click into cell D1

=SPARKLINE({B2,C2}, {"charttype","bar","color1","green","color2","#dddddd"})

The curly braces {B2,C2} group the two values into a single data source for the chart, creating a stacked effect.

Method 3: Gauge Chart

The gauge chart is ideal when you can classify progress into ranges — for instance, "On Track," "At Risk," and "Behind." With color-coded segments, this gauge-inspired speedometer offers instant status alerts. For example, envision a gauge monitoring budget utilization from 0% all the way up to 100%, segmented as follows:

• Green: 0% to 50% Used
• Yellow: 51% to 75% Used
• Red: 76% to 100% Used

Here’s how to create and customize this insightful speedometer-style chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Set Up Data

1. Choose a cell to type in the label: let’s go with "Utilization" in Cell A1
2. In Cell A2, type how much of something is used -- in our example we will say 87% of the data is used. Your sheet should look like:

Step 2: Insert Chart

1. Select Cells A1 and A2
2. Click on the 'Insert' Menu and then choose "Chart."
3. In the side panel, select the "pie chart" as the chart type. It may look wonky as a separate pie chart with the same progress at this point. That is okay!
4. Within your customization options on the side, check off "Switch Rows / Columns." Next remove 'value' from the "Label" option, and voilà, you have your basic gauge chart reading the current 85% data.

Step 3: Adding The Final Customizations to the Gauge

Add a Max and Min

• On the side menu, click 'Customize" --> 'Gauge"
• You will see fields for both "Min" and "Max" where you can set the numeric parameters for your gauge and really dial in what you are wanting to achieve visually!

The Critical Color Gauge Setting

• One of the top reasons people favor a gauge setting is because it gives the ability to classify ranges, and the colors on the gauge are how those metrics are distinguished. There are up to 4 ranges you can have in the gauge based on 'Minimum' to 'Maximum' settings. For ours, our range minimums are: Green: 0, Yellow: 50, and Red: 75.
• The final gauge will have a green background from 0-50, a yellow background color from 50 to 75, and it will be red until it hits 100. We have input a number like 85%. This final visual gauge will display what color it is at with that given range (red!) A fantastic resource for on-look understanding of data!

Method 4: Thermometer-Style Stacked Bar Chart

A vertical bar chart shaped like a thermometer is another classic way to visualize progress toward a sales target, funding goal, or any cumulative objective.

Step 1: Arrange the Data

Similar to the donut chart, you'll need two data points: the accumulated progress and the remaining amount.

Let's say your fundraising goal is $10,000.

1. In cell A2, label it "Raised". In cell B2, enter the current amount, e.g., $7,800.
2. In cell A3, label it "Remaining". In cell B3, the formula would be =E1 - B2. Let's imagine the goal is in cell E1 with a value of $10,000, so the formula is =E1 - B2.
3. In a cell above your data (e.g., A1), add a clear label like "Fundraising Goal". This will become the chart's title.

Step 2: Insert a Stacked Bar Chart

1. Highlight your data, again from A1 to B3.
2. Navigate to Insert > Chart.
3. In the Chart editor, select the Stacked bar chart. It should default to a horizontal orientation, which is fine, but for the "thermometer" feel, we should set up a Stacked Column Chart. From the data, it will read whichever variable ('progress') on top, and 'remaining' on top, creating two segments on your bar chart. The trick to this visual is to change the color of the "remaining" so that it is none, essentially making the remainder "see-through" but still resembling a thermometer!
4. The next critical step here, on the side customization bar, navigate to "Stacking." Where it pops up, there will be dropdown options, here choose "percent". This will now visually display 'Progress vs 'remaining'.
5. Go to the Customize tab.
6. Under Series, choose the "Remaining" data series from the dropdown. Change its fill color to a light gray or even "white" to make it fade into the background. Set your "Progress" to blue for example.
7. Now to dial in your Chart and Title Axis settings in: Remove both by selecting them and pressing 'delete'. Now you are left with just a clean vertical bar showing the progress.

Final Thoughts

Whether you prefer a sleek donut chart, a space-saving Sparkline, a colorful gauge, or a classic thermometer bar, Google Sheets gives you multiple ways to turn abstract numbers into compelling visuals. Creating these charts helps you focus on your goals and makes it easier to share progress with stakeholders. As you build these charts, consider utilizing tools like Graphed to connect automatically, saving you time and making data management straightforward.

Graphed allows you to ask questions in plain English, like "How are my sales performing across regions?" and immediately get a live dashboard that's always updated.