+ Reply to Thread
Results 1 to 2 of 2

Create line graph for each person and each sport

  1. #1
    Registered User
    Join Date
    06-02-2022
    Location
    sandy
    MS-Off Ver
    2020
    Posts
    8

    Create line graph for each person and each sport

    Hi. This is a tricky one and hard to explain. I have data that looks like this
    image.png

    I want to create a drop down for the person which then opens a drop down for the different sports attached to there name. Then given both the person and sport, plot a line graph for that specific data.

    Hopefully the image has attached

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Create line graph for each person and each sport

    A filter (https://www.wikihow.com/Use-AutoFilter-in-MS-Excel ) or a pivot table (https://www.wikihow.com/Use-AutoFilter-in-MS-Excel ) seem like the obvious first choices for this. Then create your chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create a line between points in Graph.
    By Lbergo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2017, 08:03 AM
  2. Making the best line up for a sport
    By kgesia4 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2016, 11:01 PM
  3. Need to create a graph(perhaps a line graph)
    By Dnmacc in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-26-2012, 08:57 AM
  4. [SOLVED] how do I create a bar graph with a trend line?
    By moshingbananas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2012, 10:35 AM
  5. Create a line graph template
    By Beginner Level in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2012, 04:23 AM
  6. How do you create a cumulative line graph?
    By Ray in forum Excel General
    Replies: 4
    Last Post: 12-04-2005, 07:15 PM
  7. problem to create a line graph
    By sk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2005, 01:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1