+ Reply to Thread
Results 1 to 2 of 2

Create a dynamic chart with a start and finish date in two cells

  1. #1
    Forum Contributor
    Join Date
    05-01-2015
    Location
    Kent, England
    MS-Off Ver
    2013
    Posts
    148

    Create a dynamic chart with a start and finish date in two cells

    Good Morning All

    I want to place a start date in a cell and an end date in another and create a chart with the data between those dates. There are a number of items that will be on the variation chart and i was looking at using a dynamic index method but i am struggling to get my head around how i would do it. I need to be able to input a start date and then a finish date and it to select the relevant data to create my variation chart. will i need to index and match between the two dates? My date range is located in column AD starting AD2
    Is there an easy way to do this?

    Capture.JPG

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Create a dynamic chart with a start and finish date in two cells

    you can either setup data specific for the chart to read
    ie use index/match or vlookup to only pull data in where its needed


    or

    set up name range, offset via formulas
    like so
    http://www.criticaltosuccess.com/dyn...-named-ranges/

    or use VBA
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 7
    Last Post: 06-12-2018, 11:42 AM
  2. Does a task start or finish date fall within 3 month range of a specific date
    By jamesmcgallan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2015, 07:46 AM
  3. [SOLVED] Return start and finish date
    By kaypump in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2014, 12:43 PM
  4. Gantt chart showing Start and Finish Date
    By scottiebell in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-21-2014, 04:46 PM
  5. Replies: 2
    Last Post: 04-01-2010, 07:31 PM
  6. Start and Finish Date
    By Hippychic in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2007, 11:36 AM
  7. [SOLVED] How do I chart date ranges with varying start and finish dates?
    By projectplanner in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2005, 07:06 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