Lines1:34 with Michael Watson
Overview of the Lines chart element.
Lines as a chart element 0:00 link different data points of a data series to each other. 0:03 So staying in our COGS spreadsheet, let's add some lines to the chart. 0:07 Notice that there are still keyboard shortcuts here, 0:12 the letters that are underlined, but I'm gonna use my mouse for now. 0:15 So that's it. 0:20 It's very easy to add lines to your chart. 0:21 Lines are most commonly used on stacked column charts. 0:24 They help to highlight where the large changes are occurring 0:29 based on the slope of the different lines. 0:32 So, here we can see the line above the raw material section of the column chart 0:35 is steeper than the line for the tools section. 0:43 So there's more of a change there. 0:47 Similarly, from your two to three, the line for 0:50 the raw materials is not as steep as it is for tools. 0:55 So the change is larger for the tools cost than it is for the raw materials cost. 0:59 I don't use lines very often. 1:04 But when I do, I only use them for 1:07 charts that have smaller time frames, and here's why. 1:09 Look what happens when you add lines to a longer series, they kinda get lost. 1:14 There is not as much quick takeaways and 1:19 it really doesn't help tell a story much better. 1:21 So again, you're gonna have to use your own judgement sometimes. 1:24 But my recommendation will be to not go crazy with lines when you're working with 1:27 larger time frames. 1:32
You need to sign up for Treehouse in order to download course files.Sign up