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 > Combo Chart

Combo charts use both axes to show a comparison between different KPIs. They work in a similar way to Column charts except with the option to configure how to display individual metrics (Line and Pub/Bar). The right axis is often used If a data set is significantly smaller than the rest of the KPIs.

1. Combo Chart: Double Axis

Combo Chart: Double Axis in Google Data Studio
Combo Chart: Double Axis in Google Data Studio
  • In this chart, we display Users and Revenue per User by weekday. Data is aggregated by weekday for the selected time period.

  • Adding an average reference will provide additional information about what to look for during analysis. For example, in the above chart, we can analyze “Why is Thursday’s average Revenue 71% higher than the rest of the week?"

Recommended: Yes

  • Unless X-Axis is a date, keep the number of pubs/bars to a max of 15.

  • Always use a double Axis configuration if one of your data sets is significantly smaller than the rest of the KPIs. Display smaller value metrics on the right Axis.

2. Combo Chart: Single Axis

Combo Chart: Single Axis in Google Data Studio
Combo Chart: Single Axis in Google Data Studio
  • In this chart, we display Users and Revenue per User by weekday. Data is aggregated by weekday for the selected time period.

Recommended: Yes

  • Unless X-Axis is a date, keep the number of pubs/bars to a max of 15.

  • A Single Axis configuration works well if the metrics you are comparing have at least a 3-5% difference. In the next example, we will use a Single Axis configuration for the Stacked Combo chart to see how it compares

3. Stacked Combo Chart: Single Axis

Stacked Combo Chart: Single Axis in Google Data Studio
Stacked Combo Chart: Single Axis in Google Data Studio
  • In this chart, we are comparing Users, Returning Users and Revenue per User against the total. The Revenue per User line is a straight line on the bottom of X-Axis. This is why you should always use a double Axis configuration when one of the metrics you are comparing is significantly smaller than the rest of the metrics.

Recommended: No

  • A Single Axis configuration works well if the metrics you are comparing have a difference of at least 3-5%.

4. Stacked Combo Chart: Dual Axis

Stacked Combo Chart: Dual Axis in Google Data Studio
Stacked Combo Chart: Dual Axis in Google Data Studio
  • In this chart, we are comparing Users and New Users Revenue per User against the total. In the double Axis configuration, we can also see the trend for the smaller data series. This is why you should always use a dual Axis configuration if one of the metrics you are comparing is significantly smaller than the rest of the set.

Recommended: Yes

  • A Double Axis configuration works well If one of the metrics you are comparing is significantly smaller than the rest of the set.

  • Unless X-Axis is a date, keep the number of pubs/bars to a max of 15.

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