Google Sheets Progress Meter: Make a Chart or Bar

In Google Sheets, the quickest progress meter is a SPARKLINE bar inside a cell: if B2 contains a percentage from 0% to 100%, enter =SPARKLINE(B2,{"charttype","bar";"max",1;"color1","#34A853"}) in another cell. For a larger visual, select your data and use Insert > Chart, then choose a gauge or bar chart in the Chart editor.

These options serve different purposes: a SPARKLINE is a small, live bar that sits in a worksheet cell, while a gauge or bar chart is a separate chart object that can be resized and presented. The best choice depends on whether you need a compact status indicator, a dashboard graphic, or a comparison across many tasks.

How a Google Sheets progress meter works

A progress meter represents a value relative to a known range. For a simple task, that range is usually zero to one hundred percent: zero means nothing is complete, one-half means 50% is complete, and one means complete. In Sheets, a percentage is stored as a decimal, so 65% is represented by 0.65. A meter needs that consistent scale; a raw count such as 13 completed tasks is not itself a percentage unless the total is also known.

Google Sheets includes the SPARKLINE function, which draws a miniature chart in a cell. Its bar type is well suited to a progress indicator because it draws a filled section against the scale you set. The formula’s "max",1 option fixes the full bar at 1, or 100%, instead of letting the bar scale change based on the current value. Without a fixed maximum, a value could look full even when it represents only a small share of the real goal.

SPARKLINE is a function, not a chart inserted through the Chart editor. That distinction matters: you can fill the formula down a column to make a row-by-row status table, but it does not have the same chart-object controls, legends, and layout options as a regular chart.

Build a meter from completed and total items

A reliable setup starts with the underlying numbers and calculates progress from them. For example, put completed tasks in C2 and total tasks in D2. If the project has 13 completed items out of 20, C2 is 13 and D2 is 20. In E2, enter =IFERROR(C2/D2,0). The result is 0.65; format E2 as a percentage using Format > Number > Percent to display 65%.

The IFERROR wrapper makes a zero or blank total display as zero rather than an error. That can be useful in a tracker that is set up before its task count is known. It also means that a missing total looks like zero progress, so consider showing a separate status such as “Add total” if readers might mistake the placeholder for a real measurement.

With E2 holding the calculated percentage, put the meter in F2 using =SPARKLINE(E2,{"charttype","bar";"max",1;"color1","#34A853"}). It draws a green bar filled to 65% of its width. Copy the formula down for other rows, updating the percentage reference for each one. The color code can be changed to another valid hex color, such as "#4285F4" for blue.

For a straightforward tracker, a useful layout is:

Column A: task or project name.
Column C: completed items.
Column D: total items.
Column E: calculated percentage.
Column F: SPARKLINE progress bar.

Keep the percentage visible as well as the bar. A bar gives a quick visual impression, but a number such as 65% is more precise and easier to compare when two bars are close in length.

Choose between a SPARKLINE, gauge, and bar chart

Use a SPARKLINE when each row needs its own compact indicator. It works well in a project list, classroom tracker, checklist summary, or dashboard table. It updates when the referenced value changes and stays attached to the cell grid. Widen the meter column enough to see meaningful differences, and adjust row height if the sheet feels crowded.

Use a gauge chart when you want to emphasize one key value, such as the overall completion rate for a project. Select the cells containing the value, choose Insert > Chart, and select Gauge chart in the Chart editor’s Setup tab. A gauge is more prominent than a cell bar, but it takes more room and is less convenient for showing a long list of separate projects. Check the displayed scale and ranges in the chart’s customization options so the visual agrees with the percentage you intend to communicate.

Use a bar chart when the point is comparison: for instance, which of six teams is closest to its target. Select category labels and percentages, choose Insert > Chart, and select a bar chart in Setup. A chart is easier to label and present than many tiny meters, although it occupies more space and may need a clear title and axis scale. If you need a filled-to-target look, a stacked bar can use one series for completed progress and another for what remains.

One status in a compact table: SPARKLINE bar.
One prominent headline measure: gauge chart.
Comparison across categories: bar chart.
Progress toward a target with a visible remainder: stacked bar chart or paired SPARKLINE cells.

Format and customize the meter

The basic formula sets the bar type, its maximum, and its positive color. A fixed maximum is especially important when you copy the formula down: with every row measured against 1, a 40% bar is consistently shorter than a 70% bar. Use a separate cell for the percentage and another for the SPARKLINE so that sorting, filtering, and checking the math remain straightforward.

Formatting the source percentage as Percent does not change its stored value. A cell containing 0.65 and formatted as 65% still supplies 0.65 to the SPARKLINE, which is why the formula uses a maximum of 1. If instead your data is entered as the number 65, either convert it to a true percentage or use an appropriate maximum such as 100. Mixing these conventions is a common cause of bars that appear full or nearly empty.

You can also set the bar’s appearance through the formula options. Keep the color consistent for a simple completion meter; use a different color only when it conveys a clear state, such as progress below a threshold. For a label, retain the adjacent percentage or add a text label in a neighboring cell. Avoid relying on color alone, since color differences can be difficult for some readers to distinguish and may not print as expected.

Google Sheets has conditional formatting, but it does not provide Excel’s familiar in-cell “data bars” conditional-formatting rule in the same way. In Sheets, a SPARKLINE is the direct way to make a bar inside a cell. Conditional formatting can still highlight the percentage cell based on rules, but that is a cell fill or text style rather than a variable-length bar.

Build a comparison chart with completed and remaining work

A stacked bar chart can make the uncompleted portion visible as well as the completed portion. Suppose E2 contains the progress fraction. Put a remaining fraction in F2 with =1-E2. For a 65% completion value, F2 returns 0.35, so the two series add to 1. Label the columns “Complete” and “Remaining,” select the project names and both series, then choose Insert > Chart and a stacked bar chart in Setup.

For several projects, each row should have a project name, a completed fraction, and a remaining fraction. Keep both series on the same 0-to-1 scale; otherwise, the bars will not represent the same whole. In the Chart editor, use Customize to adjust colors, legend, and chart and axis titles where those settings are available. The completed segment should be visually distinct from the remainder, but use a muted remainder color so the completed portion remains easy to scan.

This chart is useful when audiences need to compare both achieved work and what is left. It is not automatically better than a simple percentage chart: adding a remainder series and legend can clutter a small dashboard. For one project, a single bar or gauge is often clearer; for a table of many projects, inline SPARKLINE bars may take up less space.

Common problems and how to fix them

The bar looks completely full: Check the scale. If the cell contains 65 rather than 65% (0.65), a maximum of 1 does not match the input. Convert the value to 0.65 or use a maximum of 100.
The bar’s length changes unexpectedly: Set a fixed maximum with the SPARKLINE option "max",1 for percentage data. A consistent scale makes values comparable from row to row.
The formula shows an error: Confirm that the referenced cell contains a number, and that the formula’s quotation marks and braces are intact. If your spreadsheet uses a locale with different formula separators, Sheets may require locale-specific separators; its suggested formula syntax can help identify the correct form.
A percentage is above 100%: Decide whether exceeding the target should be allowed. If it is, set a larger maximum to show the over-target amount proportionally, or cap the display at 100% while keeping the true value in another cell. Do not hide overachievement unintentionally.
A zero total creates an error: Guard the division with IFERROR or explicitly handle a blank or zero total. Decide what the display should mean before using zero as a placeholder.
The chart is hard to read: Verify that labels and values are selected together and that percentage values use one consistent scale. A chart with unrelated counts and percentages can imply a comparison that the data does not support.

Google Sheets versus Excel

The instructions here are for Google Sheets in a web browser. Sheets supports SPARKLINE bars as cell formulas and provides a Chart editor for gauge, bar, and other chart types. Microsoft Excel also has a SPARKLINE feature, but its interface and function options are not identical to Google Sheets; an Excel formula or menu instruction should not automatically be assumed to work in Sheets. Excel also offers conditional-formatting data bars, whereas Sheets users commonly use SPARKLINE for a cell-sized progress bar.

If you share a workbook with people who use both spreadsheet products, test the visuals in the destination application. A regular chart may transfer more predictably than a formula-based miniature chart, but chart styling and supported chart types can still change. For a cross-platform report, keeping the percentage value and a simple bar chart can be more dependable than relying on a particular in-cell visual feature.

Frequently Asked Questions

Can Google Sheets show a progress bar inside a cell?
Yes. Use the SPARKLINE function with the bar chart type. For a percentage in B2, =SPARKLINE(B2,{"charttype","bar";"max",1;"color1","#34A853"}) makes a compact bar whose full scale is 100%.

How do I make the progress bar show a percentage?
Keep a percentage value in one cell and put the SPARKLINE in a neighboring cell. Format the value cell with Format > Number > Percent, and leave it visible so the exact number accompanies the visual.

Can I change the color of a Google Sheets progress meter?
Yes. Change the color value in the SPARKLINE options, for example from "#34A853" to "#4285F4". Use a color with sufficient contrast and do not make color the only way to tell whether progress is on track.

Can I create a circular progress meter in Sheets?
Sheets offers a Gauge chart for a prominent single value. Select the metric, choose Insert > Chart, then choose Gauge chart in the Chart editor. It is a separate chart object, not a circular SPARKLINE inside a cell.

Why does my progress bar show as full when the value is less than 100%?
The formula may be using a maximum that is too small or the input may be stored on a 0-to-100 scale rather than a 0-to-1 scale. For percentage data stored as 0.65, set the maximum to 1; for a value stored as 65, convert it or use a maximum of 100.

Make the meter useful, not just decorative

A progress graphic is only as meaningful as the number behind it. Define what counts as complete, keep the denominator current, and make sure every row uses the same interpretation of progress. For example, 8 of 10 tasks complete is 80%, but it does not necessarily mean a project is 80% of the way through if tasks vary greatly in effort. A weighted measure may be more appropriate when that distinction matters, provided the weights are explained.

For a practical dashboard, show the project or task name, the exact percentage, and a consistent bar. Use a gauge when one overall result deserves attention, a regular chart when comparing groups, and SPARKLINE when the meter needs to fit naturally into a sheet. That combination of clear inputs, a fixed scale, and the right visual makes a Google Sheets progress meter easy to interpret and maintain.

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.