1
00:00:00,700 --> 00:00:03,120
Lines as a chart element

2
00:00:03,120 --> 00:00:07,220
link different data points of
a data series to each other.

3
00:00:07,220 --> 00:00:12,562
So staying in our COGS spreadsheet,
let's add some lines to the chart.

4
00:00:12,562 --> 00:00:15,531
Notice that there are still
keyboard shortcuts here,

5
00:00:15,531 --> 00:00:19,350
the letters that are underlined,
but I'm gonna use my mouse for now.

6
00:00:20,820 --> 00:00:21,490
So that's it.

7
00:00:21,490 --> 00:00:23,190
It's very easy to add lines to your chart.

8
00:00:24,450 --> 00:00:29,420
Lines are most commonly used
on stacked column charts.

9
00:00:29,420 --> 00:00:32,500
They help to highlight where
the large changes are occurring

10
00:00:32,500 --> 00:00:35,470
based on the slope of the different lines.

11
00:00:35,470 --> 00:00:41,319
So, here we can see the line above the raw
material section of the column chart

12
00:00:43,290 --> 00:00:47,670
is steeper than the line for
the tools section.

13
00:00:47,670 --> 00:00:49,430
So there's more of a change there.

14
00:00:50,690 --> 00:00:55,430
Similarly, from your two to three,
the line for

15
00:00:55,430 --> 00:00:59,020
the raw materials is not as
steep as it is for tools.

16
00:00:59,020 --> 00:01:03,610
So the change is larger for the tools cost
than it is for the raw materials cost.

17
00:01:04,770 --> 00:01:07,160
I don't use lines very often.

18
00:01:07,160 --> 00:01:09,790
But when I do, I only use them for

19
00:01:09,790 --> 00:01:14,483
charts that have smaller time frames,
and here's why.

20
00:01:14,483 --> 00:01:19,490
Look what happens when you add lines to
a longer series, they kinda get lost.

21
00:01:19,490 --> 00:01:21,561
There is not as much quick takeaways and

22
00:01:21,561 --> 00:01:24,800
it really doesn't help
tell a story much better.

23
00:01:24,800 --> 00:01:27,598
So again, you're gonna have to
use your own judgement sometimes.

24
00:01:27,598 --> 00:01:32,200
But my recommendation will be to not go
crazy with lines when you're working with

25
00:01:32,200 --> 00:01:33,427
larger time frames.