1 00:00:00,000 --> 00:00:04,629 [MUSIC] 2 00:00:04,629 --> 00:00:06,247 At the end of the last stage, 3 00:00:06,247 --> 00:00:11,250 we gave a quick overview of different types of charts you can make in Excel. 4 00:00:11,250 --> 00:00:13,410 You might be thinking, well that's cool, 5 00:00:13,410 --> 00:00:16,400 but when do I use a column instead of a bar? 6 00:00:16,400 --> 00:00:17,480 Or why does it even matter? 7 00:00:18,740 --> 00:00:23,279 Keep in mind that a key goal of data visualization is to tell a story. 8 00:00:23,279 --> 00:00:26,799 The more quickly and clearly you can tell the story, the better. 9 00:00:26,799 --> 00:00:29,689 And it's absolutely the case that some charts just aren't 10 00:00:29,689 --> 00:00:33,060 as effective as others depending on the story you are trying to tell. 11 00:00:34,320 --> 00:00:37,850 Let's cover a few different examples starting with the simple question around 12 00:00:37,850 --> 00:00:38,980 columns or bars. 13 00:00:40,450 --> 00:00:45,380 To most people bar and column charts are basically the same thing. 14 00:00:45,380 --> 00:00:49,130 They both display data with rectangle sizes proportional 15 00:00:49,130 --> 00:00:53,990 to the underlying value of that data point or series. 16 00:00:53,990 --> 00:00:57,470 The obvious difference is that column charts have the data organized 17 00:00:57,470 --> 00:00:58,780 horizontally. 18 00:00:58,780 --> 00:01:04,375 With the column values associates with the y-axis and labels along the x. 19 00:01:04,375 --> 00:01:08,990 Bars are flipped with labels along the y-axis and values along the x. 20 00:01:10,180 --> 00:01:14,980 In most situations, these charts can be used interchangeably. 21 00:01:14,980 --> 00:01:18,360 In the teachers notes, you'll find a link to a spreadsheet. 22 00:01:18,360 --> 00:01:23,770 And I want you to create a chart visualizing the data in that spreadsheet 23 00:01:23,770 --> 00:01:27,670 based on what you decide is better, a bar or a column chart. 24 00:01:28,900 --> 00:01:32,379 Keep in mind the goal of telling a story clearly. 25 00:01:32,379 --> 00:01:35,800 In the next video, I'll show you what I would do.