Sort data and form graphs

Hi there! Relatively new to excel, so please bear with me


So I have a spreadsheet of data that sort of goes like this


JOHN, 12, 2324342, 13

HENRY, 13,21331223,5

MIKE, 14, 12313,6

TERRY, 11, 231231, 4

JOHN, 12, 123123,5

JOHN, 12, 123123123,5

JOHN, 12, 542423, 6

MIKE, 14, 123123, 6

MIKE, 14, 453234, 90

MIKE, 14, 2131231, 84

HENRY, 13, 23123, 45


As shown, for the NAME column, there are 4 different names. My question is from this one spreadsheet, is it possible to create a graph for each respective NAME vs AGE? By that I mean without having first to sort the data, I can create graph for just JOHN vs AGE. 


Currently I’m selecting both columns for NAME and AGE but by doing so I create a graph for all four names, while as I’m hoping to create a graph for each respective name.


Thank you in advance.

By: 13

12 thoughts on “Sort data and form graphs

  1. sling tv

    Thanks , I’ve recently been looking for info approximately this subject for ages and yours is the
    best I have came upon till now. But, what concerning the
    conclusion? Are you positive concerning the supply?

  2. free trial

    What i do not realize is if truth be told how you are no longer really much more neatly-favored than you might be now.

    You’re so intelligent. You recognize thus significantly with regards to this
    matter, produced me individually imagine it from a lot of varied angles.

    Its like women and men aren’t fascinated unless it’s something
    to do with Lady gaga! Your own stuffs outstanding. All the time maintain it up!

  3. coconut oil

    Superb website you have here but I was wondering if you knew of any
    community forums that cover the same topics discussed
    here? I’d really like to be a part of group where
    I can get advice from other experienced individuals that share the same interest.
    If you have any suggestions, please let me know. Thanks a lot!

  4. quest bars cheap coupon twitter

    Hi there! I understand this is kind of off-topic however I had to
    ask. Does building a well-established website like yours require
    a large amount of work? I am completely new to writing a blog
    but I do write in my diary everyday. I’d like to start a blog
    so I will be able to share my experience and views online.
    Please let me know if you have any kind of ideas
    or tips for brand new aspiring blog owners. Appreciate it!


    Hello just wanted to give you a quick heads up. The text in your post seem to be running off the
    screen in Safari. I’m not sure if this is a format issue or something to
    do with web browser compatibility but I figured I’d
    post to let you know. The layout look great though! Hope you get the
    issue solved soon. Kudos


    Hiya very nice web site!! Guy .. Beautiful .. Wonderful
    .. I’ll bookmark your website and take the feeds also? I’m glad to seek
    out so many helpful info right here within the submit, we need develop extra strategies in this regard, thank you for sharing.
    . . . . .

Comments are closed.