Table of Contents
To create a Gauge Chart in Google Sheets, follow these steps:
1. Open a new or existing Google Sheets document.
2. Select the data that you want to include in the chart.
3. Click on the “Insert” tab at the top of the page.
4. In the drop-down menu, select “Chart.”
5. In the “Chart” window, click on the “Chart type” drop-down menu and select “Gauge.”
6. Customize your chart by adjusting the data range, title, and other options in the “Customize” tab.
7. Once you are satisfied with your chart, click “Insert” to add it to your spreadsheet.
8. The gauge chart will appear in your spreadsheet, ready for further editing or analysis.
9. You can also use the “Chart Editor” toolbar at the top of the page to make any additional changes or customizations to your chart.
10. Save your spreadsheet to ensure that your gauge chart is saved and can be accessed in the future.
Congratulations, you have successfully created a Gauge Chart in Google Sheets!
Create a Gauge Chart in Google Sheets (Step-by-Step)
The following step-by-step tutorial explains how to create the following gauge charts in Google Sheets:
Step 1: Enter the Data
First, let’s enter the following data for three metrics for some football team:
Step 2: Create the Gauge Chart
To create a gauge chart for the Offense metric, simply highlight the cell range A2:B2 and then click the Insert tab along the top ribbon and then click Chart:
In the Chart editor panel that appears on the right side of the screen, click the dropdown menu for Chart type and click on the option titled Gauge chart:
The following gauge chart will automatically be created:
Step 3: Modify the Gauge Chart
To modify the colors of the gauge chart, click the Customize tab within the Chart editor, then click the dropdown arrow next to Gauge and then specify the colors to use for various maximum and minimum values on the gauge chart:
The colors on the gauge chart will automatically be updated:
Step 4: Create Multiple Gauge Charts (Optional)
To create multiple gauge charts, simply change the Data range in the Chart editor.
For example, we can change the Data range to A2:B4 to create one gauge chart for each metric:
The following gauge charts will automatically be created:
Additional Resources
The following tutorials explain how to create other common visualizations in Google Sheets:
Cite this article
stats writer (2024). How do I create a Gauge Chart in Google Sheets step-by-step?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-create-a-gauge-chart-in-google-sheets-step-by-step/
stats writer. "How do I create a Gauge Chart in Google Sheets step-by-step?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-create-a-gauge-chart-in-google-sheets-step-by-step/.
stats writer. "How do I create a Gauge Chart in Google Sheets step-by-step?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-create-a-gauge-chart-in-google-sheets-step-by-step/.
stats writer (2024) 'How do I create a Gauge Chart in Google Sheets step-by-step?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-create-a-gauge-chart-in-google-sheets-step-by-step/.
[1] stats writer, "How do I create a Gauge Chart in Google Sheets step-by-step?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I create a Gauge Chart in Google Sheets step-by-step?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.