Excel Thermometer Goal Chart Template

In order to create the thermometer chart we need to have data of actual value and target value adjacent to each other.

Excel thermometer goal chart template. And if you want to create this color changing thermometer chart you need some extra steps i hope you don t mind for that. Select the data and click insert column 100 stacked column. This will insert charts with two bars having actual and target sales. This is why it is very important to maintain a goal chart template that will keep you alert about the goals you have promised to achieve.

To create a thermometer chart execute the following steps. The bulb of the thermometer displays the percentage of the total donations compared to the target. Click design switch row column. Goal chart template 9 free sample example format download.

This would insert a cluster chart with 2 bars as shown below. Right click at the whole project series. A goal chart would be the most helpful here as it enables one to specify the goals assumed in every aspect of life like career health etc. In the charts group click on the insert column or bar chart icon.

Remove the chart tile and the horizontal axis. On the insert tab in the charts group click the column symbol. Adjacent cells should be empty. Excel thermometer charts can really add visual appeal to an existing dashboard or be used as a standalone graph.

Further customize the chart. Create thermometer goal chart 1. A few days back i found some people saying that it s better to use thermometer chart than using a speedometer gauge. Select the cells and then go the insert tab and under charts section select 2d clustered column chart.

Here you are at our website article 14546 7 thermometer template excelhq8768 xls published by excel templates format. Here are the steps to create a thermometer chart in excel. In the drop down click the 2d clustered column chart. Creating a basic thermometer chart in excel is simple.

Thermometer chart the chart provides a very simple visual of your fundraiser s progress towards the goal amount. Below are four that we ve created providing several options and showing the versatility of an excel thermometer chart. Select the data points. Select the legends in the chart press delete key to remove them.

Click the insert tab. I also added a green mark labeled on track that can be used to show whether the current total donation level is on track with. All charts are fully functional meaning the thermometer fills based on the data input.