There’s no “big thermometer” if that’s what you were hoping for.
However, you could achieve the same thing in one of two ways:
- Use a pie chart, with “amount raised” in one colour and “amount yet to be raised” in another. You would have a formula (goal - amount raised) to calculate automatically the “amount yet to be raised.” You could also segment the “amount raised” by funds, or groups of people, or another divider if you wished. [A bar graph showing “amount raised” in one colour and “goal” beside it in another colour would achieve the same effect.]
- Use a line graph, with dates along the bottom and the line representing the cumulative total raised. You could play around with “group by” and “stack” if you wanted to show individual funds/groups within that.
The second option wouldn’t show as well progress towards the goal. However, as a professional fundraiser, I would sometimes recommend a graph that shows progress over time, which the pie chart (or the big thermometer) does not. It wouldn’t be effective if your fundraising mostly happened at the beginning of the campaign and has been crawling along since; for that, the pie chart would work better. But hopefully, the total has been steadily rising, the excitement building, and the line would show that.
Excel can do fancier charts. For your annual report or whatever, you probably want to export and do something in Excel. But the charts in AirTable are great for quickly whipping together visual results that automatically update.
