How to Create Charts in Google Data Studio [Scorecard, Time Series & Pie Chart]

How to Create Chart in Google Data Studio 32

In this article, we will learn how to create charts in google data studio. We have already learned how to connect data sources in Data Studio. In this article, we will use a sample Google Analytics data source to make beautiful visualizations and will start filling up our empty canvas.

We will see why visualization is important and what kind of problems Google Data Studio solves using its charts and graphs concept.

I am talking about Google Analytics data because it has so many metrics to visualize. and it’s the most common internet data that can be used for visualization, you can use any data that suits you, I am going to use a Google Analytics sample so that anyone not having a website or google analytics account can also relate with the examples.

Importance of Charts in Google Data Studio

Google Data Studio is based on charts and graphs, we have nothing but so many varieties of charts, and graphs that are used for beautiful and functional visualization using any kind of data source. We must know how to set up and style the charts using the built-in tools, there are so many features we will explore about the charts, but first, we must know how to create a basic chart, unlike google sheets or google docs, creating a chart can be little tricky in Data Studio.

So we must have all the things we need, and we must set up everything perfectly to go with it. This article is meant to teach you how to set up and structure a basic chart then we will further learn about editing, customization, custom fields, calculated fields, metrics, data blending, and so on. The first and most important thing is to set up your chart therefore, we need to learn how to create charts in Google data studio.

See also  Google Search Console Data Studio Template

How to Create Charts in Google Data Studio?

We will start by creating the chart, we have already learned to connect data. Here, we will begin creating beautiful charts and solve real-world problems.

Create Charts in Google Data Studio – Simple Scorecard

The scorecard is a kind of visualization chart that shows nothing but a total of anything, for example in your report you need to show the total profit, total cost, and total bounce rate, here the scorecard is the best kind of visual element that can show the total. As we are using a sample google analytics data source, we have some metrics that can be used to display in a scorecard such as bounce rate, cost, etc. To add a scorecard you can follow the below steps after connecting a data source.

Note: You have only your metric name available for adding to a chart, if you have any other data source other than the Google Analytics sample data source, then you will have different metric names. Metric names are nothing but column names.

Step 1

Click on “Add a chart”

How to Create Chart in Google Data Studio 1

Step 2

From the Scorecard, section pick any scorecard, and click to add

How to Create Chart in Google Data Studio 2

Step 3

A sticky element will be floating with your mouse cursor, simply click anywhere to place the scorecard.

How to Create Chart in Google Data Studio 3

Step 4

A scorecard has been added, you can see a default metric is here with the scorecard.

How to Create Chart in Google Data Studio 4

Step 5

Now you can add any metric here in the scorecard, to change it simply click on the metric name in the Metric section inside the Chart editor box.

How to Create Chart in Google Data Studio 5

Step 6

Search a metric name to add

How to Create Chart in Google Data Studio 6

How to Create Chart in Google Data Studio 7

Step 7

Metric has been added

How to Create Chart in Google Data Studio 8

Step 8

Similarly, you can add more like this.

How to Create Chart in Google Data Studio 9

Step 9 (Optional)

Another way to add a scorecard

How to Create Chart in Google Data Studio 10

How to Create Chart in Google Data Studio 11

See also  How to Use Conditional Formatting in Google Data Studio

How to Create Charts in Google Data Studio – Time Series Chart

In this section, we will learn how to plan and set up a time series chart in Google Data Studio.

it is line charts that visualize data over time. These are highly used and very important to learn in the scope of this tutorial. So, as we have some Google Analytics data sources, let’s see how we can use time series or time series charts.

Step 1

Go to “Add a Chart”

How to Create Chart in Google Data Studio 12

Step 2

From the time series section, pick any chart

How to Create Chart in Google Data Studio 13

Step 3

Drop the chart anywhere on the canvas to place it

How to Create Chart in Google Data Studio 14

Step 4

Now, you can see the default value is “New user”, of course, we can change it and also can do many other things

How to Create Chart in Google Data Studio 15

Step 5

First, let’s change the metric

How to Create Chart in Google Data Studio 16

How to Create Chart in Google Data Studio 17

How to Create Chart in Google Data Studio 18

Step 6

Now here, in the Dimension, we can do so many things with time, we can set starting and ending dates, we can select a day of the week, day of the month, month of Year, and so many combinations like these in the date button under dimensions section.

How to Create Chart in Google Data Studio 19

How to Create Chart in Google Data Studio 20

Day of week

It will show all seven days data of the data, which means only days are compared with each other

How to Create Chart in Google Data Studio 21

How to Create Chart in Google Data Studio 22

Month of Year

It will show the monthly based data and will compare months with each other.

How to Create Chart in Google Data Studio 23

How to Create Chart in Google Data Studio 24

So this is how we use time series charts for data visualization, these are still some basic concepts about the charts, soon we will learn about custom fields, calculated fields, filters, queries, conditionals, blending, regular expressions, and more.

I hope you found the time series very easy and you will surely practice it.

See also  How to Customize Tables in Google Data Studio [Complete Guide]

How to Create Charts in Google Data Studio – Pie Chart

In this section, we will learn how to create charts in google data studio and that too from a pie section. Pie charts are very useful to break down the data based on multiple categories, here we can use pie charts to see the gender breakdown of our website visitors and so many use cases like this.

Step 1

To add a pie chart simply go to “Add a Chart”

How to Create Chart in Google Data Studio 25

Step 2

Select any variant of the pie chart from the Pie section

How to Create Chart in Google Data Studio 26

Step 3

Drop chart anywhere on the canvas, and the chart is here

How to Create Chart in Google Data Studio 27

How to Create Chart in Google Data Studio 28

Step 4

I dont need a date dimension here, what I need is gender so I will change the dimension from date to gender.

How to Create Chart in Google Data Studio 29

Step 5

Here it is, now it looks very clean when we accurately selected the dimension

How to Create Chart in Google Data Studio 30

Step 6

We can have more kinds of distribution here, like a breakdown of devices our users have while accessing our website, this can be done by changing the dimension from gender to device category.

How to Create Chart in Google Data Studio 31

How to Create Chart in Google Data Studio 32

Similarly, you can see the breakdown of user type in a pie chart, it’s divided into the new visitors and returning visitors. I hope you have understood how to create charts in Google Data Studio and how to assign data to them.

I recommend you explore more dimensions for all three types of charts we have covered today in this tutorial. There is a lot to explore.

So, you see how we use the basic charts for visualization of our data in Google Data Studio. This was a basic beginner’s guide on how to create charts in google data studio. We will learn how to improve these charts and take them to perfection using advanced techniques and functions in Google Data Studio.

Useful Notes

  • All the charts have already selected dimensions of data when we create them from scratch
  • Charts can also be added from Insert Tab
  • Charts are fully customizable and editable with color schemes, fonts, sizes, background color, line thickness, opacity, and so many things. We will cover these in the styling tutorial later in this series.
  • Don’t forget the difference between a dimension and a metric.

See also  How to Blend Data in Google Data Studio [Guide 2022]

Frequently Asked Questions

How can we create a heat map in Google Data Studio?

Simply, just like we created three common charts in this article, we can add a heatmap as well. A heatmap is available in the charts drop-down under the Google maps section. You can also add it by going to Insert Tab and then find Heatmap and click on it to add.

How to customize charts in Google Data Studio?

Just like Google Sheets, we have a similar interface for chart styling. The first tab is the setup tab in which we worked in this article, and next to it we have a Style tab in which all the styling, editing, and customization is. We will explore this tab later in this series.

How to add custom date ranges in a time series chart?

In the setup tab of the chart editor box, scroll down to the “Default date range” section and select the radio button “custom“, then below is the date picker to select starting and ending dates, this section can be different based on the dimension you have selected above.

Conclusion

Wrapping up how to create charts in Google Data Studio. We have learned the basics of the charts and have seen three popular chart types in Data Studio we have seen basic scorecards, then time series charts, and then a pie chart. I hope you have understood these charts and you now know what else is required to create charts in google data studio. The metric and the dimension are two important things to know when working with Charts in Data Studio.

I hope you find this article helpful and have learned something new. I will see you with another helpful tutorial soon. Take care and Keep learning with Office Demy

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general