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

Line charts are best for tracking changes over short or long overtime. Compare how several things change over time relative to each other. When minor changes exist, line graphs are better than bar graphs. So If you hear that key phrase "over time," that’s your clue to consider using line charts for your data.

1. Line Chart: Single Axis

Line Chart: Single Axis in Google Data Studio
Line Chart: Single Axis in Google Data Studio
  • In this chart, we display the Daily Users and New Users Trend with Linear Trendline

Recommended: Yes, See The Chart Version That Suits Your Need

  • Line Chart — Single Axis: to trend over time.

  • Line Chart — Double-Axis: to trend over time but if one of the data set compared is significantly smaller than the rest. Best practice to put those metrics on the second's Axis. Else line may a straight line on the X-Axis.

  • Sparkline: by default, everything is unselected except the line representing the data. Most cases used just below a Scorecard later shown

2. Line Chart: Double Axis

Line Chart: Double Axis in Google Data Studio
Line Chart: Double Axis in Google Data Studio
  • In this chart, we display the daily Revenue and Revenue per User trend

Recommended: Yes, See The Chart Version That Suits Your Need

  • Line Chart — Single Axis: to trend over time.

  • Line Chart — Double-Axis: to trend over time but if one of the data set compared is significantly smaller than the rest. Best practice to put those metrics on the second's Axis. Else line may a straight line on the X-Axis.

  • Sparkline: by default, everything is unselected except the line representing the data. Most cases used just below a Scorecard later shown

3. Sparkline Chart

Sparkline Chart in Google Data Studio
Sparkline Chart in Google Data Studio
  • In this chart, we display the Daily Users and New Users Trend

Recommended: Yes, See The Chart Version That Suits Your Need

  • Line Chart — Single Axis: to trend over time.

  • Line Chart — Double-Axis: to trend over time but if one of the data set compared is significantly smaller than the rest. Best practice to put those metrics on the second's Axis. Else line may a straight line on the X-Axis.

  • Sparkline: by default, everything is unselected except the line representing the data. Most cases used just below a Scorecard later shown

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