Original subtitles

In this lesson, we're going to be looking at area graphs.

Now, area graphs are very similar to the line graph, except that we're going to actually color the

area in that is underneath the line, and that can be useful for your own versions of data analysis.

But normally what we would use them for is trend analysis.

So again, we should be looking at using a date or a time within the x axis and seeing how things change

over time.

I'm going to delete this existing line graph and let's create a new one.

And if we move across in our visualization, you'll see that the next visualization is our area chart.

So let's click on that.

So we're going to start with that.

And again, we're going to do the same things that we did previously.

We're going to start with all the data in our x axis.

We're going to start with our sales in our Y axis, and you're going to see that this works very, very

similarly.

So again, I'm going to drill this up and we could drill it right up to the sum of cells by year.

Again, if I drill this down again and I'll just expand it, we get our sales by year end quarter and

then again we get now our sales by year, quarter and month.

So this is basically our monthly view.

This is the one that we would just looking at on our line graph.

So as I say, you're going to see that this is very similar.

Now, again, if we look at our wells, you'll see that we do get the ability to use a secondary y axis.

Now we covered that in the previous lesson, so I'll leave that for you to experiment with.

But I just quickly want to show what happens if we work with a legend, What happens if we work with

the small multiples?

So let's use our region again.

It's not too many.

There's only three regions.

So we drop that into our legend.

And what you're going to see is that the data now really sort of goes on top of each other.

Now, in my opinion, this is not that easy to actually read.

So what we're going to be doing just now in the lesson is we're going to be looking at a stacked area

graph, which I think then deals with this a lot better.

So if you're working with a legend, I think then you should actually be working with a stacked area

graph, not the normal area graph.

But as I said, we're going to look at that a little bit later in the in the lesson.

Let's move this down a bit.

Just look at our small multiples so this can be quite useful, especially when you want to be looking

at your trends over time.

And you can see you get a nice little area graph now showing you what the genuine trends are over time.

Okay.

So those are a couple of views that we saw in the previous lesson.

Let's just have a look at our formatting and you're going to see that this is very, very similar to

what we had with the with the previous one.

I'm actually just going to change this so we don't have the small multiples.

Let's just remove that.

Let's go back to our formatting.

So your x axis, as you can see, those options are pretty much the same as the line graph.

You can see that the also for the y axis, the same type of thing.

And as you go down you to grid lines, you'll zoom slider lines again.

So if you want to change the type of line you're using, your stroke on the line, as you can see,

sort of works very much the same as our line graph.

And again, you do have a step option with this as well.

So you go to your steps, you can change your colors as well, but you will see that there is an ability

to change the shade area, which is obviously a bit different to the line graph.

Again, you do have the ability to set your markers.

So if you want to put markers on here, the type of markers and the size colors are those as well and

also to use your data labels.

So if you turn those on can see that.

And again, we do get the option to be able to do label density like we could with the line graph.

So again, quite useful.

So as you can see that it's very much similar to what you had with the line graph.

So really when it comes to the area graph, there is a lot of similarities to the line graph and it's

really going to be up to you as to which one you prefer working with.

You want the line graph or do you want the area graph.

However, one of the things I do want to point out is that there is a little bit of a difference here

with the analytic side, so you can get a trend line on your area graph.

However, you will see that there is no forecasting option.

So if you want to include forecasting then you must use the line graph and please make sure with forecasting

as well, you have to be using a data field for the full costing.

So that's just something to take into account is that if you want to use forecasting, then please make

sure you use the line graph.

However, as I said, the area graph can be really quite nice to see.

So one of the things that you can do with your with your area graph that we just spoke about is the

ability to create a stacked area graph.

So let's have a look at that.

Let's go back to having our legend and as I just noted with our legend, kind of our values are on top

of each other here.

It's not really easy to see what is actually happening Now.

If we move across, you'll see that we have the stacked area chart as the next visualization.

Now, if I change this, you can see immediately that this is actually much easier to read.

So what you can do now is that you can actually easily see what is happening with Asia, what's happening

with Europe and what is happening with North America.

And how do these trends change over time.

Because basically, if you've got a large gap over here, but a small gap over here, then quite clearly

you can see that something that was quite large has changed.

So I am quite a fan of this graph.

It does give you the ability to be able to analyze your trends quite well by just looking at the.

Of the data and how they change.

So that's just something to take into account.

But as you can see, the graph very similar to the line graph in terms of the options and the abilities

that you get.

And also if you are working with a legend, I would suggest that you use a spectrograph.

However, with the stacked area graph, please be aware that you've got even less in terms of the analytics.

So basically it just gives you a constant line for your X and y axis.

It does not give you a lot of the number of the other functions that you can get with the other two

graphs as well.

So that's just something to take into account.

Okay, So there we go.

That's the area graph.

I'm going to conclude the lesson there.

I will see you in the next one.