TL;DR / Summary: A fundraising thermometer is a percentage, and percentages are easy to get wrong in public. Anchor the goal, update the bar from a single spreadsheet cell, and never let the display claim more than 100% unless you plan to explain it.
The bar is a claim about progress
A thermometer chart is not decoration. It is a public statement of how much has been raised against a target, and people make donation decisions based on it. A bar that overstates progress is a small dishonesty that donors notice when the total is announced.
The arithmetic is a single division: amount raised divided by goal, expressed as a percentage. The complexity is entirely in deciding what counts as raised.
Pledges are not cash. A pledge that has not arrived is a promise, and including promises in the bar is the most common way a fundraiser ends up explaining a gap at the end.
Decide what counts before you publish
Define the numerator explicitly and write it in the notes of the spreadsheet. Received funds only, or received plus confirmed pledges, or received plus matched funds.
If matched funds are involved, decide whether the match is counted when pledged or when received. Both are defensible; mixing them across updates is not.
- Cash received — the safest numerator
- Confirmed pledges — acceptable if clearly labelled
- Pending match — usually best held out until it lands
- In-kind donations — count separately or not at all
Whatever you choose, apply it consistently. A bar that jumps because the definition changed teaches donors to distrust the bar.
The goal itself
Pick a goal that includes fees if fees are deducted from donations. A goal of ten thousand with a three percent processing fee needs to raise slightly more than ten thousand to net the target.
State whether the goal is gross or net. It sounds pedantic until the final total is three hundred short and nobody can explain why.
Building the sheet
Keep the source data in one place: a date column, an amount column, and a running total. Everything else—the percentage, the bar, the label—derives from that total.
Never type the percentage by hand. Hand-typed percentages drift from the underlying data within a week, and the drift is always in the flattering direction.
Use a formula for the percentage, rounded to one decimal place. More precision implies more accuracy than the data supports, especially with pledges.
One source of truth, one formula, one bar. Anything else is a rumour with a chart.
Displaying the bar
A simple approach is a stacked bar or a filled shape sized by the percentage. In a spreadsheet, conditional formatting or a bar chart both work; the goal is a visual that updates when the number changes.
Cap the visual at 100% even if the total exceeds the goal, and add a separate “over goal” note. An overflowing bar looks like a design error, and it hides the achievement.
Label the bar with both the amount and the percentage. Amounts alone are hard to compare across campaigns; percentages alone hide the scale of the need.
Updating in public
If the thermometer is displayed at an event, update it on a schedule rather than whenever someone remembers. A bar that changes every ten minutes looks manipulated; one that changes at announced intervals looks disciplined.
Announce the update time. “We will update at six and again at eight” sets expectations and gives people a reason to check back.
Photograph the display at each update. If there is ever a question about the final figure, the photographs are a dated record.
Online and offline versions
Online pages and printed posters should use the same underlying numbers. When they diverge, the discrepancy is discovered by the most diligent donor, which is the worst possible audience for an error.
Regenerate the printed version from the same sheet rather than updating it by hand. A printout is a snapshot, and the snapshot should match the sheet at the moment it was taken.
Handling the awkward cases
Refunds happen. Decide in advance how a refund affects the bar and whether the public total will go down. Public totals that only ever rise, even after refunds, are a credibility risk.
Large single donations distort the bar and can discourage smaller donors. One response is to show both total progress and donor count, which gives small donors a different way to feel part of the campaign.
If a campaign falls short, say so with the real number. A shortfall explained honestly raises more for the next campaign than a chart that quietly stopped updating.
A short checklist before publishing
Confirm the numerator definition, confirm the goal is gross or net, check the formula, round to one decimal place, and cap the visual at 100%.
Then check the label. “Raised” and “pledged” are different words and must not be used interchangeably on the same chart.
For the division itself, a percentage calculator is quicker than rebuilding the formula in a new sheet, and it gives the same answer the spreadsheet will produce.
A thermometer is a trust instrument. Keep the arithmetic visible and the definition stable, and it will do the job it was built for.
Reporting after the campaign
Publish a final total and a short breakdown: raised, spent on costs, and net to the cause. Donors who gave to a thermometer deserve the closing number.
Show the percentage of goal achieved even if it fell short. An honest closing report builds more trust than a quietly discontinued page.
Thank donors by name where consent allows. The next campaign starts with the people who felt recognised at the end of the last one.