Recreate Moz Stacked Bar Chart with Google Data Studio and Google Sheets

In this video I show you how to use Google Sheets as a data source in Google Data Studio. Using data that has been saved in a Google Sheet I build a stacked bar chart in Google Data Studio to show a month by month trend of organic rankings and visibility. I have taken the data from Moz from one of my campaigns that I am running. The stacked bar chart that I am building in Google Data Studio is the same as the stacked bar chart that Moz uses to show ranking and visibility trend.

Some of the features you will see in this video are:

  • How to connect new data source in Google Data Studio
  • How to use data in Google Sheets for Google Data Studio
  • How to build charts in Google Data Studio
  • How to style a basic dashboard in Google Data Studio
  • How to style charts in Google Data Studio
  • How to add annotations to your charts in Google Data Studio

You can use this chart as a part of a bigger SEO dashboard and size it the way to fit into your report.

Google Data Studio and Google Sheets - Moz Rankings Stacked Bars Chart

For a detailed “walk through” Google Data Studio check out my Google Data Studio Guide!

Leave a Reply

Your email address will not be published. Required fields are marked *