this tutorial will demonstrate how to create a thermometer chart in all versions of excel: 2007, 2010, 2013, 2016, and 2019. any time you need to track progress towards a goal—be it funding, sales, revenue, or other relevant metrics—this chart provides a simple and effective way to visualize that data. for illustration purposes, imagine you launched an e-commerce store as a side hustle and want to build a thermometer chart to keep track of the store’s performance against your stated revenue goal. before we move on to building the chart, we need to break down each data point so that you can easily retrace the steps using your data. as the linchpin holding it all together, each of the elements in the second table have their purpose. conversely, if the result (b6) exceeds the goal (b7), the formula returns the goal value (b7). we need to measure the progress as a percentage of the goal for our ultra-fancy label.
simply divide the result (b6) by the goal (b7) and format the output as a percentage—click the “percent style” button (home tab > number group). right-click on the data marker representing the “target revenue” (e2—the bottom section of the chart) and select “format data series.” now we need to spruce it up a bit. after you have set up the label, push it to the upper end of the related data marker. right-click each element and select “delete.” as you are putting the final touches on your chart, slim down the thermometer tube. increase the percentage if you want to slim it down more. after that, click the edge of the red tube once more to select series 2 “total revenue formula” (e3), placed on the primary axis. then right-click on the circle, and in the menu that appears, change the shape outline and shape fill colors to red.
suppose you have the data as shown below for which you want to create a chart to show the actual value as well as where it stands as compared with the target value. in the above data, the achieved% is calculated using the total and target values (total/target). hi, thank you for this information. would really appreciate the help, thank you! thank you.i created a thermometer chart by reading your tutorial and in our office they are still using this daily for tracking teams score.thank you so much.
i was able to create the thermometer for tracking out team’s giving. i am attempting to modify this and changed the axis range to 7000. every month, for the next 36 months i will be adding approx. i want be able to enter a value (that i am adding monthly) in a cell and also on another cell to show a cumulative running total of how much i’ve added. now, the cumulative sum would be reflected in a3 and the thermometer chart would work. the data entry part is in a separate tab sheet where i have a table with the date, amt. in another cell, g2 i have an array formula =offset(data,rows(data)-1,2), which gives the cummulative total from the table.
download our free thermometer chart template for excel. download now. in this article. thermometer chart is perfect if you want to track achievement of a single target. in this post, i’ll show you how to create a thermometer chart in excel. this example teaches you how to create a thermometer chart in excel. a thermometer chart shows you how much of a goal has been achieved., thermometer chart template excel, thermometer chart template excel, google sheets thermometer chart, thermometer chart generator, free editable thermometer template.
need thermometer charts for your presentation or goal tracking? the spreadsheet shoppe has got you covered! various options available and info-graphics: stunning thermometer chart in excel. 15 thermometer chart in excel could be a good way to, thermometer goal chart generator, thermometer goal tracker template.
When you try to get related information on thermometer chart template, you may look for related areas. thermometer chart template excel, google sheets thermometer chart, thermometer chart generator, free editable thermometer template, thermometer goal chart generator, thermometer goal tracker template.