How To Create Thermometer Chart In Excel Step By Step Guide
How to Create a Thermometer Chart in Excel? We are done with charting, and it looks like a beauty now. Create a dropdown list in Excel of employee names Create a table like the below one. Apply the VLOOKUP function for a dropdown cell to fetch the target and achieved values from the table as we select the names from the dropdown list. Now, arrive at “Achieved %” by dividing the “Achieved” numbers by “Target” numbers....