Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Data Visualization with Excel

Well done!

You have completed Data Visualization with Excel!

Sign up for Treehouse Back to Library

Line Markers

1:56 with Michael Watson

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 up

    Related 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 up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up