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.