Results 1 to 4 of 4

Dynamic Graphing timeline based on 2 dropdown criteria

Threaded View

  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.

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