Gauge charts

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

Annual sales

Sales in 2015	$35,000
Sales in 2016	$72,000
Sales in 2017	$52,000
Sales in 2018	$36,000

Make a copy

Annual profit

2015 profit	25%
2016 profit	47%
2017 profit	58%
2018 profit	75%

Make a copy

Customize a gauge chart

1. On your computer, open a spreadsheet in Google Sheets.
2. Double-click the chart you want to change.
3. At the right, click Customize.
4. 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.

Related articles

• Types of charts & graphs in Google Sheets
• Add & edit a chart or graph
• Pie charts