+ Reply to Thread
Results 1 to 3 of 3

Plot between 2 dates (finds data)

  1. #1
    Registered User
    Join Date
    02-22-2014
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    16

    Plot between 2 dates (finds data)

    Hello,
    I am making an issue logger which counts the current cumulative number of open and closed tickets.
    The user enters an open date and a closed date.
    I'd like to enter 2 dates and have excel look through my table and plot the number of open (columnG) and closed (columnF) tickets between those dates.
    Essentially, the from and to date would be the x axis range.

    Currently, if the user wanted to plot between 04/10/19 and 08/10/19, the start value would be 2 closed and 1 open.
    I'd also like the option to reset the counter for the selected period only (i am thinking this could be done by adding 2 more columns and using an offset/match/index to the from and to date and subtract from F and G).

    Thanks
    Last edited by kryssie.e; 10-14-2019 at 08:18 AM.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Plot between 2 dates (finds data)

    Please update your profile with the Excel version you are using: your profile currently states Excel 2003, but you've attached a .xlsx file, which indicates 2007 or later. There may be different solutions available for your problem, based on the actual version you are using.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    02-22-2014
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    16

    Re: Plot between 2 dates (finds data)

    Hi thanks for pointing this out - 2016 (updated now)

+ 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] Skipping dates have blank values and plot remaining dates.
    By Sekars in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2016, 11:15 AM
  2. [SOLVED] I need a formula that finds specific dates and adds up all the totals for each date
    By skip2mylew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2013, 10:43 PM
  3. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  4. [SOLVED] using checkboxes to plot certain data series on one plot
    By chemeng1T3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 07:08 AM
  5. How can I plot multiple data set on a single contour plot
    By hafziebone in forum Excel General
    Replies: 0
    Last Post: 02-11-2012, 02:02 PM
  6. How can I plot multiple data set on a single contour plot
    By hafziebone in forum Excel General
    Replies: 0
    Last Post: 02-10-2012, 11:27 PM
  7. Can I copy x-y scatter plot data direct from one plot to another?
    By Chris in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2005, 09:05 AM

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