2.6. Area Charts in Looker Studio

Looker Studio Masterclass - YT - Free - Slides V2- C02_page-0007.jpg

Understanding Area Charts

Area charts are similar to time series charts, but with a few key differences. These charts are particularly useful for visualizing the distribution of a metric across different categories of a dimension over time.

Creating Area Charts

An area chart requires a metric and a breakdown dimension. In Looker Studio, apply the metric and breakdown dimension to create an area chart that shades the area under each line. The lines stack on top of each other, showing the distribution and trend of the metric across the categories.

Stacking Options

Area charts offer several stacking options:

  1. Regular stacking: Categories are stacked on top of each other, displaying the trend in total as well as the distribution of the metric across categories.
  2. No stacking: Categories are not stacked, which may look visually appealing but sacrifices the ability to analyze trends in total and distribution.
  3. 100% stacking: Categories are stacked to represent 100% of the metric, making it easier to analyze distribution but impossible to assess the total trend.

Adjusting Granularity

Like other charts displaying values over time, area charts in Looker Studio allow you to apply different date range granularities, such as day, month, or quarter.

Changing Chart Types

To change an area chart to another visualization type, click on the chart settings icon and select a different chart type. Looker Studio will attempt to apply the existing data, dimensions, and metrics to the new chart type. Change chart type to combo charts in Looker Studio if you need to compare multiple related metrics.

<aside> <img src="/icons/arrow-down-basic_blue.svg" alt="/icons/arrow-down-basic_blue.svg" width="40px" />

<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" width="40px" /> Enroll in Looker Studio Masterclass →

</aside>

📩 Receive my weekly Looker Studio tips

🖇 Connect with me on LinkedIn

</aside>