1 00:00:00,390 --> 00:00:02,508 Okay, here we are looking at our spreadsheet. 2 00:00:02,508 --> 00:00:06,490 The Seven Dwarfs are all pretty good golfers. 3 00:00:06,490 --> 00:00:10,160 Anyhow, we see that we have both negative and 4 00:00:10,160 --> 00:00:13,744 positive values in our data set in column B. 5 00:00:13,744 --> 00:00:17,435 Let's start off with a bar chart and see how it looks. 6 00:00:17,435 --> 00:00:24,169 So I'm gonna select my data, Alt+N+C for 7 00:00:24,169 --> 00:00:29,272 the column bar chart shortcuts. 8 00:00:29,272 --> 00:00:32,190 And I'm gonna to do the Clustered Bar. 9 00:00:33,950 --> 00:00:37,320 The bar chart does clearly show the different scores of the dwarfs. 10 00:00:38,390 --> 00:00:43,600 But with positive and negative numbers, my view is that it's more intuitive to 11 00:00:43,600 --> 00:00:47,910 see the negative values as going down from the axes, as opposed to the left of it. 12 00:00:47,910 --> 00:00:51,589 You can see 0 is right here, and 13 00:00:51,589 --> 00:00:56,506 it actually overlaps the label of Grumpy. 14 00:00:56,506 --> 00:00:59,379 Let's change this to a column version and see what happens. 15 00:01:01,842 --> 00:01:03,038 Change chart type. 16 00:01:04,790 --> 00:01:08,121 Column, OK. 17 00:01:08,121 --> 00:01:13,040 So in this example, I think a column chart is a better 18 00:01:13,040 --> 00:01:18,700 way to tell the story of how the dwarfs played versus the target score of par. 19 00:01:18,700 --> 00:01:23,600 We can see that Grumpy was the best golfer because he scored below par. 20 00:01:23,600 --> 00:01:26,800 In golf, the person with the lowest score is the winner. 21 00:01:26,800 --> 00:01:31,690 Sneezy was the worst golfer with a still very respectable ten over par. 22 00:01:32,830 --> 00:01:35,100 Another thing to consider is that, 23 00:01:35,100 --> 00:01:39,590 in this example, the names of the golfers are all fairly short. 24 00:01:39,590 --> 00:01:44,409 If their names are much longer, it might actually be good to use a bar chart 25 00:01:44,409 --> 00:01:49,795 instead because fitting all their names along the x-axis can become cluttered. 26 00:01:49,795 --> 00:01:54,096 So I am going to change their names to, 27 00:01:56,240 --> 00:02:00,991 Aristotle Duderino 1. 28 00:02:02,992 --> 00:02:05,850 And then I'm going to copy this down. 29 00:02:08,073 --> 00:02:08,978 Two. 30 00:02:11,380 --> 00:02:14,359 Three, I'm using keyboard shortcuts on the PC. 31 00:02:14,359 --> 00:02:15,657 They're a little different on Macs. 32 00:02:15,657 --> 00:02:18,584 But on a PC it's F2 to get to the formula window. 33 00:02:18,584 --> 00:02:24,140 On a Mac, it will be Ctrl+U or Cmd+U, depending on your setup. 34 00:02:33,302 --> 00:02:35,530 What kind of name is Aristotle Duderino? 35 00:02:35,530 --> 00:02:36,496 I have no idea. 36 00:02:36,496 --> 00:02:40,677 Anyway, I want to copy the dwarfs' names so 37 00:02:40,677 --> 00:02:44,754 I don't lose them and have to retype them. 38 00:02:44,754 --> 00:02:47,475 I'm gonna paste those there. 39 00:02:47,475 --> 00:02:54,492 And, Copy these over. 40 00:02:57,441 --> 00:03:00,870 You can see now on the chart it's a little bit cluttered down here. 41 00:03:00,870 --> 00:03:05,275 It's not to bad, but it's a little bit cluttered, so let's change it again. 42 00:03:05,275 --> 00:03:08,376 Design, change Chart Type, go back to Bar. 43 00:03:10,671 --> 00:03:11,484 Okay. 44 00:03:12,916 --> 00:03:17,034 With a bar chart, it's easier to read the names in digesting information. 45 00:03:18,828 --> 00:03:22,100 But you still have this negative value going left. 46 00:03:22,100 --> 00:03:26,340 So my preference in this situation would be to use the column chart still, and 47 00:03:26,340 --> 00:03:28,442 format the axis labels differently. 48 00:03:31,458 --> 00:03:35,430 We'll cover formatting more later on in this course. 49 00:03:35,430 --> 00:03:40,100 This example illustrates how, as someone working with data visualization, 50 00:03:40,100 --> 00:03:44,020 you are gonna have to exercise your own judgment regularly. 51 00:03:44,020 --> 00:03:46,100 It's always helpful to ask the question, 52 00:03:47,100 --> 00:03:50,300 what's gonna tell the story the most clearly? 53 00:03:50,300 --> 00:03:55,400 What visualization communicates the most information most clearly? 54 00:03:55,400 --> 00:03:58,380 It's okay to experiment with different types of charts before 55 00:03:58,380 --> 00:04:00,580 coming to a final decision. 56 00:04:00,580 --> 00:04:02,250 That is absolutely okay.