How to Create Fundraising Thermometer in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is one of the most beneficial programs you can use. Using Excel’s features and tools, you can do an almost infinite number of things with a dataset. This article will discuss the steps necessary to make a thermometer for a fundraising event. A fundraising thermometer shows us how close we reach a fundraising target. In light of this, the subsequent lesson will focus on the step-by-step process of establishing a fundraising thermometer in Excel.


What Is Fundraising Thermometer?

A fundraising thermometer or thermostat aims to excite donors and raise their contributions to our charity. Most likely, every organization is already familiar with fundraising thermometers. These valuable materials are a standard in the society of nonprofit fundraising professionals. Fundraising thermometers, often known as fundraising target trackers or funding progression bars, display the total amount raised to date.


How to Create a Fundraising Thermometer in Excel ((With Easy Steps))

Establishing a fundraising thermometer in Excel might be challenging if the correct procedures are not followed. This post will lead you through the four steps required to make an Excel thermostat for goal tracking. We will begin by constructing a dataset for this experiment. We will eventually plot the data as a 2D Column Chart. Then, we will build the thermometer using the chart data. Lastly, the Fundraising Thermometer will be tested. Follow these instructions attentively to understand the technique quickly.


Step 1: Set up the Data Model

The first and foremost step is to create a dataset for illustration purposes. In this article, we will consider the below dataset. The dataset we will work with has two columns titled Name and Donation. Throughout this step, we will make other necessary information like Target Fund, Collection, and Remaining Tally and columns titled Collection Percentage and Target Percentage for the goal-tracking thermostat.

  • First of all, choose the B and C columns.
  • Second, make a dataset through the B4:C9 range like the one below.

Set up Data Model

  • Third, create three pieces of information through rows 11 to 13 for Target Fund, Collection, and Remaining Tally.
  • After that, pick C11 and input 100.

Set up Data Model to Create Fundraising Thermometer

  • Presently, select the C12 cell, type the formula below, and hit Enter to see the outcome.

=SUM(C5:C9)

Set up Data Model to Create Fundraising Thermometer

  • Likewise, choose the C13 cell and input the formula as follows.
  • Later, hit the  Enter key to get the output.
=C11-C12

Set up Data Model to Create Fundraising Thermometer

  • At this point, build two more columns for the Collection and Target percentages.
  • Now, select cell B16, write the formula below, and hit  Enter to find the result.
=C12/100

Set up Data Model to Create Fundraising Thermometer

  • Later, pick C16, type the formula below and press  Enter .

=C11/100

Set up Data Model to Create Fundraising Thermometer


Step 2: Insert Clustered Chart

This step will make a 2D Clustered Chart from the Collection Percentage and Target Percentage columns. Please follow the below instructions to implement the chart.

  • First, select the B15:C16 range.
  • Secondly, go to the Insert tab and click the Column Chart icon.

Generate Chart Data

  • Subsequently, a bar will pop up.
  • Now, from the 2-D Column section, choose the 2D Clustered Column symbol.

Generate Chart Data to make Fundraising Thermometer

  • Consequently, a column chart will appear, and click the Plus icon.
  • Later, check only the Axes option.

Generate Chart Data to make Fundraising Thermometer


Step 3: Display Fundraising Thermometer

We will turn the chart data into a simple Thermostat in this context. To accomplish the work, please follow the instructions below.

  • To begin, click in the chart area and navigate to the Chart Design tab.
  • After that, select the Switch Row/Column icon.

  • Now, double-click on the Collection Percentage series from the chart.

Display Fundraising Thermometer in Excel

  • As a result, the Format Data Series pane will open on the right side.
  • Later, check the Secondary Axis from the Series Options to display the chart below.

Display Fundraising Thermometer in Excel

  • At this point, double-click on the Secondary Vertical Axis.
  • Due to this, the Format Axis pane will pop on the right.
  • Now, click the Axis Options and type 1.0 in the box labeled Maximum.
  • Then, hit Enter, and the chart will look like the below one.

Display Fundraising Thermometer in Excel

  • Presently, select the Secondary Axis again and press Backspace.
  • As a consequence, the Secondary Axis will disappear.
  • Latterly, double-click the Vertical Axis, and the Format Axis pane will open.
  • Then, click on the Axis Options icon and type 0 in the Maximum box.
  • Next, write 2 in the box labeled Major and hit Enter.

Display Fundraising Thermometer in Excel

  • At this point, click the Target Percentage Value.

  • Then, go to the Format tab and click the Shape Styles symbol.
  • Later, from the Shape Fill option, choose the White color.

Display Fundraising Thermometer in Excel

  • Later, click the Shape Outline option and choose Weight.

click the Shape Outline option

  • Afterward, select the 3pt option.

Display Fundraising Thermometer in Excel

  • Eventually, pick the Horizontal Axis and tap Backspace.

  • Presently, click on the Vertical Axis.

click the Shape Outline option

  • Later, navigate to the Home Choose the B icon from the Font group and make the Font size 14.

click the Shape Outline option

  • Now, pick the Collection Percentage series, click on the Plus symbol, and check the Data Labels.

click the Shape Outline option

  • After that, go to the Insert tab and choose the Shapes symbol.

  • Then, from the Basic Shapes, select the Left Brace.

  • Currently, draw the Left Brace right beside the thermometer.
  • Latterly, go to the Shape Format tab, and click on,

Shape Format → Shape Outline → Weight → 3pt

click the Shape Outline option

  • As a result, the thermometer will look like the below one.

click the Shape Outline option


Step 4: Test Fundraising Thermometer

Now, we will test the fundraising thermometer. We will increase their donation and track the thermostat for every name listed in the dataset.

  • First of all, select the C5:C9 range and press Delete.
  • Second, pick the C5 cell, type 20, and hit Enter.
  • Likewise, input 20 to all other cells and notice the changes in the thermometer.
  • Thus, we created a fundraising thermometer like the below one.

Test Fundraising Thermometer


Download Practice Workbook

Please click on the link below this paragraph if you want a free copy of the sample workbook discussed in the presentation.


Conclusion

You can make a fundraising thermometer in Excel by following our steps. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Lutfor Rahman Shimanto
Lutfor Rahman Shimanto

Lutfor Rahman Shimanto, BSc, Information Technology, Jahangirnagar University, Bangladesh, has been working with the ExcelDemy project for more than 1 year. He has written 50+ articles for ExcelDemy. Currently, he is working as an Excel & VBA Developer and also provides support and solutions in the ExcelDemy Forum. His work and learning interests are in developing various Excel applications. Outside of work, he enjoys Chess a lot. He is a founding Jahangirnagar University Chess Club member and an internationally rated chess player.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo