Best 100+ Excel Hacks & Tips with Excel 2016. Take the course for only $10 !!

Arrow up
Arrow down
Menu

How to create a Thermometer Chart - Ideal for Measuring Performance

Hello this is Andreas and in this Article you’ll learn how to make awesome thermometer charts. Comparing values is one of the reasons why we make charts. A thermometer chart can help us to compare targets with actual values. So it’s an excellent chart which help us to measure performance or the percentage of a task...

Look at this worksheet. In the first column we have the days of a month and in the second column we have the views of the users that visited our website. Our target or our goal if you prefer is 1000 users and you can see it in cell B33. B34 cell contains the sum of users of the entire month. In cell B36 we have the percentage of total sales compared to goal value. So the formula is : B34 divided by B33.

To create a thermometer chart we will use a single cell (which holds the percentage value) as a data series. So we highlight B36. Notice the blank cell above cell B36. It is very important to isolate this cell because without the blank cell, Excel uses the entire data block for the chart, not just the single cell.Now go to Insert Tab and click on Clustered column chart.

The first step is to remove some elements of the chart like the horizontal axis and the title. The second step is to add a text box, linked to cell B36. So it will display the percentage. Type equal and click B36 cell. The next step is to double-click vertical axis and change minimum bound to 0 and maximum bound to 1. Now delete the axis.

We are almost ready. We have to do some formatting, like remove the fill and the border of our chart, apply a shape effect like this, add a border and an oval shape. Of course you can try any formatting you want.

Thank you very much and waiting for your questions.

Click here to download the Excel project File

Click here to download the Excel Sample File

 You can see the detailed video tutorial below or on YouTube


If you want to learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks, take our Udemy Course for only $25 !! (original price: $199 - 87% OFF!)

 


 

Last modified onSunday, 24 January 2016 16:08
Rate this item
(1 Vote)