+ Reply to Thread
Results 1 to 1 of 1

Time/Date Graph

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    Roanoke, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    53

    Time/Date Graph

    Ok guys, unfortunately I have fallen rough in my memory on how to really graph things anymore. Attached in the excel in question. Here is the description of what each column is:

    A: Start Date - this is the date the test was initially executed
    B: SLA - This is when the test need to finish by
    C: This is taking the SLA and adding the Aging time to it (Currently this is manually being done, I can't get the formula to actually line it up correctly because of the timing explained further down)
    D: Aging - This is when the test completed (This is tricky because it's in military time for example 4:33 means 4:33 AM the day after the test started, therefore 23:46:00 means it actually finished before midnight the day it was started)
    E: Variance - I was attempting to show the time it took compared to the SLA, obviously I'm running into an issue with the variance as you cannot have a negative time, so something that finished before midnight, it showing the same as something that finished after the SLA deadline.

    The objective is to be able to track changes that are being done to the data of the test, in theory, the SLA will always be 7 AM the following morning, but the goal is to have the test finish as soon as possible. The further down the data you get, the better our timing is getting as it actually finished before midnight once. I'm trying to come up with the best way to graphically represent this data. I thought a line graph showing the data point would be the best, with the middle line being the SLA (7:00 AM). I am open to suggestions if there is a better way to set up the data or configure the graph.

    Objectives: Automate Column C and provide a graphical representation of the data.

    Thank you in advance!

    -Sean
    Attached Files Attached Files

+ 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. Time and date graph
    By acoron01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-21-2014, 03:59 PM
  2. graph axes (time and date)
    By talkative__ in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-16-2013, 05:58 AM
  3. VBA code to plot date and time on Xaxis of scatter graph
    By Balachan56 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-14-2011, 11:13 AM
  4. Time Date and Graph help (complex formula)
    By mrbadss in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-21-2009, 07:54 AM
  5. using date & time in the x axis of a graph
    By sjhonny in forum Excel General
    Replies: 2
    Last Post: 01-18-2007, 09:39 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