The primary use of a thermometer chart is to track the progress and measure the goals of a project by percentages. Thermometer charts are single-celled charts that are typically used in spread sheets; they can also be used to compare different values.
In creating a thermometer chart in Excel, one column should hold the data, and another column should hold the chart itself. The first step, after entering the data, is to insert a table; the best graph option is a 2-D column graph. After insert the table, it will be necessary to format the axis options by right-clicking on the column of numbers. After clicking on "Format Axis," a window should open that displays the axis options; the maximum axis option should be "fixed" and "one."
The next step is to right-click on the bar in the graph and select "format data series" and lower the gap width percentage to zero. It will then be required to format the plot area by right-clicking on any space above the bar graph; opt for a solid line for the bar's border color, and then choose the appropriate color for the graph border. Upon completing these steps, the graph/chart should resemble a thermometer. In order to raise temperature/line of the graph, the previous steps will need to be repeated.