Get The Completed Workbook

If you want to view your performance versus a target for some metric like sales then a thermometer style chart is a great way to do this.

 

Step-001-How-To-View-Actual-vs-Target-With-A-Thermometer-Style-Chart How To View Actual Versus Target With A Thermometer Style Chart

 

In this example we have a table with columns for the sales person, their target sales and the actual sales they had. We will create a 2D bar chart for this data.

  1. Place the Active Cell cursor somewhere in your data.
  2. Go to the Insert tab.
  3. From under the Charts section, press the Bar Chart icon.
  4. Select the 2D Bar Chart from the menu.

 

Step-002-How-To-View-Actual-vs-Target-With-A-Thermometer-Style-Chart How To View Actual Versus Target With A Thermometer Style Chart

 

 

Add your performance data to the secondary axis (in this case the sales data).

  1. Right click on one of the sales bar columns in the chart.
  2. Select Format Data Series from the drop down menu.
  3. In the Format Data Series window, select the Secondary Axis radio button.

 

Step-003-How-To-View-Actual-vs-Target-With-A-Thermometer-Style-Chart How To View Actual Versus Target With A Thermometer Style Chart

 

Delete the resulting secondary axis in the chart.

  1. Right click on the secondary axis.
  2. Select Delete from the menu.

 

Step-004-How-To-View-Actual-vs-Target-With-A-Thermometer-Style-Chart How To View Actual Versus Target With A Thermometer Style Chart

 

Format the Target data series.

  1. Right click on one of the Target bar columns in the chart.
  2. Select Format Data Series from the menu.
  3. Adjust the Gap Width value until the desired thermometer result. I’ve set it to 80%.

 

Step-005-How-To-View-Actual-vs-Target-With-A-Thermometer-Style-Chart How To View Actual Versus Target With A Thermometer Style Chart

 

The result is an easy to read performance versus target thermometer style chart.