Line Markers1:56 with Michael Watson
Overview of the markers on line charts in Excel.
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 up