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 > Area Charts

An Area Chart is best used to show the distribution of categories as parts of a whole changing over an interval. As the area inside the chart is plotted to convey whole numbers, an Area Chart does not work for negative values.

1. Area Chart

Area Chart in Google Data Studio
Area Chart in Google Data Studio
  • In this chart, we display Users Type by weekday, and data are aggregated by weekday for the selected period.

  • Left Y-Axis plotted individually on each interval, date in this example for New and Returning Visitors

  • [Breakdown Dimension] — Area Chart must have a Breakdown Dimension, in this example, User Type

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

  • Area Chart: to show the distribution of categories as parts of a whole changing over an interval

  • Area Chart 100% Stacking: If you want to split the trend over time into % share at each interval.

  • Area Chart Show Stack: Same as Area Chart, except in this chart, the smallest series area is plotted on the top rather than the bottom.

2. 100% Stacked Area Chart

100% Stacked Area Chart in Google Data Studio
100% Stacked Area Chart in Google Data Studio
  • In this chart, we display Users Type by weekday, and data are aggregated by weekday for the selected period.

  • Left Y-Axis plotted individually on each interval, date in this example for New and Returning Visitors

  • [Breakdown Dimension] — Area Chart must have a Breakdown Dimension, in this example, User Type

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

  • Area Chart 100% Stacking: If you want to split the trend over time into % share at each interval.

  • Area Chart: to show the distribution of categories as parts of a whole changing over an interval

  • Area Chart Show Stack: Same as Area Chart, except in this chart, the smallest series area is plotted on the top rather than the bottom.

3. Area Chart: Show Stack

Area Chart: Show Stack in Google Data Studio
Area Chart: Show Stack in Google Data Studio
  • In this chart, we display Users Type by weekday, and data are aggregated by weekday for the selected period.

  • In this chart, the smallest series area is plotted at the top. When hovering over the chart it will display the Total Value and raw data for the individual series at each interval.

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

  • Area Chart Show Stack: Same as Area Chart, except in this chart, the smallest series area is plotted on the top rather than the bottom.

  • Area Chart 100% Stacking: If you want to split the trend over time into % share at each interval.

  • Area Chart: to show the distribution of categories as parts of a whole changing over an interval

4. Area Chart: Another Example

Area Chart in Google Data Studio
Area Chart in Google Data Studio

As a time series, area charts are also useful for seeing how your data trends over time, best suited for longer range, as is seen in this example. No configuration is applied in this chart.

Recommended: Yes

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