+ Reply to Thread
Results 1 to 3 of 3

How do I update my static line graph to allow a user to select which data to graph

  1. #1
    Registered User
    Join Date
    12-26-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    How do I update my static line graph to allow a user to select which data to graph

    Hello,
    I'm fairly new to excel and have been tasked with visualising some existing data.
    Basically I have a line graph that plots a graph-set to give five years of information.
    Each graph-set has a heading [Area Name] and two columns with 60 rows in each.
    Column-1 is mmm/dd and Column-2 is a 3 figure number.
    It's very simple to create a very nice line graph individually for each data-set.
    What I would like is to have a machanism [form control/drop down etc etc, not sure if possible] so that the user can simply select from the graph which data-set heading [which is the geographic area name] they want and the chart will plot that range of mmm/dd and data according to that selection.
    Sounds simple I know but for me I'm struggling getting to grips with Index or table... I've definitely gone as far as I can and need help now.
    Hope this makes sense
    Thanks
    Tom

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: How do I update my static line graph to allow a user to select which data to gra

    Hi Tom,

    Welcome to forum.

    This seems to be achievable using dynamic name ranges / offset function etc, but it will be better if you can upload the sample file for the forum to give a try. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How do I update my static line graph to allow a user to select which data to gra

    Interactive Charting by Combo Box or Checkbox
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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