Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Thermometer Chart Part 2

5 November 2021

Welcome back to our Charts and Dashboards blog series.  This week, I finish creating a Thermometer chart.

 

The results have come in for last year's sales for three of my imaginary salespeople.

I would like to be able to see at a glance how well they are doing against their targets.  There are several ways I could do this, but I have chosen to create a Thermometer chart for each salesperson.

Last time, I added two new rows. 

I then started creating a chart for Mary. 

To make it look more authentic, I can add an oval from the ‘Insert Shape’ area on the Insert tab:

I add this to the bottom of my chart:

I can use the ‘Format Shape’ pane to set Line to ‘No line’.

Mary’s chart is done!  I move it underneath Mary’s data, and copy the chart for John.  I need to change John’s chart to point at his data, so I choose ‘Select Data’.

I can then choose the data for John:

Unfortunately, Excel has tried to help by making sure I can see the % Max series!  To undo this, I right-click on the bar and go back to the ‘Format Data Series’ pane:

I check I am in the right Data Series, and then reset the Fill and Border to ‘No fill’ and ‘Solid line’.

That’s much better!  Now I repeat the process for Newbie:

Now it’s easy to see how everyone is doing: Newbie needs to catch up!

 

That’s it for this week.  Come back next week for more Charts and Dashboards tips.

 

Newsletter