- All right.
So this is the first video in a new series on charts.
And the first thing before you even use a chart
it's important to understand what type
of data you're working with, right?
Because that's going to drive what type
of chart that we use.
So I've laid out a couple of examples here.
These are all different types of data
and I'll show you what they mean.
This first table that we have,
and these are all made up tables.
But what this is is if you were to sample a population
of let's say 769 trees,
there would be this many of each type.
So there are certain charts that make sense for this
because what this is, each of these pieces of data
is a part of the whole.
So 345 by itself doesn't mean anything.
But if you see 345 as part of this entire picture
then you understand what the data means.
So if you have a relationship like this
which we're calling part-to-whole
There are a few different types
of charts that you would use.
So what we're going to do, let's highlight this table
and you go to insert chart.
Google sheets going to guess what type of chart you want
based on the data that it sees.
And that's actually,
picked one of the examples I was going to talk about.
So you're seeing those data points in relation
to all of the others and that they make up a whole
this type of data can be best shown
as a pie chart that you're seeing there.
And there's different types of pie charts.
So you could do, what's called a donut chart
pie chart with hole in the middle,
and you could put some data in the middle of it
and we'll go more in depth
with each of these types of charts in different videos.
Right now, the point is just to show you the options
or you could do just a 3D pie chart.
All right, so all three of those are showing the composition
of what's in the 769, all right?
So let's delete this chart.
We'll move on to the next type.
I've kept a theme of trees here
but I've made this list, average tree height.
So why we chose that is because the 107 inches will say
say millimeters, wherever you are.
I guess that'd be a really small tree
but we'll say centimeters, meters?
Let's do meters.
This 107 is totally meaningful by itself.
And it has nothing to do with the 62 or the 99.
So each one of these data sets is whole in and of itself.
So we'll call it whole to whole.
You know, if we want to look at the type of chart for this,
let's highlight this table.
You see, you can grab the header row, if you want.
You don't need to,
we'll just highlight E5 through F8.
And this time let's do something different.
Instead of going to insert chart
we'll use another feature that's in Google sheets
that I almost never use, because it doesn't seem
to guess what I'm trying to do correctly.
But in this case, when I was putting these together
I noticed it was spot on almost every time.
You'll see at the end, it doesn't do it.
But what we're going to do is we're going to go down
in the lower right-hand corner.
We're going to left, click on explore, all right?
And explore, suggest these different chart types.
Let's just pick the bar chart for now.
We'll just left click it, drag it onto here.
And what this chart does is
this chart can easily symbolize different data points
and they do relate to each other in this chart,
You can see which one's largest
but they're not shown as part of a whole.
So this bar chart is a great way to show this data.
You can also do a line chart.
So we'll drag this here.
I don't think there's a best option for this
because it looks like it's showing you a trend
rather than four separate points
but depending on what you're doing, it might work well.
Let's get rid of that line chart for now.
And as I hover over each one of these charts
you'll see that different things happen.
So it will show you how many Sycamore are in the sample.
And if you left click on these three dots
you can edit the chart.
We'll go into all these different options
when we talk about specific chart types.
But for now, just know
that these are here and if you want to change something
it's pretty easy with all these settings.
Well we're through with that
we'll move on to the third type of chart.
So a lot of data that you have
is going to be based on dates, right?
And the dates mean something.
So you might want to see, Oh, I'm going to close this.
It's keeping it away.
You might want to see the relationship
of each of these pieces of data
over time to see what's happening to them.
So if you were to graph just 2021,
you probably wouldn't want this type of chart,
but if you want to capture
so if you want to capture all five of these
we'll call this a time series.
So it's showing these data points over time,
and we want to choose something that can illustrate
the effect of time on these data points.
So let's go back to using the explore option
and it gives you a few different choices.
One of them is a series of bar charts over time
and a series of line charts.
Let's do the line charts.
I think that I'm showing this the best myself.
So this line chart made some choices for you.
It decided to put the types of tree on the top,
time on the x-axis and the growth of the tree on the left.
This makes charts far easier to use than they used to be.
So when you used to build a chart
you had to know where to put all these data points.
And it was like taking a high school math class
all over again.
So Google sheets is doing a lot of this thinking for you.
It presents the chart
and then you just customize some things.
So in this case, maybe we want to change the title.
So let's just double left click on the title.
It's that easy.
And we'll just say growth over time.
All right, so there's some other options
that you can use to show a time series.
One of them are these bar charts,
but a good way to see some other ones
is just to select the data again
and see what it gives you.
So in this case it gave us
what it's calling a column chart
and this shows it pretty well too.
I personally find this one to be harder to look at, right?
So if you want to see maple compared to oak
you can't see that by going through it.
But if you see the lines, it's just smoother.
So all of this is going to depend on your audience
how technical they are, how it's presented
if it's something where you're just going to talk
about it briefly, and it's in a slide, make it simple
if it's something that you're going to publish
someone's going to have it in their hands.
They can look at as long as they want
you can make it more complicated.
All right, so let's move on
to the fourth type of data that you can have.
If I can learn how to scroll
let me clean this up a little bit.
All right, in the next set of data
that we're going to look at
we have days at the top and then a growth rate.
And I kind of made this data
as the sunnier that it gets, all right?
So the more days of sunshine per year
the faster the trees grow.
And that's your theory, at least what you want to do is see
if these two numbers are correlated.
So this type of chart is perfect for using
to see the relationship of two pieces of data.
Or you can do it with three as well
which would be a bubble chart, but we'll go into that later,
'cause this is just basic charts, right?
To help get an understanding
what we're going to do is select this table.
I made this one longer so that you can see kind of the value
of trying to project it a little bit better.
put Insert Chart.
I don't think it guesses the best chart to begin with.
This one to me, looks like it's showing historical data
kind of stock market data, or maybe weather data.
But if you want to make this look more like a projection
what you can do is choose scatter plot.
And this is the actual pieces of data
and might have to kind of squint your eyes, right?
But what you can do is see
there is a correlation with these.
It's not perfect, right?
But these are all the real points
where they lay on the graph
and then you can kind of draw imaginary line
through them to see what's happening.
If you hover over one of them, it will tell you what it is.
And one thing that I really like
about scatter charts is that you can add a trend line
and that's your best projection where it's going to be.
Now you can change the way that trend line curves.
But in this case I think that straight line
is pretty appropriate.
And that straight line makes sense
because I made this series mathematically
with a random number generator.
And I knew that they would kind of evenly deviate
around this mean.
All right, so that's showing data that correlates.
I threw in last one here, just for fun.
It doesn't fit in any of the other types
but if you wanted to show something occurring over an area,
so I have some data here
and it varies based on what state you're in.
And then it has some numerical values associated
with each state.
So if we see what the explore option brings up for this
it doesn't guess what I want to do.
So explore can be handy, but in this case
let's close that we'll go to Insert Chart
and we'll put this chart in the middle so you can see it.
This is actually pretty nice, the way it's showing it here.
But a fun type of chart
that you can do is called a geo chart.
So they're in the maps down here.
And at first it thinks
that you're talking about the whole world.
Being Google I would have thought
it might've been smart enough to see
that these are just States in the United States
but we can work our way through this.
So what you can do
when you come over to the left and you look at setup
let's go to customize and look at geo.
And let's tell it that the region that we want to work
with is United States.
And there we go
It color coded these to indicate their density.
You hover over each one.
It will tell you the actual number.
And if you look in the lower left-hand corner
and I will show you where that
lies on that key, it's pretty cool.
All right, so let's go more in depth
with each of these charts
and show you all the different options.
And we'll start out showing you all the options
with the pie chart.
And once it's made, I'll link that video,
and I'll see you in that one
Thanks for watching.
(soft music)