+ Reply to Thread
Results 1 to 2 of 2

Trying to produce line graph showing raised vs closed

  1. #1
    Registered User
    Join Date
    12-21-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Trying to produce line graph showing raised vs closed

    Hi,

    I hope you can help, I've been googling on solutions for this for ages. There are 2 things I'd like to achieve, with the first one being more important for now.

    1) I'm trying to produce a line graph showing open vs resolved (month by month), I can currently only get it to show me which were opened and closed in same month. An Example of data below:

    Incident ref Opened date Resolved date
    12345 01/01/20 05/01/20
    23456 01/01/20 25/02/20

    2) In order to add a third data line named "Open", in the example above, I would want the first item to show as being closed by the end of January, so wouldn't show as a result. The 2nd option would however, as it was open well into the following month.

    I hope this all makes sense and that someone can help
    Last edited by D4WNO77; 10-18-2020 at 02:12 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Trying to produce line graph showing raised vs closed

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    If you are not permitted to post links then try to post the URL without the preceding "https://". If you have trouble PM me.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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: 2
    Last Post: 08-01-2017, 06:16 AM
  2. Line Graph Showing Two Revenue Streams on the same line
    By Cowboys9 in forum Excel General
    Replies: 0
    Last Post: 08-12-2013, 11:23 AM
  3. [SOLVED] How do you line graph in excel 2007 showing a particular type of weekly data?
    By Sebastianebilly in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-30-2013, 05:08 AM
  4. Replies: 1
    Last Post: 02-18-2012, 03:20 AM
  5. Line Graph showing wrong data
    By kevin2184 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-01-2011, 10:59 AM
  6. Showing average on line graph
    By Gadgetman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2007, 04:46 PM
  7. [SOLVED] charting a single bar graph on one line showing continuous info
    By Debidjew in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-10-2006, 11:20 AM

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