Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Overview of the markers on line charts in Excel.
This video doesn't have any notes.
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
For line charts,
0:00
sometimes it helps to further
distinguish the lines with markers.
0:01
This is particularly helpful with data
series that are crossing over each other
0:06
consistently.
0:10
Or where color is not an option,
for example,
0:12
if you know you're limited to black and
white printers.
0:14
You can add line markers
to your line charts.
0:18
Let's see how you do that now.
0:21
So I selected the chart and
we go up here and
0:24
say, Change Chart Type,
and I've got line here.
0:27
And if you look over here,
Line with Markers,
0:30
and you select that and press OK.
0:35
So you can see now there's little circles.
0:38
Now, for some reason, we're seeing
all the lines with the same markers.
0:41
But really, we wanna have different
types of markers for different lines, so
0:46
that we can clearly
distinguish between the two.
0:50
Most Excel software I work with will
automatically do that for us, but for
0:53
some reason, that's not happening here.
0:56
So let me show you how to
change the marker manually.
0:58
Click on the marker,
right-click it, Format Data Series.
1:02
So I go to the left, and
you can see there's Line, but
1:09
to the right, just here there's Marker.
1:12
And I'm going to click Built-In.
1:17
And I can change it right here,
so I'll do a square, but there's
1:20
a bunch of other options, and you can
also choose your own picture if you like.
1:24
And I'm gonna make this a bit
bigger to emphasize it.
1:30
Let's do it for one other data series so
you can see it again.
1:38
Format Data Series, I go to the left,
select Marker, Built-in,
1:42
and I'm gonna do an X.
1:47
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