What is a Gauge Chart : How to create a Gauge Chart in Excel

What is a Gauge Chart

Gauge chart also known as dial chart or speedometer chart. It uses a needle on a dial shape to show information as a reading on a dial. It is often used for a single data point and aims to track the progress of a KPI against its set target or against some other time period.

It’s biggest advantage lays in the fact that it is easy to interpret. It also uses different colors to represent different scales of the variable which is the part of KPI. Usually these scales are the maximum, the minimum or the medium. Gauge chart is suitable for executive dashboards where stakeholders want to see where KPI is against the pre … Continue Reading