Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Data Visualization with Excel!
You have completed Data Visualization with Excel!
Preview
Overview of the Lines chart element.
Example Excel Spreadsheet
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up