SAP - Advanced Excel Chart

Back to Course

Lesson Description

Lession - #486 Advanced Excel Charts – Thermometer Chart

Thermometer chart may be a visualisation of the particular value of well-defined measure, for instance, task standing as compared to a target value. this can be a linear version of Gauge chart that you simply can learn within the next chapter. You can track your progress against the target over a amount of your time with an easy rising thermometer chart.

What is a thermometer Chart?
A thermometer chart keeps track of one task, for example, completion of labor, representing this standing as compared to the target. It displays the proportion of the task completed, taking target as 100%.

Advantages of thermometer Charts

Thermometer chart are often accustomed track any actual worth as compared to the target value as share completed. It works with one worth and is an appealing chart which will be enclosed in dashboards for a fast visual impact each day achieved, performance against the target sales target, % profit, you work completion, budget used, etc.
If you've got multiple values to track the actuals against the targets, you'll use Bullet chart that you simply can learn during a later chapter.

Preparation of information

Prepare the info within the following way-

• Calculate the particular as a share of the particular worth as compared to the target value.

• Target must always be 100%.

• Place your data during a table as given below.

Creating a thermometer Chart
Following are the steps to make a thermometer chart -

Step 1: choose the data.
Step 2: Insert a Clustered Column chart.

As you'll see, the proper Column is Target.
Step 3: Click on a Column within the chart.
Step 4: Click the planning tab on the Ribbon.
Step 5: Click the Switch Row/ Column button.
Step 6: Right click on the Target Column.
Step 7: choose Format data Series from the dropdown list.
Step 8: Click on Secondary Axis beneath SERIES choices within the Format data Series pane.

As you'll see, the first Axis and therefore the Secondary Axis have totally different ranges.
Step 9: Right click on the first Axis. choose Format Axis from the dropdown list.
Step 10: type the following in Bounds beneath AXIS choices within the Format Axis pane –

• 0 for Minimum.

• 1 for optimum.

Repeat the steps given higher than for the Secondary Axis to alter the Bounds to zero and one.

Both the first Axis and Secondary Axis are going to be set to third - 100%. As you'll observe, the Target Column hides the particular Column.
Step 11: Right click on the visible Column, i.e. Target. Step 12: choose Format data Series from the dropdown list. within the Format data Series pane, choose the subsequent -

• No fill under the FILL option.

• Solid line beneath the BORDER option.

• Blue beneath the colour option.
Step 13: In Chart elements, deselect the subsequent -

• Axis -> Primary Horizontal.

• Axis -> Secondary Vertical.

• Gridlines.

• Chart Title.
Step 14: Right click on the primary Vertical Axis.
Step 15: choose Format Axis from the dropdown list.
Step 16: Click TICK MARKS under the AXIS choices within the Format Axis pane.
Step 17: choose the option within for Major type.
Step 18: Right click on the Chart area.
Step 19: choose Format Plot area from the dropdown list.
Step 20: Click Fill & Line within the Format Plot space pane. choose the following -

• No fill under the FILL option.

• No line under the BORDER option.
Step 21: size the Chart area to get the measuring instrument shape for the chart.
You got your thermometer chart, with the particular value as against Target value being shown.
Step 22: you'll make this thermometer chart more appealing with some formatting.

• Insert a parallelogram form superimposing the blue rectangular half within the chart.

• In the Format form options, choose the subsequent -
o Gradient fill for FILL.
o Linear for type.
o 1800 for Angle.

• Set the Gradient stops at third, 500th and 100%.

• For the Gradient stops at 0.33 and 100%, select the colour black.

• For the Gradient stop at 500th, select the color white.

• Insert AN oval form at very cheap.

• Format the oval form with a similar choices as of parallelogram.

• The result are going to be as shown below-

Your aesthetic thermometer chart is prepared. this can look sensible on a dashboard or as a part of a presentation.