How to Create a Thermometer Chart in Google Sheets

Tracking progress toward a goal is the cornerstone of any successful marketing campaign, sales quarter, or project. This guide will walk you through creating a visually engaging thermometer chart in Google Sheets to clearly show exactly how close you are to hitting your target.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Thermometer Chart, and Why Should You Use One?

A thermometer chart is a specific type of chart used to visualize progress against a target. As your current value gets closer to your goal, the "mercury" in the thermometer rises. It’s essentially a single, vertically oriented bar chart that is styled to look like old-school fundraising or goal-tracking thermometers.

So, why not just use a standard bar or pie chart? Three reasons:

• It's Instantly Understandable: Everyone knows how a thermometer works. When you see it almost full, you know you're close to the goal. There's zero learning curve for your audience, whether they're team members, executives, or clients.
• It’s Motivating: Seeing that bar creep up towards the goal is a powerful psychological motivator. It creates a sense of momentum and gamifies the process of hitting targets for sales teams, marketing campaigns, or a fundraising drive.
• It Fits Perfectly on Dashboards: Because they are compact and single-purpose, thermometer charts are a perfect addition to any dashboard. They answer one question very quickly: "How are we doing on this specific KPI?"

They are fantastic for tracking things like:

• Quarterly sales revenue vs. target
• Fundraising donations received vs. goal
• New leads generated vs. monthly target
• Project completion percentage
• Event registration numbers vs. capacity

Step 1: Set Up Your Data Structure

The beauty of a thermometer chart is its simplicity, and that starts with the data. You only need to set up three key data points in your Google Sheet.

For our example, let's say we're tracking a quarterly sales goal of $100,000 and we've currently achieved $75,000 in sales.

Here’s how to structure it:

1. Open a new Google Sheet.
2. In cell A1, type your metric name's header, for example: Metric. In cell A2 below it, type Sales Progress.
3. In cell B1, type the header Current Value and in cell B2, enter the number 75000. This is the value you’ll update as you make progress.
4. In cell C1, type the header Target Value and in cell C2, enter the number 100000. This is your static goal.

Your sheet should look like this:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Calculate the Percentage to Complete

The chart itself will be driven by the percentage of the goal that's been achieved. We need to create a simple formula to calculate this.

1. In cell D1, type the header Percent Complete.
2. In cell D2, enter the formula to divide the current value by the target value:

=B2/C2

After you press Enter, cell D2 will display 0.75. To make it a proper percentage, select cell D2, then go to the menu and click Format > Number > Percent. The cell will now correctly show 75.00%.

This "Percent Complete" value is what we'll use to build our chart.

Step 2: Create a Basic Column Chart

Now we’ll create the chart that will eventually become our thermometer. We only need to plot the metric's name and its completion percentage.

1. Select the data for the chart. Click on cell A2 (Sales Progress), then hold down Ctrl (on Windows) or Command (on Mac) and click on cell D2 (75.00%). This selects only these necessary cells, ignoring the values in between.
2. With those cells selected, go to the top menu and click Insert > Chart.
3. Google Sheets will automatically insert a chart. It will likely default to a pie chart, which isn't what we want. In the Chart editor pane that appears on the right, under the Setup tab, find "Chart type" and select the Column chart.

You should now see a very basic, single-bar column chart. This is the foundation of our thermometer!

Step 3: Customize the Chart to Look Like a Thermometer

This is where we transform that basic column chart into a professional-looking thermometer. All these steps are done within the 'Chart editor' pane on the right-hand side.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Adjust the Vertical Axis Scale

This is the most critical step. We need to force the chart's vertical axis to always go from 0% to a maximum of 100%. This ensures the bar height accurately represents its progress toward the full goal.

1. In the Chart editor, click on the Customize tab.
2. Expand the Vertical axis section.
3. In the "Min" value box, type 0.
4. In the "Max" value box, type 1. (Remember, 1 represents 100% in spreadsheet terms).

As soon as you do this, you'll see the chart's Y-axis change to a 0% - 100% scale, and the bar will now occupy exactly 75% of the total chart height.

Style the Bar ("Series")

Next, let's style the column itself to make it cleaner and more visually appealing.

1. In the Customize tab, expand the Series section.
2. Here you can change the Fill color. A nice green or your brand color works well to indicate positive progress.
3. To make the measurement clear without needing to read the axis, check the box for Data labels. This will display "75.00%" directly on the bar. You can then adjust the label's position, font size, and color to make it easy to read. Placing it "Inside end" or "Center" usually looks best.

Make the Thermometer Thinner

By default, the column is quite wide. To get that classic thin thermometer look, we need to perform a little trick.

1. Close the chart editor for a moment and select your chart. Click the three vertical dots in the top-right corner of the chart and select "Edit chart."
2. Go back to the Setup tab.
3. Right now, the "Data range" is something like A2,D2. Click the grid icon next to the data range to select a new range.
4. With the selector open, click and drag to select not only cells A2 and D2 but also an empty cell next to D2. For example, drag over A2:E2. The key is to include at least one empty column next to your percentage data. Click OK.
5. You'll notice the bar is now much skinnier because Google Sheets is saving space for the "empty" data series you added. Go to the Customize > Legend section and set the position to "None" to hide the markers for the blank series.

You now have a slim, professional-looking thermometer chart!

Step 4: Putting It All Together on a Dashboard

A chart on its own is useful, but placing it in context with its raw numbers makes it even more powerful. Instead of keeping a chart title, it's often more effective to remove the titles and axes and just display the key numbers next to the chart.

First, clean up the chart:

• In the Chart editor > Customize tab...
• Under Chart & axis titles, delete the text for the Chart Title to remove it.
• Under Horizontal axis, check "Treat labels as text" if needed. Then, you can change the label font color to white (or the background color) to make it disappear, giving you a very clean look. You can also delete the text in cell A2 if you prefer.
• Under Legend, set Position to "None." You should already have done this in the previous step.

Now, arrange the chart and the key data points neatly:

1. Resize your thermometer chart to be tall and narrow.
2. In the cells directly above or next to the chart, reference your core stats. For example, format two cells with a large, bold font.
3. In the first cell, use a formula to display the current progress: =B2 (your "Current Value"). Format this as currency.
4. In the cell below, use a formula to display the target: "of " & TEXT(C2, "$#,##0") & " Goal". This dynamically creates the label "of $100,000 Goal."

By arranging these elements together, you create a self-contained, easy-to-read "widget" that you can drop into any dashboard or report.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Thoughts

Creating a thermometer chart in Google Sheets is a simple but powerful way to visually track your most important goals. By setting up your current and target values, calculating the completion percentage, and customizing a simple column chart, you can build a motivating and clear visual that anyone can understand in seconds.

While DIY charts are great for specific tracking needs, connecting and visualizing data from all your marketing and sales platforms manually can take hours. At Graphed, we've built a tool to solve this. Instead of juggling CSVs and formulas, you can connect your platforms like Google Analytics, Shopify, and Facebook Ads, and just ask simple questions in plain English. For example, asking "Create a dashboard tracking our Q3 sales progress vs. target" instantly generates a live, real-time dashboard that keeps itself updated. If you're ready to get your time back, check out Graphed and start getting answers from your data in seconds, not hours.