Search this site
Embedded Files
SheetsFormulas.com
  • Home
  • Excel/Sheets Formulas
    • calculate running total in Excel and Google Sheets
    • capitalize every letter in Excel and Google Sheets
    • capitalize only first letter in Excel and Google Sheets
    • change negative number to zero in Excel and Google Sheets
    • change negative to positive numbers in Excel and Google Sheets
    • change positive numbers to negative in Excel and Google Sheets
    • combine date and time in Excel and Google Sheets
    • combine multiple columns into one single column in Excel and Google Sheets
    • combine two or more cell in Excel and Google Sheets
    • combine two or more cell with line break in Excel and Google Sheets
    • combine two or more cells and transpose in Excel and Google Sheets
    • convert 1-12 to month name in Excel and Google Sheets
    • convert acres to hectares in Excel and Google Sheets
    • convert alphabet letter to number in Excel and Google Sheets
    • convert date to month and year in Excel and Google Sheets
    • convert date to text in Excel and Google Sheets
    • convert decimal number to binary in Excel and Google Sheets
    • convert euro to USD in Google Sheets
    • convert hectares to acres in Excel and Google Sheets
    • convert kilograms to pounds in Excel and Google Sheets
    • convert kilograms to stones in Excel and Google Sheets
    • convert letter to number in Excel and Google Sheets
    • convert month name to number in Excel and Google Sheets
    • convert number to alphabet letter in Excel and Google Sheets
    • convert number to roman number in Excel and Google Sheets
    • convert a number with two decimals in Excel and Google Sheets
    • convert numbers of days to year/month/day in Excel and Google Sheets
    • convert pounds to kilograms in Excel and Google Sheets
    • convert roman number to number in Excel and Google Sheets
    • convert seconds to time format in Excel and Google Sheets
    • convert stones to kilograms in Excel and Google Sheets
    • convert number stored as a text to date in Excel and Google Sheets
    • convert time to text in Excel and Google Sheets
    • convert USD to EURO in Google Sheets
    • convert weekday string to number in Excel and Google Sheets
    • count blank cell in Excel and Google Sheets
    • count cell between two values in Excel and Google Sheets
    • count cells greater than in Excel and Google Sheets
    • count cells greater than and equal to in Excel and Google Sheets
    • count cells in the column that have the same first five characters in Excel
    • count cells less than in Excel and Google Sheets
    • count cells less than and equal to in Excel and Google Sheets
    • count cells not equal to in Excel and Google Sheets
    • count cells over 10 characters in Excel and Google Sheets
    • count cells that are not blank in Excel and Google Sheets
    • count cells that begin with a specific text in Excel and Google Sheets
    • count cells that contain a specific text and ignore blank in Excel/Sheets
    • count cells that contain errors in Excel and Google Sheets
    • count cells that contain numbers and ignore blank in Excel and Google Sheet
    • count cells that do not contain numbers and ignore blank in Excel/Sheets
    • count if cells contain a specific text in Excel and Google Sheets
    • count if cells start with specific text in Excel and Google Sheets
    • count if cells end with a specific text in Excel and Google Sheets
    • count number of days between dates in Excel and Google Sheets
    • count number of words in a cell in Excel and Google Sheets
    • count the number of cells that have more than 5 character words in a column
    • count the number of occurrences of a text string in a range in Excel/Sheets
    • count words in a range of cells or columns in Excel and Google Sheets
    • COUNTIF based on multiple criteria in Excel and Google Sheets
    • dynamic current date and time in Excel and Google Sheets
    • dynamic current time in Excel and Google Sheets
    • dynamic today and yesterday date in Excel and Google Sheets
    • extract domain URL from a link in Excel and Google Sheets
    • extract left before first space in Excel and Google Sheets
    • extract the nth word in a text string in Excel and Google Sheets
    • extract right after first space in Excel and Google Sheets
    • extract URL domain root in Excel and Google Sheets
    • flip the first and last name in Excel and Google Sheets
    • get sheet name in Google Sheets
    • get text between colons in Google Sheets
    • get text between comma in Google Sheets
    • get the last non-empty cell in a column in Excel and Google Sheets
    • get the first non-empty cell in a column in Excel and Google Sheets
    • move the first word to end in Excel and Google Sheets
    • remove the negative sign from numbers in Excel and Google Sheets
    • reverse the text strings within cells in Excel and Google Sheets
    • split words by uppercase in Excel and Google Sheets
    • sum by month in Excel and Google Sheets
    • SUMIF cells if contains part of a text string in Excel and Google Sheets
    • sum total sales based on quantity & price in Excel and Google Sheets
    • transpose column to row in Excel and Google Sheets
    • transpose row to column in Excel and Google Sheets
    • transpose row to column and ignore blank in Excel and Google Sheets
    • Extract text between characters (parentheses) in Excel and Google Sheets
    • combine data from multiple google sheets and get tab name
    • TEXT function example in Excel and Google Sheets
    • IF formula and example in Excel and Google Sheets
    • SUMIF formula and example in Excel and Google Sheets
    • SUMIFS formula and example in Excel and Google Sheets
    • COUNTIF formula and example in Excel and Google Sheets
    • CONVERT function example in Excel and Google Sheets
    • Wild cards and regular expressions in Excel and Google Sheets
    • calculate percentage changes for containing negative numbers and zero
    • convert pounds to grams in Excel and Google Sheets
  • Google Data Studio
    • Charts Guide
      • Scorecard in Google Data Studio
      • Pie Chart in Google Data Studio
      • Bullet Chart in Google Data Studio
      • Gauge Chart in Google Data Studio
      • Line Chart in Google Data Studio
      • Column Charts in Google Data Studio
      • Combo Chart in Google Data Studio
      • Table Chart in Google Data Studio
      • Pivot Table in Google Data Studio
      • Area Chart in Google Data Studio
      • Scatter Chart in Google Data Studio
      • Bubble Chart in Google Data Studio
      • Maps in Google Data Studio
      • Treemaps in Google Data Studio
      • Bullet Chart vs Gauge Chart in Google Data Studio
    • Configuration Guide
      • Background and Border in Google Data Studio
      • Missing Data in Google Data Studio
      • Conditional Formatting in Google Data Studio
      • Chart Header in Google Data Studio
      • Legends in Google Data Studio
      • Reference Lines in Google Data Studio
      • Report Settings
      • Share Report
      • Manual Publishing
      • Version History
      • Embed a report
      • Get a link to your report
      • Schedule Email Delivery
      • Download as a PDF
      • Interface, Menu and Features
      • Most Used Terms
      • Keyboard Shortcuts
      • Theme and Layout
      • 10 Reasons You Should Be Using Google Data Studio
      • FAQs
      • Data Blending in Google Data Studio
    • Menu Explained
      • File Menu
      • Editing Menu
      • View Menu
      • Insert Menu
      • Page Menu
      • Arrange Menu
      • Resource Menu
    • Data Studio Book
    • GA4 Metrics and Dimensions Definition
SheetsFormulas.com
  • Home
  • Excel/Sheets Formulas
    • calculate running total in Excel and Google Sheets
    • capitalize every letter in Excel and Google Sheets
    • capitalize only first letter in Excel and Google Sheets
    • change negative number to zero in Excel and Google Sheets
    • change negative to positive numbers in Excel and Google Sheets
    • change positive numbers to negative in Excel and Google Sheets
    • combine date and time in Excel and Google Sheets
    • combine multiple columns into one single column in Excel and Google Sheets
    • combine two or more cell in Excel and Google Sheets
    • combine two or more cell with line break in Excel and Google Sheets
    • combine two or more cells and transpose in Excel and Google Sheets
    • convert 1-12 to month name in Excel and Google Sheets
    • convert acres to hectares in Excel and Google Sheets
    • convert alphabet letter to number in Excel and Google Sheets
    • convert date to month and year in Excel and Google Sheets
    • convert date to text in Excel and Google Sheets
    • convert decimal number to binary in Excel and Google Sheets
    • convert euro to USD in Google Sheets
    • convert hectares to acres in Excel and Google Sheets
    • convert kilograms to pounds in Excel and Google Sheets
    • convert kilograms to stones in Excel and Google Sheets
    • convert letter to number in Excel and Google Sheets
    • convert month name to number in Excel and Google Sheets
    • convert number to alphabet letter in Excel and Google Sheets
    • convert number to roman number in Excel and Google Sheets
    • convert a number with two decimals in Excel and Google Sheets
    • convert numbers of days to year/month/day in Excel and Google Sheets
    • convert pounds to kilograms in Excel and Google Sheets
    • convert roman number to number in Excel and Google Sheets
    • convert seconds to time format in Excel and Google Sheets
    • convert stones to kilograms in Excel and Google Sheets
    • convert number stored as a text to date in Excel and Google Sheets
    • convert time to text in Excel and Google Sheets
    • convert USD to EURO in Google Sheets
    • convert weekday string to number in Excel and Google Sheets
    • count blank cell in Excel and Google Sheets
    • count cell between two values in Excel and Google Sheets
    • count cells greater than in Excel and Google Sheets
    • count cells greater than and equal to in Excel and Google Sheets
    • count cells in the column that have the same first five characters in Excel
    • count cells less than in Excel and Google Sheets
    • count cells less than and equal to in Excel and Google Sheets
    • count cells not equal to in Excel and Google Sheets
    • count cells over 10 characters in Excel and Google Sheets
    • count cells that are not blank in Excel and Google Sheets
    • count cells that begin with a specific text in Excel and Google Sheets
    • count cells that contain a specific text and ignore blank in Excel/Sheets
    • count cells that contain errors in Excel and Google Sheets
    • count cells that contain numbers and ignore blank in Excel and Google Sheet
    • count cells that do not contain numbers and ignore blank in Excel/Sheets
    • count if cells contain a specific text in Excel and Google Sheets
    • count if cells start with specific text in Excel and Google Sheets
    • count if cells end with a specific text in Excel and Google Sheets
    • count number of days between dates in Excel and Google Sheets
    • count number of words in a cell in Excel and Google Sheets
    • count the number of cells that have more than 5 character words in a column
    • count the number of occurrences of a text string in a range in Excel/Sheets
    • count words in a range of cells or columns in Excel and Google Sheets
    • COUNTIF based on multiple criteria in Excel and Google Sheets
    • dynamic current date and time in Excel and Google Sheets
    • dynamic current time in Excel and Google Sheets
    • dynamic today and yesterday date in Excel and Google Sheets
    • extract domain URL from a link in Excel and Google Sheets
    • extract left before first space in Excel and Google Sheets
    • extract the nth word in a text string in Excel and Google Sheets
    • extract right after first space in Excel and Google Sheets
    • extract URL domain root in Excel and Google Sheets
    • flip the first and last name in Excel and Google Sheets
    • get sheet name in Google Sheets
    • get text between colons in Google Sheets
    • get text between comma in Google Sheets
    • get the last non-empty cell in a column in Excel and Google Sheets
    • get the first non-empty cell in a column in Excel and Google Sheets
    • move the first word to end in Excel and Google Sheets
    • remove the negative sign from numbers in Excel and Google Sheets
    • reverse the text strings within cells in Excel and Google Sheets
    • split words by uppercase in Excel and Google Sheets
    • sum by month in Excel and Google Sheets
    • SUMIF cells if contains part of a text string in Excel and Google Sheets
    • sum total sales based on quantity & price in Excel and Google Sheets
    • transpose column to row in Excel and Google Sheets
    • transpose row to column in Excel and Google Sheets
    • transpose row to column and ignore blank in Excel and Google Sheets
    • Extract text between characters (parentheses) in Excel and Google Sheets
    • combine data from multiple google sheets and get tab name
    • TEXT function example in Excel and Google Sheets
    • IF formula and example in Excel and Google Sheets
    • SUMIF formula and example in Excel and Google Sheets
    • SUMIFS formula and example in Excel and Google Sheets
    • COUNTIF formula and example in Excel and Google Sheets
    • CONVERT function example in Excel and Google Sheets
    • Wild cards and regular expressions in Excel and Google Sheets
    • calculate percentage changes for containing negative numbers and zero
    • convert pounds to grams in Excel and Google Sheets
  • Google Data Studio
    • Charts Guide
      • Scorecard in Google Data Studio
      • Pie Chart in Google Data Studio
      • Bullet Chart in Google Data Studio
      • Gauge Chart in Google Data Studio
      • Line Chart in Google Data Studio
      • Column Charts in Google Data Studio
      • Combo Chart in Google Data Studio
      • Table Chart in Google Data Studio
      • Pivot Table in Google Data Studio
      • Area Chart in Google Data Studio
      • Scatter Chart in Google Data Studio
      • Bubble Chart in Google Data Studio
      • Maps in Google Data Studio
      • Treemaps in Google Data Studio
      • Bullet Chart vs Gauge Chart in Google Data Studio
    • Configuration Guide
      • Background and Border in Google Data Studio
      • Missing Data in Google Data Studio
      • Conditional Formatting in Google Data Studio
      • Chart Header in Google Data Studio
      • Legends in Google Data Studio
      • Reference Lines in Google Data Studio
      • Report Settings
      • Share Report
      • Manual Publishing
      • Version History
      • Embed a report
      • Get a link to your report
      • Schedule Email Delivery
      • Download as a PDF
      • Interface, Menu and Features
      • Most Used Terms
      • Keyboard Shortcuts
      • Theme and Layout
      • 10 Reasons You Should Be Using Google Data Studio
      • FAQs
      • Data Blending in Google Data Studio
    • Menu Explained
      • File Menu
      • Editing Menu
      • View Menu
      • Insert Menu
      • Page Menu
      • Arrange Menu
      • Resource Menu
    • Data Studio Book
    • GA4 Metrics and Dimensions Definition
  • More
    • Home
    • Excel/Sheets Formulas
      • calculate running total in Excel and Google Sheets
      • capitalize every letter in Excel and Google Sheets
      • capitalize only first letter in Excel and Google Sheets
      • change negative number to zero in Excel and Google Sheets
      • change negative to positive numbers in Excel and Google Sheets
      • change positive numbers to negative in Excel and Google Sheets
      • combine date and time in Excel and Google Sheets
      • combine multiple columns into one single column in Excel and Google Sheets
      • combine two or more cell in Excel and Google Sheets
      • combine two or more cell with line break in Excel and Google Sheets
      • combine two or more cells and transpose in Excel and Google Sheets
      • convert 1-12 to month name in Excel and Google Sheets
      • convert acres to hectares in Excel and Google Sheets
      • convert alphabet letter to number in Excel and Google Sheets
      • convert date to month and year in Excel and Google Sheets
      • convert date to text in Excel and Google Sheets
      • convert decimal number to binary in Excel and Google Sheets
      • convert euro to USD in Google Sheets
      • convert hectares to acres in Excel and Google Sheets
      • convert kilograms to pounds in Excel and Google Sheets
      • convert kilograms to stones in Excel and Google Sheets
      • convert letter to number in Excel and Google Sheets
      • convert month name to number in Excel and Google Sheets
      • convert number to alphabet letter in Excel and Google Sheets
      • convert number to roman number in Excel and Google Sheets
      • convert a number with two decimals in Excel and Google Sheets
      • convert numbers of days to year/month/day in Excel and Google Sheets
      • convert pounds to kilograms in Excel and Google Sheets
      • convert roman number to number in Excel and Google Sheets
      • convert seconds to time format in Excel and Google Sheets
      • convert stones to kilograms in Excel and Google Sheets
      • convert number stored as a text to date in Excel and Google Sheets
      • convert time to text in Excel and Google Sheets
      • convert USD to EURO in Google Sheets
      • convert weekday string to number in Excel and Google Sheets
      • count blank cell in Excel and Google Sheets
      • count cell between two values in Excel and Google Sheets
      • count cells greater than in Excel and Google Sheets
      • count cells greater than and equal to in Excel and Google Sheets
      • count cells in the column that have the same first five characters in Excel
      • count cells less than in Excel and Google Sheets
      • count cells less than and equal to in Excel and Google Sheets
      • count cells not equal to in Excel and Google Sheets
      • count cells over 10 characters in Excel and Google Sheets
      • count cells that are not blank in Excel and Google Sheets
      • count cells that begin with a specific text in Excel and Google Sheets
      • count cells that contain a specific text and ignore blank in Excel/Sheets
      • count cells that contain errors in Excel and Google Sheets
      • count cells that contain numbers and ignore blank in Excel and Google Sheet
      • count cells that do not contain numbers and ignore blank in Excel/Sheets
      • count if cells contain a specific text in Excel and Google Sheets
      • count if cells start with specific text in Excel and Google Sheets
      • count if cells end with a specific text in Excel and Google Sheets
      • count number of days between dates in Excel and Google Sheets
      • count number of words in a cell in Excel and Google Sheets
      • count the number of cells that have more than 5 character words in a column
      • count the number of occurrences of a text string in a range in Excel/Sheets
      • count words in a range of cells or columns in Excel and Google Sheets
      • COUNTIF based on multiple criteria in Excel and Google Sheets
      • dynamic current date and time in Excel and Google Sheets
      • dynamic current time in Excel and Google Sheets
      • dynamic today and yesterday date in Excel and Google Sheets
      • extract domain URL from a link in Excel and Google Sheets
      • extract left before first space in Excel and Google Sheets
      • extract the nth word in a text string in Excel and Google Sheets
      • extract right after first space in Excel and Google Sheets
      • extract URL domain root in Excel and Google Sheets
      • flip the first and last name in Excel and Google Sheets
      • get sheet name in Google Sheets
      • get text between colons in Google Sheets
      • get text between comma in Google Sheets
      • get the last non-empty cell in a column in Excel and Google Sheets
      • get the first non-empty cell in a column in Excel and Google Sheets
      • move the first word to end in Excel and Google Sheets
      • remove the negative sign from numbers in Excel and Google Sheets
      • reverse the text strings within cells in Excel and Google Sheets
      • split words by uppercase in Excel and Google Sheets
      • sum by month in Excel and Google Sheets
      • SUMIF cells if contains part of a text string in Excel and Google Sheets
      • sum total sales based on quantity & price in Excel and Google Sheets
      • transpose column to row in Excel and Google Sheets
      • transpose row to column in Excel and Google Sheets
      • transpose row to column and ignore blank in Excel and Google Sheets
      • Extract text between characters (parentheses) in Excel and Google Sheets
      • combine data from multiple google sheets and get tab name
      • TEXT function example in Excel and Google Sheets
      • IF formula and example in Excel and Google Sheets
      • SUMIF formula and example in Excel and Google Sheets
      • SUMIFS formula and example in Excel and Google Sheets
      • COUNTIF formula and example in Excel and Google Sheets
      • CONVERT function example in Excel and Google Sheets
      • Wild cards and regular expressions in Excel and Google Sheets
      • calculate percentage changes for containing negative numbers and zero
      • convert pounds to grams in Excel and Google Sheets
    • Google Data Studio
      • Charts Guide
        • Scorecard in Google Data Studio
        • Pie Chart in Google Data Studio
        • Bullet Chart in Google Data Studio
        • Gauge Chart in Google Data Studio
        • Line Chart in Google Data Studio
        • Column Charts in Google Data Studio
        • Combo Chart in Google Data Studio
        • Table Chart in Google Data Studio
        • Pivot Table in Google Data Studio
        • Area Chart in Google Data Studio
        • Scatter Chart in Google Data Studio
        • Bubble Chart in Google Data Studio
        • Maps in Google Data Studio
        • Treemaps in Google Data Studio
        • Bullet Chart vs Gauge Chart in Google Data Studio
      • Configuration Guide
        • Background and Border in Google Data Studio
        • Missing Data in Google Data Studio
        • Conditional Formatting in Google Data Studio
        • Chart Header in Google Data Studio
        • Legends in Google Data Studio
        • Reference Lines in Google Data Studio
        • Report Settings
        • Share Report
        • Manual Publishing
        • Version History
        • Embed a report
        • Get a link to your report
        • Schedule Email Delivery
        • Download as a PDF
        • Interface, Menu and Features
        • Most Used Terms
        • Keyboard Shortcuts
        • Theme and Layout
        • 10 Reasons You Should Be Using Google Data Studio
        • FAQs
        • Data Blending in Google Data Studio
      • Menu Explained
        • File Menu
        • Editing Menu
        • View Menu
        • Insert Menu
        • Page Menu
        • Arrange Menu
        • Resource Menu
      • Data Studio Book
      • GA4 Metrics and Dimensions Definition
Google Data Studio > Charts Guide > Gauge Chart

Gauge charts display a single metric performance and progress towards a certain goal or against a benchmark.

1. Default Gauge Chart

Default Gauge Chart in Google Data Studio
Default Gauge Chart in Google Data Studio
  • By default, a Gauge chart doesn't have Target and Range configurations.

  • Metrics numbers are displayed as a compact numbers.

  • Minimum and maximum axis values are automatically defined.

Recommended: No

  • By default, a Gauge Chart doesn't provide any meaningful information without a Target or Ranges.

2. Gauge Chart With Target Only

Default Gauge Chart in Google Data Studio
Gauge Chart in Google Data Studio
  • A Bullet chart alternative in Google Data Studio. A Gauge chart doesn't need to be this big - this example is only used to explain details.

  • A center blue bar represents the actual value of the Metric, in this example, 2021 YTD revenue. Metrics value is shown in the middle, looking like a Scorecard.

  • In this example, target revenue is set at 2 million, with the blue line representing how far the target has reached so far.

Recommended: Yes

  • Gauge Chart With Target Only: this is used to measure a metric performance and progress towards a certain goal or against a benchmark.

3. Gauge Chart With Ranges Only (Without Target)

Gauge Chart With Ranges Only (Without Target) in Google Data Studio
Gauge Chart With Ranges Only (Without Target) in Google Data Studio
  • A Bullet chart alternative in Google Data Studio. A Gauge chart doesn't need to be this big - this example is only used to explain details.

  • A center blue bar represents the actual value of the Metric, in this example, 2021 YTD revenue. Metrics value is shown in the middle, looking like a Scorecard.

  • In this example, a Gauge Chart is used to display the ranges for poor, average, good, very good, and excellent. You can also have three ranges like Bullet Chart, and a maximum of five ranges can be set in a Gauge Chart.

Recommended: Yes

  • Gauge Chart With Ranges Only (Without Target): With Ranges, It can be configured to display the ranges for poor, average, good, very good, and excellent. A maximum of 5 ranges are allowed.

4. Gauge Chart With Target and Comparison

Gauge Chart With Target and Comparison in Google Data Studio
Gauge Chart With Target and Comparison in Google Data Studio
  • A Bullet chart alternative in Google Data Studio. A Gauge chart doesn't need to be this big - this example is only used to explain details.

  • A center blue bar represents the actual value of the Metric, in this example, 2021 YTD revenue. Metrics value is shown in the middle, looking like a Scorecard.

  • In this example, target revenue is set at 2 million, with the blue line representing how far the target has reached so far. The left black line is showing the revenue of the last year during the same period.

Recommended: Yes

  • Gauge Chart With Target and Comparison: to measure a metric performance divided into five ranges, progress towards a certain goal or against a benchmark and compare to the previous period.

Enjoy reading the guide? I have explained every chart available in the new Data Studio Book here. Visual explanations for graphs configurations, style, format, and recommendations. So you can also see how the final result will look and why one design is better than others for the same chart.

Charts Guide:
  • Scorecards
  • Pie/Doughnut Chart
  • Bullet Charts
  • Gauge Charts
  • Line Charts/Time Series Charts
  • Column Charts
  • Combo Charts
  • Table
  • Pivot Tables
  • Area Charts
  • Scatter Charts
  • Bubble Chart
  • Geo Maps Charts
  • Treemap
  • Bullet Chart vs Gauge Chart

Configuration across chart:
  • Background and Border
  • Missing Data
  • Conditional Formatting
  • Chart Header
  • Legends
  • Reference Lines
  • Report Settings

Most Used Features:
  • Report Sharing
  • Manual Publishing
  • Version History
  • Embed a Report
  • Get a link to your report
  • Schedule Email Delivery
  • Download as PDF
  • Interface Menu & Features
  • Most Used Terms
  • Keyboard Shortcuts
  • Theme and Layout
Excel/Google Sheets FunctionsFormulas and Functions
Google Data StudioCharts GuideConfiguration GuideMenu ExplainedData Studio Book
Google Sites
Report abuse
Google Sites
Report abuse