+ Reply to Thread
Results 1 to 3 of 3

Dynamic Date Range for a line graph

  1. #1
    Registered User
    Join Date
    08-13-2015
    Location
    Houston, Texas
    MS-Off Ver
    2010
    Posts
    61

    Angry Dynamic Date Range for a line graph

    Excel Gurus and Gods,

    I need help with a problem I have in regards to a graph I created in excel. What I am trying to do is be able to customize the date range... The current table contains data from 1/2009 - 2/2018... Currently, If I wanted to see the graph from periods 1/2017 - 2/2018 then I would have to go to select data and change the range of the data. Is there an easier/user friendly way to do this?

    Please see attached file.
    Attached Files Attached Files

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

    Re: Dynamic Date Range for a line graph

    I would use filters for this:

    1) Make a transposed copy of the table, so that dates are in the leftmost column. Base chart on transposed table.
    2) Set up the autofilter on the transposed table. https://www.wikihow.com/Use-AutoFilter-in-MS-Excel
    2a) In the "date" dropdown, select Date Filters -> Between -> Fill in start and end dates.
    3) As data are hidden in the table, the data will be hidden in the chart (if not, check the "hidden and empty cells" setting the source data dialog).

    From there, everything is controlled by the filter settings/dropdowns.

    Is that a workable solution?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    293

    Re: Dynamic Date Range for a line graph

    Just added some input fields and defined 2 named ranges with dynamic offset formulas.
    Could this work for you ?
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ 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] Dynamic Interactive Line Graph
    By takeawalkk in forum Excel General
    Replies: 2
    Last Post: 08-24-2017, 02:49 PM
  2. how to make line graph dynamic based on date ranges?
    By mikey42979 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-09-2016, 03:33 PM
  3. Line Graph question - vetical line values at one fixed date
    By bohn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2015, 02:22 PM
  4. [SOLVED] Dynamic line graph
    By AndrewBondarchuk in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-03-2013, 01:28 PM
  5. Excel 2007 : Dynamic Line Graph with Non-Contiguous Range
    By amy_boogada in forum Excel General
    Replies: 1
    Last Post: 07-14-2012, 06:58 AM
  6. Building a dynamic Line graph in Excel via VBA
    By Philman in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-20-2012, 04:41 PM
  7. Replies: 6
    Last Post: 01-25-2006, 02:45 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