How to Create and Customise Gauge Charts in Google Sheets

Executive dashboards, operational scorecards, and performance reviews frequently require at-a-glance status indicators. Gauge charts (also known as dial or speedometer charts) represent key metrics against predefined targets, illustrating whether a value falls within poor, acceptable, or optimal performance thresholds. While standard column or bar charts show magnitude, gauge charts immediately convey contextual status. Google Sheets provides native gauge chart visualisations with customisable ranges, needle pointers, and alert colour bands.

When to Use Gauge Charts in Spreadsheets

Gauge charts are ideally suited for tracking single-point key performance indicators (KPIs) against bounded benchmarks, including:

• Sales Quota Attainment: Visualising current sales revenue against quarterly baseline and stretch targets.
• Server Telemetry: Monitoring CPU utilisation, memory consumption, or disk capacity thresholds (e.g., green up to 70%, yellow up to 85%, red beyond 85%).
• Customer Satisfaction (CSAT): Displaying net promoter scores on a fixed scale.
• Budget Utilisation: Tracking departmental project spend against total allocated funds.

Structuring Data for a Gauge Chart in Google Sheets

Unlike multi-series scatter or line charts, gauge charts require a clean, two-column layout consisting of metric labels and numeric values:

Each row represents an independent gauge dial. You can chart a single KPI or place multiple metrics side by side within one chart object.

Step-by-Step: Creating a Gauge Chart

1. Highlight your table data (including the header row, e.g., A1:B2).
2. Navigate to the top menu bar and click Insert > Chart.
3. Google Sheets opens the Chart editor sidebar on the right.
4. Under the Setup tab, click the Chart type dropdown.
5. Scroll down to the Other section and select Gauge chart.
6. Your sheet will instantly display a circular dial displaying the current value with an indicator needle.

Customising Scale Min, Max, and Colour Ranges

To provide meaningful visual context, calibrate the dial minimum, maximum, and colour-coded warning zones:

1. In the Chart editor sidebar, switch to the Customise tab.
2. Expand the Gauge section.
3. Set the absolute scale bounds:
   • Min value: Enter the baseline (e.g., 0).
   • Max value: Enter the upper target ceiling (e.g., 100).
4. Configure contextual colour bands:
   • Red range: Set From: 0 To: 60 (alerts user to critical underperformance).
   • Yellow range: Set From: 60 To: 80 (indicates caution or approaching limits).
   • Green range: Set From: 80 To: 100 (signifies healthy target achievement).
5. Observe how the gauge perimeter fills with distinct colour segments, allowing stakeholders to evaluate performance instantly.

Formatting Dial Titles and Dashboard Placement

Complete the dashboard visual presentation:

1. In the Customise tab, expand Chart & axis titles.
2. Enter a descriptive title (e.g., Customer Satisfaction Score (Q4)).
3. Set font formatting, font colour, and centre alignment.
4. Under Chart style, set the background colour to transparent if overlaying onto a dark-themed corporate reporting dashboard.
5. Resize and position the chart tile alongside summary pivot tables and KPI metric cards.