How to make an Excel thermometer chartStep 1It’s always good to plan ahead. Before starting, determine what your chart is going to be used for— is it going to be part of a dashboard, will it stand on its own, or used as a graphic in a presentation? Taking just a few seconds ...
Now we can format that data series in the chart so that it looks like a thermometer that is filling up. If you can’t see the Current Sales Data Point, change your values in the worksheet so that it is visible. The first step is to format the Current Sales data point with all red ...
Step 1: Suppose we have the raised funding data in the table below. To make a thermometer chart, we need to calculate the total raised funding as of today, and the percentage over the Goal ($1,000 in this example); Step 2: Select the data range A8:B8, and click the "Insert" tab...
Visualizing a financial goal on a progress chart gives you something to look at that isn't just numbers, says Heidi Nash, who lives in the Bay Area. Nash, 50, startedDebt Free Chartsafter she and her husband conquered theirown debt issues. Filling in the chart motivates people to keep...