+ Reply to Thread
Results 1 to 4 of 4

Dynamic Graphing timeline based on 2 dropdown criteria

  1. #1
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Dynamic Graphing timeline based on 2 dropdown criteria

    Hi everyone,

    I have a large amount of weekly team data I would like to show week over week graphically. My data has the week ending dates in column A. I would like to have two Data Validation dropdowns - to select a starting week and an ending week - with the graph being dynamic and changing the X axis to reflect only those weeks selected and those in between. What is a good way of doing this without making it a pivot chart?
    Last edited by GuruWannaB; 05-27-2018 at 11:29 PM. Reason: left out condition of not being a pivot chart
    I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!



    Please mark your threads as Solved once it is solved. Check the FAQ's to see how.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Dynamic Graphing timeline based on 2 dropdown criteria

    Create 'dynamic named ranges' and drive the chart from those.

    If you need more than that, then attach a sample workbook so we can see your data layout.

    BSB

  3. #3
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Re: Dynamic Graphing timeline based on 2 dropdown criteria

    I have attached a sample workbook
    Attached Files Attached Files

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Dynamic Graphing timeline based on 2 dropdown criteria

    In the attached I've added 4 dynamic named ranges:
    EmpID - Looks at column A on the newly added Sheet2, starts at A2 and ends at the last entered EmpID. As you add/remove EmpIDs this range will automatically grow/shrink to account for that.
    Weeks - Looks at column C on Sheet2 and works in the same way as the above.
    These two named ranges are used to drive the drop down lists in the green cells on Sheet1

    XAxis - Looks at the data in the yellow section (Col K) on Sheet1. Starts at the first date and ends at the last.
    YValues - Same as above but on Col L.

    The yellow section has formulas to display only the relevant dates based on your start and end date selections in the green section. It also has formulas to look up the values for the selected EmpID on each of the relevant dates.

    The chart is then driven by the last two dynamic named ranges so it automatically adjusts dependent on your selections.

    Hope that makes sense. Shout if you have any questions.

    BSB
    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. Macro for Clearing Contents of a Cell Based on Criteria - Graphing Purposes
    By QuintYates in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2017, 03:43 PM
  2. Graphing date changes across a timeline
    By favoritepsalm1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-31-2016, 11:11 PM
  3. Replies: 3
    Last Post: 01-06-2014, 01:22 PM
  4. Urgent: Create a Dynamic Dropdown list based on a specific criteria
    By vijaye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2013, 08:07 AM
  5. [SOLVED] Project Timeline with Dynamic Date Range Based on User Input
    By Rollinstone12 in forum Excel General
    Replies: 2
    Last Post: 10-28-2012, 10:07 AM
  6. Replies: 1
    Last Post: 02-11-2012, 08:24 AM
  7. Dynamic dropdown menu based on two criteria
    By Darsk in forum Excel General
    Replies: 5
    Last Post: 09-18-2011, 05:31 PM

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