20 Thermometer Goal Chart Excel Template

Written By Anonymous Friday, January 30, 2015 Add Comment Edit

Thermometer chart free template download. Select the data and click insert column 100 stacked column.

How To Create Thermometer Goal Chart In Excel Step By Step

With the chart selected click the design tab.

Thermometer goal chart excel template. In the drop down click the 2d clustered column chart. Adjacent cells should be empty. In the charts group click on the insert column or bar chart icon.

Stack the data series on top of each other. Set up the helper table. You can also select stacked column as your need.

Create thermometer goal chart. Add the data label to the chart. This would insert a cluster chart with 2 bars as shown below.

To create a thermometer chart execute the following steps. Create a stacked column chart. On the insert tab in the charts group click the column symbol.

Select the data points. Here are the steps to create a thermometer chart in excel. Click design switch rowcolumn.

Click the insert tab. Change the data label value. A goal thermometer goal chart can be used to track fundraising donations debt as you pay.

Remove the chart tile and the horizontal axis. For example you have below data needed to create a thermometer goal chart and do as below steps. Excel tutorial to learn how to create a goal thermometer in excel.

Further customize the chart. Change the data marker colors.

Goal Tracker