+ Reply to Thread
Results 1 to 2 of 2

Dynamic graph driven by input-driven named ranges

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Dynamic graph driven by input-driven named ranges

    I'm trying to have this graph that updates based on user inputted data. I've done something similar before but I think it was with Excel 2007 and now I'm in 2010 and things aren't working. I've looked online and read about having to make sure the named lists are "fully qualified reference." I've done that, and it'll work for a little bit of time, but then it stops shortly thereafter and doesn't update.

    I'm not sure if it matters whether I use line graphs or scatter graphs. I think based on what I'm looking to do I want to have a line graph with the dates formatted as text, but maybe that's worth exploring once I can get through this initial issue.

    I'm not sure really where to go from here so I'm reaching out to the community for either some helpful resources where I can find some proper information, or maybe something from someone that might know what's going on or how to fix this issue.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Dynamic graph driven by input-driven named ranges

    Hello
    Take a look at the attached file. It has two options. A chart with dynamic named ranges and if you're now using Excel 2010 a pivot table and chart utilizing slicers. I've only applied 3 of the named ranges but perhaps you could try doing the remaining two yourself to get an idea as to how they work.

    Hope it gives you a few ideas.
    DBY
    Attached Files Attached Files

+ 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] Creating a Graph Using Dynamic Named Ranges
    By JasonMcQueen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-03-2014, 10:23 AM
  2. PERCENTILE(IF(...) driven by Year
    By DK42 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-20-2014, 03:35 AM
  3. Replies: 2
    Last Post: 01-14-2013, 08:19 AM
  4. Driven to register!
    By Riqueza in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-23-2012, 05:09 AM
  5. Date driven value
    By ronocoo in forum Excel General
    Replies: 0
    Last Post: 05-23-2011, 02:15 PM

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