How Do You Make A Thermometer Chart In Microsoft Excel?
While the basic function of Microsoft Excel is to create efficient spreadsheets, the application also allows users to make charts and graphs easily from the data in those spreadsheets. Excel offers over a dozen types of instant charts, with even more subtypes, making it simple to create pie charts, column graphs and more with a few clicks of the mouse. These can be further modified to create a custom chart such as one that resembles a mercury-filled thermometer. Open a blank worksheet in Excel. Enter headings for two columns of data, such as “Month” and “Total Clients” in cells A1 and B1. Enter the appropriate data into the column cells. The data should be building towards a goal. Enter the goal number at the bottom of the column, and then enter the actual number reached in the cell beneath the goal amount, which will be the number in the last cell. Skip a cell below the totals, and enter a formula to determine the percentage reached in the next cell . In the “Formula Bar,” use the for
