Show Watch Video – Creating Thermometer Chart in Excel Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value. A few scenarios when where it can be used is when analyzing sales performance of regions or sales rep, or employee satisfaction ratings vs the target value. In this tutorial, I will show you the exact steps you need to follow to create a thermometer chart in Excel. Click here to download the example file and follow along. Creating Thermometer Chart in ExcelSuppose 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). Note that the Target percentage would always be 100%. Here are the steps to create a thermometer chart in Excel:
That’s it! Your Thermometer chart is ready to measure. Download Thermometer
Chart Example File Note: The thermometer chart is useful when you have one actual value and target value set. In case you have multiple such datasets, you either need to create multiple such thermometer charts, or need to use a different chart type (such as the Bullet chart or the Actual Vs. Target charts). You May Also Like the Following Excel Tutorials:
Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster9 thoughts on “How to Create a Thermometer Chart in Excel”
Comments are closed. How do I create a tracker in Excel?Follow these five steps to create and use a trackable to-do list in Excel:. Open Excel and create column headers based on your requirements. ... . Fill in the details for each task. ... . Add a filter. ... . Use the filter to sort and prioritize your tasks. ... . Continue using your task tracker. ... . Project task list template.. How do you make a trackable goal?Follow these steps to successfully keep track of your goals:. List each of your goals. ... . Create smaller tasks to help hit each goal. ... . Assign reasonable deadlines to your goals. ... . Review your progress regularly. ... . Establish a reward system for yourself. ... . Build a schedule to follow. ... . Forgive yourself when you fall off track.. How do you create a goal calendar?Add a goal. Open the Calendar app.. At the bottom, tap Create .. Tap Goal.. Choose a category, such as Exercise or Family & Friends. To create a custom goal, pick a category and then tap Custom.. Follow the directions to set up your goal.. Tap Done .. |