Thermometer template excel

Have you ever imaged to create a thermometer goal chart in Excel? This tutorial will show you the detailed steps of creating a thermometer goal chart in Excel. Create thermometer chart in Excel with 10 steps. Create thermometer chart in Excel with 3 steps by using a powerful Charts tool recommend.

For example, you have below data needed to create a thermometer goal chart, and do as below steps. See screenshot:. Tip: You can also select Stacked Column as your need. Select the legends in the chart, press Delete key to remove them. Note : In Excel the legends are not added by default, so you can just skip this step. Right click at the Whole project series the red one , then select Format Data Series from context menu.

Now, we will have a chart like below one. Now, in the chart, we can see two vertical axis bars. One is for target, and another one is for achievement. Now, we need to delete the Target Axis Bar. For the same bar, make the border the same color as we can see above, i. Now you can see the border.

Make the chart width as short as possible. Remove excel gridlines from the chart. Remove the horizontal axis label as well. The filled part goes up as the achievement increase. In Excel, there is no default option to create a thermometer chart but you can create it by using simple steps.

To make a thermometer chart in Excel you need to follow the below steps and make sure to download this sample file to follow along:.

Your thermometer chart is ready to rock. Download this file from here to check my ready-to-use Excel thermometer chart. I have used different colors for different levels. Simple Donation Log - The log is set up to let you record individual donations by date and name. You do not have to record individual donations - that is just how the original template was set up. For example, you could use this to track Girl Scout Cookie sales where the "Name" could represent the location where you set up your booth.

You could also ignore the Name and Check field and just enter the total donations received on a particular date. Summary Stats - In addition to showing the total donations, the summary at the top of the donation lets you calculate the total donations for a particular date Today or a specific date range This Period.

Thermometer Chart - The chart provides a very simple visual of your fundraiser's progress towards the goal amount.