Hey there, I’m Benjamin from Loves Data. In this video, you will learn how to create charts and
graphs in Google Sheets. We will look at some of the different ways you can visualize data
in Google Sheets... We will cover line charts, column charts, and pie charts.
We will also look at how you can quickly and easily add charts and graphs to Google Sheets
using the ‘Explore’ feature. And once you’re happy with your chart or graph I’ll show you how you can
add it to your presentations and documents in Google Drive. Okay, let’s get started!
Today I’m using the example spreadsheet I used in my ‘Google Sheets Tutorial for Beginners’.
If you’re just getting started, then take a moment to check it out. You can find a link to watch the
tutorial in the description below this video. My example spreadsheet is quite simple. We can see
it includes names and email addresses. There is a column that shows each person’s membership level,
along with the revenue received from each person and the date they joined. Let’s start by creating
a line chart that shows the amount of revenue by date. To do this, let’s select the cells for
the chart... I’m going to select ‘G2’ to ‘H7’... Now let’s select ‘Insert’... And then ‘Chart’...
We can see that Google Sheets has automatically added a column chart to our spreadsheet.
Let’s select the ‘Chart Type’... This lets us view the different types of charts we can use.
Let’s select ‘Smooth Line Chart’... We can see that the date people joined is automatically
selected as the ‘X-axis’ and that ‘Revenue’ is the ‘Series’ (or the line) presented in
the chart. We can change all of these options. For example, we can change the ranges (or cells)
used to create the graph. Since I’m happy with the graph so far, let’s select ‘Customize’...
And let’s select ‘Chart and Axis Titles’... We can now change the title of our graph... Let’s change
it to ‘Revenue by Date’... We can see the chart updates... And although we’ve used this option to
change the title, we can also simply double-click the title in the graph to make changes...
Let’s make the title bold... And let’s change the color of the title... Next,
we can see there are titles for the horizontal and vertical axis. For this chart, I would like
to remove these, so I’m going to select ‘Chart Title’... And select ‘Horizontal Axis Title’...
Now I can delete the ‘Title Text’... I can now do the same for the ‘Vertical Axis Title’...
And if you prefer, you can simply double click on the chart and remove these,
in the same way as editing the title. Now let’s select ‘Series’... We can now change the way
the series (or the line) is presented in the chart. Let’s change the color of the series...
And let’s increase the thickness of the line... We can also add points to the series to see where
values are being used from our spreadsheet... And let’s increase the size of the points...
Let’s select ‘Data Labels’... This wil include the values for each point on the chart. You will
notice that the third point is missing the data label. We will adjust the chart in a moment,
so we can see this label. We can also add a trendline to our chart... This lets us see the
overall change... We can now see that revenue is decreasing overtime for our example spreadsheet.
Now let’s select ‘Horizontal Axis’... And let’s change the ‘Text Color’...
And let’s select the ‘Vertical Axis’... And change the ‘Text Color’...
Now let’s enter ‘500’ as the ‘Maximum Value’...
This sets the maximum value for the vertical axis and means that we can now see the label
for the third point in our chart... Once you’re happy with your chart you can choose to leave
it on the current sheet, copy it, or even move it to its own sheet. Let’s select our sheet to
close the ‘Chart Editor’... And let’s select our chart again... You will notice three vertical
dots on the top right corner of the chart... Let’s select these... And then let’s select
‘Move to own sheet’... We can now see that a new sheet is added to our spreadsheet...
And we can see the same options as we did before, but now they’re at the top of the
chart... We can copy the chart, edit the chart, publish the chart (you can use this
to embed the chart on your website). You can also download the chart and delete the chart.
Let’s select ‘Copy Chart’... And let’s create a new sheet... Let’s name the sheet ‘Dashboard’..
Now let’s paste the chart... We can use this sheet to build a dashboard that contains
all of our charts. Okay, now let’s head back to our ‘Members’ sheet... And let’s create
another chart. Let’s select the ‘Status’ column. I’m going to select ‘F2’ to ‘F7’...
And now let’s select ‘Insert’... And ‘Chart’... We can see that Google Sheets automatically
adds a column chart to our sheet. I’m going to leave the default options for the ‘Setup’ tab,
and I’m going to choose ‘Customize’... You will find similar options to what we covered when
we create our line chart. We can see there are options to customize the ‘Chart Style’, the ‘Chart
and Axis Titles’, the ‘Series’ and so on... Let’s select ‘Series’... We can see that this chart
is based on a single column from our sheet, so there is only one option for adjusting the color.
However, I would like to customize this so that each bar is shown in the color for the membership
level. There are two options to do this. We can select ‘Add’ next to ‘Format Data Point’... And
then choose the data point from the graph... Or we can close this... And simply double click the data
point we want to change. Let’s double-click ‘Silver’... And let’s change the color...
We can repeat this for the ‘Gold’ and ‘Bronze’ data points...
Now let’s copy this chart... And let’s add it to our dashboard sheet...
Now let’s head back to our ‘Members’ sheet...
I can now remove this chart from the sheet and it will continue to be available on our dashboard
sheet... Now let’s create a pie chart. I’m going to select the ‘Valid Email’ column which is used
to verify the format of the email addresses of members. So I’m going to select ‘E2’ to ‘E7’...
And now let’s select ‘Insert’... And ‘Chart’... We can see Google Sheets has
automatically added another column chart. Let’s choose ‘Column Chart’... And change this to
‘Pie Chart’... We can see that the chart is automatically aggregating the number of ‘True’
and ‘False’ results from our column. Let’s select ‘Customize’... And let’s choose ‘Pie Chart’...
We can now adjust the style of our chart. Let’s make the chart a donut chart... Now let’s select
‘Pie Slice’... And let’s change the colors used for our chart...
There are additional customization options you can explore...
I’m happy with this chart so I’m going to copy it to the dashboard sheet...
And now let’s head back to the ‘Members’ sheet again...
Again, I’m going to remove this chart from the sheet, since I’ve added it to the dashboard.
Now I want to show you the ‘Explore’ feature. This is a really handy feature in Google Sheets,
especially when you’re feeling stuck and not sure how to visualize your data.
If you want suggestions for visualizing particular cells in your sheet,
then you can select them. I’m going to select all of the cells in the sheet... You can find
the ‘Explore’ feature in the bottom right corner... So let’s click ‘Explore’...
You will now find a range of suggestions for your data... You just need to hover over a
suggestion and choose the ‘Add’ option if you would like to use it... Finally, I want to show
you how to add the charts we’ve created to your presentations and documents in Google Drive.
Let’s head back to our dashboard sheet... And let’s copy the ‘Revenue’ chart...
Let’s head to a document... All we have to do is paste the chart into our document...
We can now see we can choose if we want the chart to be linked to our spreadsheet. Choosing this
option means that the chart will update in our document when we make changes to the spreadsheet.
Or you can use the ‘Paste Unlinked’ option so that the chart doesn’t update. I’m going to leave the
default option selected and click ‘Paste’... Our chart is now included in our document and if the
spreadsheet is changed we will see the option to update the chart in our document. And you can also
copy and paste your charts into presentations you’ve created in Google Slides. That’s it!
So that’s how you can create charts and graphs in Google Sheets. Remember there are different charts
and graphs available, so take time to explore the different options and use the one that helps
convey your message. Aim for a visualization that is concise and easy to understand. And if you get
stuck, then look for the ‘Suggested’ charts or use the ‘Explore’ feature in the bottom right corner
of Google Sheets. What charts are you going to use in Google Sheets? I’d love to know! Let me
know in the comments below. And if you found this video helpful please subscribe, share it with your
friends, and hit the like button so I know to make more videos like this. See you next time!