How do you create a thermometer goal chart?

Here are the steps to create a thermometer chart in Excel:

1. Select the data points .
2. Click the Insert tab.
3. In the Charts group, click on the ‘Insert Column or Bar chart’ icon.
4. In the drop-down, click the ‘2D Clustered Column’ chart. …
5. With the chart selected, click the Design tab.
6. Click on Switch Row/Column option.

>> Click to read more <<

Keeping this in view, how do I create a goal bar chart in Excel?

The Target Line

1. Select the chart and go to Design –> Select Data.
2. In the Select Data Source dialog box, Click Add.
3. In the Edit Series box, Type Series Name as ‘Target Line’ and in Series Value select your Target Value cell.
4. This will insert a bar chart only for the first data point (January)

In this way, how do I create a goal thermometer in Excel?

How do you create a sales goal chart?

3 Related Question Answers Found

How do you create a thermometer chart in PowerPoint?

Creating A Thermometer Template In PowerPoint

1. Add a tall skinny rectangle shape with rounded corners. …
2. Add a small circle shape. …
3. Place the small circle at the bottom of the rectangle and merge the two shapes with the union command. …
4. Create a larger rectangle and place the thermometer shape inside it.

How do you make a temperature and time graph on Excel?

What is a thermometer chart?

Thermometer chart is a visualization of the actual value of well-defined measure, for example, task status as compared to a target value. This is a linear version of Gauge chart that you will learn in the next chapter.