Then, select the information data and incorporate the headers from the information.We must first choose the data with a single value, as shown below:.How to Create a Gauge Chart in Excel? (with Step by Step Examples) This chart can be used to show employee’s performance, quarterly revenue target vs actual percentage, etc.… Using this chart we can create a beautiful dashboard as well. We can also check the temperature of a person, as a thermometer Thermometer Excel Thermometer Chart is the visualization effect used to show the “achieved percentage vs targeted percentage”.

A gauge chart is used in business to check how much revenue has been achieved versus the goal.Speed: We use the speedometer/Gauge chart to check the exact information to check the vehicle’s speed because it is not stable.Minimum Value: It shows the value of the minimum range of the gauge chart, e.g., the minimum value is 0 in a motorbike.Maximum value: It shows the value of the maximum range of the gauge chart, e.g., the maximum value is 180 in a motorbike.Example #2 – Create a Gauge Chart in Excel with Multiple ValuesĪttributes of Gauge Chart in Excel (Speedometer Chart).

Example #1 – Create a Gauge Chart in Excel with Single Value.

How to Create a Gauge Chart in Excel? (with Step by Step Examples).

Attributes of Gauge Chart in Excel (Speedometer Chart).

How to make a pie chart in excel 2007