Why A Column Instead of Bar4:03 with Michael Watson
Should we use a column or a bar chart? Learn when and why in this video.
Okay, here we are looking at our spreadsheet. 0:00 The Seven Dwarfs are all pretty good golfers. 0:02 Anyhow, we see that we have both negative and 0:06 positive values in our data set in column B. 0:10 Let's start off with a bar chart and see how it looks. 0:13 So I'm gonna select my data, Alt+N+C for 0:17 the column bar chart shortcuts. 0:24 And I'm gonna to do the Clustered Bar. 0:29 The bar chart does clearly show the different scores of the dwarfs. 0:33 But with positive and negative numbers, my view is that it's more intuitive to 0:38 see the negative values as going down from the axes, as opposed to the left of it. 0:43 You can see 0 is right here, and 0:47 it actually overlaps the label of Grumpy. 0:51 Let's change this to a column version and see what happens. 0:56 Change chart type. 1:01 Column, OK. 1:04 So in this example, I think a column chart is a better 1:08 way to tell the story of how the dwarfs played versus the target score of par. 1:13 We can see that Grumpy was the best golfer because he scored below par. 1:18 In golf, the person with the lowest score is the winner. 1:23 Sneezy was the worst golfer with a still very respectable ten over par. 1:26 Another thing to consider is that, 1:32 in this example, the names of the golfers are all fairly short. 1:35 If their names are much longer, it might actually be good to use a bar chart 1:39 instead because fitting all their names along the x-axis can become cluttered. 1:44 So I am going to change their names to, 1:49 Aristotle Duderino 1. 1:56 And then I'm going to copy this down. 2:02 Two. 2:08 Three, I'm using keyboard shortcuts on the PC. 2:11 They're a little different on Macs. 2:14 But on a PC it's F2 to get to the formula window. 2:15 On a Mac, it will be Ctrl+U or Cmd+U, depending on your setup. 2:18 What kind of name is Aristotle Duderino? 2:33 I have no idea. 2:35 Anyway, I want to copy the dwarfs' names so 2:36 I don't lose them and have to retype them. 2:40 I'm gonna paste those there. 2:44 And, Copy these over. 2:47 You can see now on the chart it's a little bit cluttered down here. 2:57 It's not to bad, but it's a little bit cluttered, so let's change it again. 3:00 Design, change Chart Type, go back to Bar. 3:05 Okay. 3:10 With a bar chart, it's easier to read the names in digesting information. 3:12 But you still have this negative value going left. 3:18 So my preference in this situation would be to use the column chart still, and 3:22 format the axis labels differently. 3:26 We'll cover formatting more later on in this course. 3:31 This example illustrates how, as someone working with data visualization, 3:35 you are gonna have to exercise your own judgment regularly. 3:40 It's always helpful to ask the question, 3:44 what's gonna tell the story the most clearly? 3:47 What visualization communicates the most information most clearly? 3:50 It's okay to experiment with different types of charts before 3:55 coming to a final decision. 3:58 That is absolutely okay. 4:00
You need to sign up for Treehouse in order to download course files.Sign up