• Home
  • About Us
    • Why Us
    • Gallery
    • Testimonials
  • Courses

    About Courses

    • Actuarial Science
    • Computer and Data Analytics
    • CFA Program
    • Sales and Digital Marketing
    • Graphic Desgining
    • Finance & Management
    • Certified Credit Research Analyst
    • Chartered Alternative Investment Analyst
    • Financial Risk Management
    CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

    CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

    ₹ 23,000 ₹ 20,999
    Read More
  • Corporate Training
  • IT Solutions
  • Blog
  • FAQs
  • Clients
  • Contact
    Have any question?
    +91 9015696833 , 8076456526
    cc@wkvedu.com
    Investment Banking Courses, Data Science Using R, Actuarial Science ClassesInvestment Banking Courses, Data Science Using R, Actuarial Science Classes
    • Home
    • About Us
      • Why Us
      • Gallery
      • Testimonials
    • Courses

      About Courses

      • Actuarial Science
      • Computer and Data Analytics
      • CFA Program
      • Sales and Digital Marketing
      • Graphic Desgining
      • Finance & Management
      • Certified Credit Research Analyst
      • Chartered Alternative Investment Analyst
      • Financial Risk Management
      CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

      CM1 with MS Excel [Earlier CT1 & CT5] (Actuarial Science)

      ₹ 23,000 ₹ 20,999
      Read More
    • Corporate Training
    • IT Solutions
    • Blog
    • FAQs
    • Clients
    • Contact

      Blog

      • Home
      • Blog
      • Blog
      • Thermometer Chart – MS Excel Tips & Tricks

      Thermometer Chart – MS Excel Tips & Tricks

      • Posted by White Knight Ventures
      • Categories Blog, News
      • Date October 31, 2019
      • Comments 0 comment
      Thermometer

      In this tutorial we are going to learn how to make a Thermometer Chart. To make learning easy and fun we have given both video tutorial and step-by-step instructions in this article.

      Thermometer chart is a visualization of the actual value of well-defined measure, for example, task 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.

      What is a Thermometer Chart?

      A Thermometer chart keeps track of a single task, for example, completion of work, representing the current status as compared to the target. It displays the percentage of the task completed, taking target as 100%.

      A Thermometer chart looks as shown below.

      Advantages of Thermometer Charts

      Thermometer chart can be used to track any actual value as compared to the target 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 actuals against the targets, you can use Bullet Chart that you will learn in a different video.

      Preparation of Data

      Prepare the data in the following way :

      • Calculate the Actual as a percentage of the actual value as compared to the target value.
      • Target should always be 100%.
      • Place your data in a table as given below.

      Creating a Thermometer Chart

      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:

      • 0 for Minimum.
      • 1 for Maximum.

      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 :

      • No fill under the FILL option.
      • Solid line under the BORDER option.
      • Blue under the Color option.

      Step 13 In Chart Elements, deselect the following :

      • Axis -> Primary Horizontal.
      • Axis -> Secondary Vertical.
      • Gridlines.
      • Chart Title.

      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 :

      • No fill under the FILL option.
      • No line under the BORDER option.

       

      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 Value being shown.

      Step 22 You can make this Thermometer chart more appealing with some formatting.

      • Insert a Rectangle shape superimposing the blue rectangular part in the chart.
      • In the Format Shape options, select the following:
        • Gradient fill for FILL.
        • Linear for Type.
        • 1800 for Angle.
      • Set the Gradient stops at 0%, 50% and 100%.
      • For the Gradient stops at 0% and 100%, choose the color black.
      • For the Gradient stop at 50%, choose the color white.
      • Insert an oval shape at the bottom.
      • Format the oval shape with the same options as of rectangle.
      • The result will be as shown below:

      Your aesthetic Thermometer chart is ready. This will look good on a dashboard or as a part of a presentation.

       

      Hope this was helpful and happy learning.

      To checkout more stuff on MS Excel visit https://www.wkvedu.com/blog/

      To learn more visit www.wkvedu.com

      Tag:Excel, MS Excel

      • Share:
      Admin bar avatar
      White Knight Ventures

        Previous post

        Speedometer Chart - MS Excel Tips & Tricks
        October 31, 2019

        Next post

        Bullet Chart - MS Excel Tips & Tricks
        November 3, 2019

        You may also like

        Make purchases based on design (1)
        Band Chart – MS Excel Tips & Tricks
        10 January, 2020
        Make purchases based on design (7)
        Waffle Chart – MS Excel Tips & Tricks
        31 December, 2019
        Make purchases based on design (3)
        Gantt Chart – MS Excel Tips and Tricks
        10 December, 2019

        Leave A Reply Cancel reply

        Your email address will not be published. Required fields are marked *

        Search

        Categories

        • Blog
        • News
        • Uncategorized

        [eStore_multi_currency_widget code=” INR,USD “]

        © 2017 - White Knight Ventures

        • Actuarial Science
        • Computer and Data Analytics
        • CFA Program
        • Sales and Digital Marketing
        • Graphic Desgining
        • Finance & Management
        • Certified Credit Research Analyst
        • Chartered Alternative Investment Analyst
        • Financial Risk Management

        Login with your site account

        Lost your password?

        Not a member yet? Register now

        Register a new account

        Are you a member? Login now