+ Reply to Thread
Results 1 to 2 of 2

Downtime chart

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Downtime chart

    Hi All,

    I'm trying to make a chart of machine Uptime and DownTime, I only have start and end times. Here is some example data:

    Please Login or Register  to view this content.
    Where 1 = Uptime and 0 = downtime.

    If I chart this data in excel using area chart this happens:

    temp.png

    The X-axis is giving every entry equal space on the graph, I need to be able to observe the length of time a machine was up or down just from looking at the graph. Also when it goes from 1 to 0 there is a slope and I need a step change as a machine can only be up or down, there is no in between.

    This is mock up using paint of the sort of thing I'm trying to make:

    temp2.png

    Anyone have any ideas?

    Cheers

    Steve

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Downtime chart

    A Scatter Chart with Straight Lines & No Markers will display exactly what you want except that it will just have a line, without the area under the line filled in.

    If you can live without the area then you're done just by changing the chart type. If you really want the shaded area though, then we might have to get a little more creative & that will take more work.

    EDIT:
    For example, Jon Peltier's tutorial on shading under a scatter chart.
    Last edited by ben_hensel; 11-20-2015 at 12:34 PM.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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. Need help calculating Downtime
    By Ben.Cgg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 05:02 PM
  2. Need help in calculating downtime
    By Nitinkumar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2013, 09:58 AM
  3. [SOLVED] Downtime Analysis
    By Edd Win in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-15-2013, 02:59 PM
  4. Excel 2007 : Need help with downtime form
    By sibaumgartner75 in forum Excel General
    Replies: 1
    Last Post: 02-06-2012, 11:12 PM
  5. downtime calculations
    By kents86 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2009, 01:21 PM
  6. [SOLVED] Sumproduct-um the downtime
    By Pete in forum Excel General
    Replies: 2
    Last Post: 02-08-2005, 11:06 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