{"id":7693,"date":"2023-11-07T22:50:27","date_gmt":"2023-11-07T22:50:27","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=7693"},"modified":"2024-01-17T21:29:14","modified_gmt":"2024-01-17T21:29:14","slug":"how-to-create-a-thermometer-chart-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-a-thermometer-chart-in-excel\/","title":{"rendered":"How to Create a Thermometer Chart in Excel?"},"content":{"rendered":"<p>A thermometer chart in Excel to plot specific data based on actual and target values. It can be used in a variety of scenarios, such as showing a horse&#8217;s past performance in a horse race or the global temperature and its changes over decades.<\/p>\n<p><strong>This content covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#what-does-a-thermometer-chart-mean?\"><strong>What does a thermometer chart mean?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-make-an-excel-thermometer-chart?\"><strong>How to Make an Excel Thermometer Chart?<\/strong><\/a><\/li>\n<li><a href=\"#things-to-keep-in-mind-with-excel-thermometer-chart\"><strong>Things to keep in mind with Excel Thermometer Chart<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"what-does-a-thermometer-chart-mean?\">1. What does a thermometer chart mean?<\/strong><\/h2>\n<p>A thermometer chart is a type of visual representation used to exhibit data like to a thermometer. It is frequently used to describe moving forward toward a goal, purpose, or value. Graphs typically consist of vertical bars or columns with partially filled colors to represent the current status or level of performance.<\/p>\n<p>The main elements and meanings associated with the thermometer graph are:<\/p>\n<ul>\n<li><strong>Vertical Bar: <\/strong><\/li>\n<\/ul>\n<p>The main component of a thermometer chart is a vertical bar that resembles the shape of a thermometer. This bar can be segmented or divided into different sections, with one section representing each unit or measurement interval.<\/p>\n<ul>\n<li><strong>Color Fill: <\/strong><\/li>\n<\/ul>\n<p>The vertical bar is partially filled with color to indicate the current level or progress toward the goal. The amount of bars filled with color is proportional to the data represented. Color fills typically start at the bottom and increase as the value or progression increases.<\/p>\n<ul>\n<li><strong>Target or Goal: <\/strong><\/li>\n<\/ul>\n<p>A horizontal line, often referred to as a &#8220;target line&#8221; or &#8220;target line,&#8221; is typically inserted into a chart to represent a desired or target value. Targets are usually marked with labels or numbers.<\/p>\n<ul>\n<li><strong>Numbers: <\/strong><\/li>\n<\/ul>\n<p>Charts can contain numbers that indicate the current data point or data level. This value is often displayed at the top of the graph or near the thermometer. Thermometer charts are often used in fundraising campaigns, fundraisers, and financial reports to visually track progress toward fundraising or budget goals. As it progresses, the colored fill increases toward the finish line, making it quick and easy for people to understand how close a project or campaign is to its goal.<\/p>\n<h2><strong id=\"how-to-make-an-excel-thermometer-chart?\">2. How to Make an Excel Thermometer Chart?<\/strong><\/h2>\n<p>Take the data given below and you want to create a chart to show the actual value along with its position relative to the target value. The above % Achieved is calculated using the Target values. The target percentage is 100% for all time.<\/p>\n<p>Here is some data of Year and sales.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-7694\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-1.png\" alt=\"Create a Thermometer Chart\" width=\"235\" height=\"415\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-1.png 235w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-1-170x300.png 170w\" sizes=\"(max-width: 235px) 100vw, 235px\" \/><\/p>\n<p><strong>Step 1:<\/strong> Choose\u00a0 data points like the above picture.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-7695\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-2.png\" alt=\"Create a Thermometer Chart\" width=\"202\" height=\"106\" \/><\/p>\n<p><strong>Step 2:<\/strong> Click on the insert tab above as shown.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-7696\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-3.png\" alt=\"Create a Thermometer Chart\" width=\"372\" height=\"172\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-3.png 372w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-3-300x139.png 300w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Now, click\u00a0 the <strong>&#8220;Insert Column or Bar Chart&#8221; icon as marked.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7697\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-4.png\" alt=\"Create a Thermometer Chart\" width=\"544\" height=\"158\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-4.png 544w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-4-300x87.png 300w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/p>\n<p><strong>Step 4:<\/strong> Select the <strong>&#8220;2D&#8221; button In the drop-down list<\/strong>. Group column chart and it will insert a Cluster chart using 2 bars (as shown below).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7699\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-5.png\" alt=\"Create a Thermometer Chart\" width=\"574\" height=\"470\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-5.png 574w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-5-300x246.png 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/p>\n<p><strong>Step 5:<\/strong> After selecting the chart now\u00a0 click on Chart Design tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7700\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-6.png\" alt=\"Create a Thermometer Chart\" width=\"513\" height=\"527\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-6.png 513w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-6-292x300.png 292w\" sizes=\"(max-width: 513px) 100vw, 513px\" \/><\/p>\n<p><strong>Step 6:<\/strong> Tick on the <strong>Switch\u00a0 Row\/Column option<\/strong> and you will get the resulting chart as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7701\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-7.png\" alt=\"Create a Thermometer Chart\" width=\"481\" height=\"533\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-7.png 481w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-7-271x300.png 271w\" sizes=\"(max-width: 481px) 100vw, 481px\" \/><\/p>\n<p><strong>Step 7.<\/strong> Right-click the second column (Red column in this example) and select data series format as shown.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7702\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-8.png\" alt=\"Create a Thermometer Chart\" width=\"638\" height=\"381\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-8.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-8-300x179.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>Step 8:<\/strong> Here you can see Format the Data Series.<\/p>\n<p>In the format Data series task pane (or dialog box if you are using Excel 2010 or 2007), select Secondary Axis under Series Options. This will align the two bars together.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7703\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-9.png\" alt=\"Create a Thermometer Chart\" width=\"636\" height=\"390\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-9.png 636w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-9-300x184.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/p>\n<p><strong>Step 9:<\/strong> There are two vertical axes (left and right), with different values. Do Right-click on the left vertical axis and choose the format axis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7704\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-10.png\" alt=\"Create a Thermometer Chart\" width=\"598\" height=\"489\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-10.png 598w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-10-300x245.png 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<p><strong>Step 10:<\/strong> change the maximum limit value to 1 and the minimum limit value to 0. Note that even if the value is already 0 and 1 in the Format Axis task pane, However, you need to modification it manually for you (see Reset button on the right).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7705\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-11.png\" alt=\"Create a Thermometer Chart\" width=\"336\" height=\"248\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-11.png 336w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-11-300x221.png 300w\" sizes=\"(max-width: 336px) 100vw, 336px\" \/><\/p>\n<p><strong>Step 11:<\/strong> Delete the axis on the right and chart title.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7706\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-12.png\" alt=\"Create a Thermometer Chart\" width=\"636\" height=\"272\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-12.png 636w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-12-300x128.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/p>\n<p><strong>Step 12:<\/strong> After formatting axis now click on the right column visible in the chart, and select format data series as shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7707\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-13.png\" alt=\"Create a Thermometer Chart\" width=\"592\" height=\"423\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-13.png 592w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-13-300x214.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/p>\n<p><strong>Step 13:<\/strong> Select the chart border, right-click, and choose Format Chart Area. .<\/p>\n<p>In the task pane, make the following selection<\/p>\n<p>Fill:<\/p>\n<ul>\n<li>No fill<\/li>\n<\/ul>\n<p>Border:<\/p>\n<ul>\n<li>No line<\/li>\n<\/ul>\n<p>Following the above instruction in the below image:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7708\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-14.png\" alt=\"Create a Thermometer Chart\" width=\"309\" height=\"482\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-14.png 309w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-14-192x300.png 192w\" sizes=\"(max-width: 309px) 100vw, 309px\" \/><\/p>\n<p><strong>Step 14:<\/strong> After doing the format data series work. Now, Delete gridlines, right vertical axis, horizontal (category) axis, and legend.<\/p>\n<p>After deleting gridlines, right vertical axis, horizontal (category) axis, and legend the chart will be like the below image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7709\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-15.png\" alt=\"Create a Thermometer Chart \" width=\"590\" height=\"391\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-15.png 590w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-15-300x199.png 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/p>\n<p><strong>\u00a0Step 15:<\/strong> In the image here is Selecting the vertical axis on the left, right-clicking on it and selecting \u2018Format Axis\u2019.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7710\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-16.png\" alt=\"Create a Thermometer Chart\" width=\"607\" height=\"368\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-16.png 607w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-16-300x182.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/p>\n<p><strong>Step 16:<\/strong> Go to Format Axis task pane, then you will get Major\u00a0Tick Mark. Select major tick mark Type as Inside as shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7711\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-17.png\" alt=\"Create a Thermometer Chart\" width=\"340\" height=\"498\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-17.png 340w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-17-205x300.png 205w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/><\/p>\n<p><strong>Step 17:<\/strong> Go to chart outline, right-click and select Format Chart Area.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7712\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-18.png\" alt=\"Create a Thermometer Chart\" width=\"515\" height=\"506\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-18.png 515w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-18-300x295.png 300w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/p>\n<p><strong>Step 18:<\/strong> Go to the pane, choose selection.<\/p>\n<ul>\n<li>Fill: No Fill<\/li>\n<li>Border:\u00a0No Line<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7713\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-19.png\" alt=\"Create a Thermometer Chart\" width=\"315\" height=\"493\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-19.png 315w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-19-192x300.png 192w\" sizes=\"(max-width: 315px) 100vw, 315px\" \/><\/p>\n<p><strong>Step 19:<\/strong> Go to the Insert tab and insert a circle in the Shape drop-down list. Make it the same color as the thermometer chart and align it down.<\/p>\n<p>After following the above instructions you wil get a result like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7714\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-20.png\" alt=\"Create a Thermometer Chart\" width=\"551\" height=\"461\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-20.png 551w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Create-a-Thermometer-Chart-20-300x251.png 300w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/p>\n<h2><strong id=\"things-to-keep-in-mind-with-excel-thermometer-chart\">3. Things to keep in mind with Excel Thermometer Chart<\/strong><\/h2>\n<p>Creating an Excel thermometer chart can be a useful way to represent data visually and track progress toward goals. Here are some important points to keep in mind when working with Excel thermometer charts:<\/p>\n<ul>\n<li><strong>Data Structure: <\/strong><\/li>\n<\/ul>\n<p>Make sure your data is structured correctly. You typically need two data points:<\/p>\n<p>the current value or level and the target or target. You can create a simple two-column table for this data.<\/p>\n<p><strong>Select data: <\/strong><\/p>\n<p>Highlight the data you want to include in the chart. This data must include the current value and the target value.<\/p>\n<p><strong>Chart type: <\/strong><\/p>\n<p>Select the correct chart type. In Excel, you can use a stacked bar chart to create a thermometer chart. This involves using two tuples:<\/p>\n<p>one for\u00a0 &#8220;current&#8221; and one for &#8220;remainder&#8221; (which will be the target minus the current).<\/p>\n<p>Format:<\/p>\n<p>Be careful with formatting. You&#8217;ll want to format the graph to look like a thermometer. This may involve hiding the X and Y axis labels and formatting the data series to have a thermometer-like shape.<\/p>\n<ul>\n<li><strong>Axis labels: <\/strong><\/li>\n<\/ul>\n<p>Add any necessary labels, such as\u00a0 current value and\u00a0 target, near the chart.<\/p>\n<ul>\n<li><strong>Data labels: <\/strong><\/li>\n<\/ul>\n<p>Add data labels if needed to display\u00a0 actual values, especially if your chart does not include axis labels.<\/p>\n<ul>\n<li><strong>Target Line: <\/strong><\/li>\n<\/ul>\n<p>Includes a target line that represents the target value or target. Format this line to make it easily distinguishable from the rest of the chart.<\/p>\n<ul>\n<li><strong>Chart title: <\/strong><\/li>\n<\/ul>\n<p>Give your chart a clear, descriptive title so\u00a0 viewers understand what it represents.<\/p>\n<ul>\n<li><strong>Data validation: <\/strong><\/li>\n<\/ul>\n<p>Make sure your data is accurate and updated regularly, especially if your chart is intended to track progress over time.<\/p>\n<ul>\n<li><strong>Customization: <\/strong><\/li>\n<\/ul>\n<p>Excel allows for great customization. Experiment with different chart elements, styles, and layouts to make them more attractive and effective.<\/p>\n<ul>\n<li><strong>Explanation: <\/strong><\/li>\n<\/ul>\n<p>Depending on your audience, it may be helpful to provide an explanation or caption to ensure\u00a0 viewers understand the meaning of the image.<\/p>\n<ul>\n<li><strong>Accessibility: <\/strong><\/li>\n<\/ul>\n<p>Consider accessibility; ensure that the chart is comprehensible to all potential viewers, including those with visual impairments.<\/p>\n<ul>\n<li><strong>Documentation: <\/strong><\/li>\n<\/ul>\n<p>If the chart is part of a report or presentation, be sure to document what the chart represents, its source, and any assumptions or limitations.<\/p>\n<p>Excel thermometer charts are a great tool for visualizing progress and goals, but it&#8217;s important to make sure they are clear, accurate, and well-formatted for your specific needs and audience.<\/p>\n<h2><strong>Application of Thermometer Chart in Excel in Dashboard Reporting<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_8093\" aria-describedby=\"caption-attachment-8093\" style=\"width: 438px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8093\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Screenshot-2024-01-17-103109.png\" alt=\"Thermometer Chart in Excel\" width=\"438\" height=\"786\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Screenshot-2024-01-17-103109.png 438w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/11\/Screenshot-2024-01-17-103109-167x300.png 167w\" sizes=\"(max-width: 438px) 100vw, 438px\" \/><figcaption id=\"caption-attachment-8093\" class=\"wp-caption-text\"><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates\/employee-engagement-dashboard\">Employee Engagement Dashboard<\/a><\/figcaption><\/figure>\n<p>Here are some uses of thermometer charts in dashboard reporting:<\/p>\n<ol>\n<li><strong>Goal Progress Tracking<\/strong>:\n<ul>\n<li>Represents the progress towards a target or goal (e.g., sales target, fundraising goal), showing the amount achieved in comparison to the total goal.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Resource Utilization<\/strong>:\n<ul>\n<li>Displays the level of resource usage, such as budget spent, capacity used, or inventory levels, helping in resource management and planning.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Performance Measurement<\/strong>:\n<ul>\n<li>Visualizes performance metrics like employee productivity, machine efficiency, or customer satisfaction scores, allowing for quick assessment against predefined benchmarks.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Project Milestone Achievement<\/strong>:\n<ul>\n<li>Illustrates the completion status of different phases or milestones in a project, providing a clear picture of the project timeline and current status.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Temperature or Climate Data Representation<\/strong>:\n<ul>\n<li>Ideal for representing actual temperature readings or climate-related data against expected or historical ranges, useful in environmental or agricultural dashboards.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Survey or Poll Results Display<\/strong>:\n<ul>\n<li>Summarizes the results of surveys or polls, such as customer feedback or employee engagement levels, making the data accessible and straightforward for stakeholders.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>You may be interested:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>A thermometer chart in Excel to plot specific data based on actual and target values. It can be used in a variety of scenarios, such as showing a horse&#8217;s past performance in a horse race or the global temperature and its changes over decades. This content covers: What does a thermometer chart mean? How to &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-a-thermometer-chart-in-excel\/\"> <span class=\"screen-reader-text\">How to Create a Thermometer Chart in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[4],"tags":[857,856,858],"class_list":["post-7693","post","type-post","status-publish","format-standard","hentry","category-excel-charts","tag-thermo-meter-chart","tag-thermometer-chart","tag-thermometer-chart-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/7693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=7693"}],"version-history":[{"count":6,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/7693\/revisions"}],"predecessor-version":[{"id":8096,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/7693\/revisions\/8096"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=7693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=7693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=7693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}