1
00:00:00,430 --> 00:00:02,930
To create the stacked column chart,

2
00:00:02,930 --> 00:00:07,840
we select all the data in our
spreadsheet that we wanna chart.

3
00:00:10,740 --> 00:00:15,810
And choose Insert, 2-D Stacked Column.

4
00:00:17,550 --> 00:00:23,400
Looking at the stacked column chart,
you can see indeed that the Southeast and

5
00:00:23,400 --> 00:00:27,240
Burnside locations make up
the bulk of the membership.

6
00:00:27,240 --> 00:00:28,650
Here's our Burnside location,

7
00:00:28,650 --> 00:00:33,280
yellow, and here's our Southeast location,
the light green.

8
00:00:33,280 --> 00:00:37,880
In addition, you can see the relative
weakness of the second half of the year

9
00:00:37,880 --> 00:00:41,040
compared to the first half for
the entire network.

10
00:00:42,060 --> 00:00:47,330
Here it's generally larger and close to
14,000 or above in many of the months.

11
00:00:47,330 --> 00:00:52,384
And in the second half of the year
a lot more below 14,000 and

12
00:00:52,384 --> 00:00:55,630
generally worse than the first half.

13
00:00:55,630 --> 00:00:58,120
Let's switch to a stacked area view.

14
00:01:00,150 --> 00:01:02,384
Go here, Change Chart Type.

15
00:01:02,384 --> 00:01:08,970
Area > Stacked Area > Return.

16
00:01:08,970 --> 00:01:14,450
I think the area is a better way than
columns, to show the membership overtime.

17
00:01:15,480 --> 00:01:19,670
It's continuous from period to period and
shows that more clearly.

18
00:01:19,670 --> 00:01:24,000
Instead of seeing the nominal values
of each data series on the chart.

19
00:01:24,000 --> 00:01:27,160
That is, the values in the data set.

20
00:01:27,160 --> 00:01:31,258
If we select,
the 100% stacked area option,

21
00:01:31,258 --> 00:01:36,180
Excel will automatically convert it
into an area chart displaying, surprise,

22
00:01:36,180 --> 00:01:40,440
surprise, each data series
as a percent of total.

23
00:01:40,440 --> 00:01:41,530
So let's do that again.

24
00:01:41,530 --> 00:01:49,380
Change Chart Type > Area
> 100% Stacked Area.

25
00:01:49,380 --> 00:01:52,630
Lets make this a little bit bigger so
you can see it more clearly.

26
00:01:54,440 --> 00:02:00,180
You can see the North 2 location is
gaining share as a percent of total.

27
00:02:00,180 --> 00:02:01,265
That's right up here at the top.

28
00:02:02,420 --> 00:02:05,490
And Burnside and the North are declining.

29
00:02:05,490 --> 00:02:08,290
Let's rearrange the data series
to make that more clear.

30
00:02:08,290 --> 00:02:11,733
So Burnside, I'm gonna go up here and
make this 1.

31
00:02:14,235 --> 00:02:19,342
And North, I'm gonna click on that and
make that 2.

32
00:02:21,746 --> 00:02:26,890
This 100% Stacked Area chart
has relatively subtle changes.

33
00:02:26,890 --> 00:02:28,290
But, that's not always the case.

34
00:02:29,420 --> 00:02:34,300
Let's take a look at the units sold by
a coffee shop over the course of a year.

35
00:02:34,300 --> 00:02:37,708
Split out by whether the drinks are hot or
cold.

36
00:02:37,708 --> 00:02:43,520
Create a 100% Stacked Area chart.

37
00:02:47,268 --> 00:02:52,360
You can really see the seasonality with
100% of total view of the stacked area.

38
00:02:53,360 --> 00:02:58,180
Of course, in this simple example, you
could probably also see the variety and

39
00:02:58,180 --> 00:03:00,990
seasonality with a line chart.

40
00:03:00,990 --> 00:03:06,410
But be aware that in situations where
the changes are not so drastic,

41
00:03:06,410 --> 00:03:10,810
a stacked area chart could be
a good visualization option.