Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Start a free Basic trial
to watch this video
Learn about stacked column charts, and get introduced to 100% stacked charts.
Example Excel Spreadsheet
-
0:00
To create the stacked column chart,
-
0:02
we select all the data in our spreadsheet that we wanna chart.
-
0:10
And choose Insert, 2-D Stacked Column.
-
0:17
Looking at the stacked column chart, you can see indeed that the Southeast and
-
0:23
Burnside locations make up the bulk of the membership.
-
0:27
Here's our Burnside location,
-
0:28
yellow, and here's our Southeast location, the light green.
-
0:33
In addition, you can see the relative weakness of the second half of the year
-
0:37
compared to the first half for the entire network.
-
0:42
Here it's generally larger and close to 14,000 or above in many of the months.
-
0:47
And in the second half of the year a lot more below 14,000 and
-
0:52
generally worse than the first half.
-
0:55
Let's switch to a stacked area view.
-
1:00
Go here, Change Chart Type.
-
1:02
Area > Stacked Area > Return.
-
1:08
I think the area is a better way than columns, to show the membership overtime.
-
1:15
It's continuous from period to period and shows that more clearly.
-
1:19
Instead of seeing the nominal values of each data series on the chart.
-
1:24
That is, the values in the data set.
-
1:27
If we select, the 100% stacked area option,
-
1:31
Excel will automatically convert it into an area chart displaying, surprise,
-
1:36
surprise, each data series as a percent of total.
-
1:40
So let's do that again.
-
1:41
Change Chart Type > Area > 100% Stacked Area.
-
1:49
Lets make this a little bit bigger so you can see it more clearly.
-
1:54
You can see the North 2 location is gaining share as a percent of total.
-
2:00
That's right up here at the top.
-
2:02
And Burnside and the North are declining.
-
2:05
Let's rearrange the data series to make that more clear.
-
2:08
So Burnside, I'm gonna go up here and make this 1.
-
2:14
And North, I'm gonna click on that and make that 2.
-
2:21
This 100% Stacked Area chart has relatively subtle changes.
-
2:26
But, that's not always the case.
-
2:29
Let's take a look at the units sold by a coffee shop over the course of a year.
-
2:34
Split out by whether the drinks are hot or cold.
-
2:37
Create a 100% Stacked Area chart.
-
2:47
You can really see the seasonality with 100% of total view of the stacked area.
-
2:53
Of course, in this simple example, you could probably also see the variety and
-
2:58
seasonality with a line chart.
-
3:00
But be aware that in situations where the changes are not so drastic,
-
3:06
a stacked area chart could be a good visualization option.
You need to sign up for Treehouse in order to download course files.
Sign up