Use a gauge chart to show numeric values or measurements within a range. For example, use a gauge chart to measure progress toward a goal.
Learn how to add & edit a chart.
How to format your data
- First column: Enter a label for the gauge.
- Second column: Enter numeric values for each gauge.
- Rows: Each row shows up in a separate gauge.
Examples
Customize a gauge chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Choose an option:
- Chart style: Change background color, font, or maximize gauge size.
- Gauge: Add and edit gauge ranges.
- Chart & axis titles: Edit or format title text.