# 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.

• 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.

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

`=SUM(C5:C9)`

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

• 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`

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

`=C11/100`

### 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.

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

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

### 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.

• 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.

• 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.

• 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.

• 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.

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

• Afterward, select the 3ptÂ option.

• Eventually, pick the Horizontal Axis and tap Backspace.

• Presently, click on the Vertical Axis.

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

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

• 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

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

### 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.

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.

## 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, 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

Advanced Excel Exercises with Solutions PDF