Thermometer chart is a visualization of the actual value of well-defined measure, for example, project status as compared to a target value. This is a linear version of Gauge chart that you will learn in the next chapter.
You can track your progress against the target over a period of time with a simple rising Thermometer chart.
A Thermometer chart keeps track of a single task, for example, completion of work, representing the present day status as compared to the target. It displays the percentage of the project completed, taking target as 100%.
A Thermometer chart looks as shown below.
Thermometer chart can be used to track any actual value as compared to the goal value as percentage completed. It works with a single value and is an appealing chart that can be included in dashboards for a quick visual impact on % achieved, % performance against the target sales target, % profit, % work completion, % budget utilized, etc.
If you have multiple values to track the actual against the targets, you can use Bullet chart that you will learn in a later chapter.
Prepare the data in the following way −
Following are the steps to create a Thermometer chart −
Step 1 − Select the data.
Step 2 − Insert a Clustered Column chart.
As you can see, the right Column is Target.
Step 3 − Click on a Column in the chart.
Step 4 − Click the DESIGN tab on the Ribbon.
Step 5 − Click the Switch Row/ Column button.
Step 6 − Right click on the Target Column.
Step 7 − Select Format Data Series from the dropdown list.
Step 8 − Click on Secondary Axis under SERIES OPTIONS in the Format Data Series pane.
As you can see, the Primary Axis and the Secondary Axis have different ranges.
Step 9 − Right click on the Primary Axis. Select Format Axis from the dropdown list.
Step 10 − Type the following in Bounds under AXIS OPTIONS in the Format Axis pane −
Repeat the steps given above for the Secondary Axis to change the Bounds to 0 and 1.
Both the Primary Axis and Secondary Axis will be set to 0% - 100%.
As you can observe, the Target Column hides the Actual Column.
Step 11 − Right click on the visible Column, i.e. Target.
Step 12 − Select Format Data Series from the dropdown list.
In the Format Data Series pane, select the following −
Step 13 − In Chart Elements, deselect the following −
Step 14 − Right click on the Primary Vertical Axis.
Step 15 − Select Format Axis from the dropdown list.
Step 16 − Click TICK MARKS under the AXIS OPTIONS in the Format Axis pane.
Step 17 − Select the option Inside for Major type.
Step 18 − Right click on the Chart Area.
Step 19 − Select Format Plot Area from the dropdown list.
Step 20 − Click Fill & Line in the Format Plot Area pane. Select the following −
Step 21 − Resize the Chart Area to get the Thermometer shape for the chart.
You got your Thermometer chart, with the actual value as against target cost being shown.
Step 22 − you can make this Thermometer chart more appealing with some formatting.
Your aesthetic Thermometer chart is ready. This will look good on a dashboard or as a part of a presentation.
Advanced Excel Charts Related Interview Questions
|MS Access Interview Questions||VBA For Excel Interview Questions|
|Microsoft Word Interview Questions||Microsoft Visual C++ Interview Questions|
|Excel Data Analysis Interview Questions||Excel pivot tables Interview Questions|
|Excel Power View Interview Questions||Microsoft Office 365 Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.