+ Reply to Thread
Results 1 to 4 of 4

Step chart with uptime and downtime

  1. #1
    Registered User
    Join Date
    04-02-2019
    Location
    California
    MS-Off Ver
    Office Pro 2016
    Posts
    16

    Step chart with uptime and downtime

    Hello I am trying to find a way to make an uptime/downtime step chart. Its binary, basically ON for X days, OFF for Y days and trying to turn it all into one long linear line like the image below and attached. Any ideas?
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by ripcurlksm; 03-31-2020 at 08:47 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,194

    Re: Step chart with uptime and downtime

    This isn't exactly the same, however perhaps it will help.
    Following the instructions of the linked article below, the following were added
    1. The format of the data is changed as modeled in A7:B12 on Sheet 2.
    2. The formula for C7:C12 is: =SUM(C6,B7)
    3. The formula for D7:D12 is: =IF(RIGHT(A7,2)="up",1,0)
    4. C13:D18 as well as columns E:F are assignments (i.e. for C13: =C7)
    5. Columns G:H are pasted (paste special values after the cells were deleted as per the article)
    6. The horizontal axis was modified so that the minimum is 1/1/1900
    7. A horizontal axis title, Day #, is added
    8. The vertical axis is deleted and the axis title, Down Up, is added (spaces are intentional).
    https://www.tutorialspoint.com/advan...step_chart.htm
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    04-02-2019
    Location
    California
    MS-Off Ver
    Office Pro 2016
    Posts
    16

    Re: Step chart with uptime and downtime

    Thank you!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,194

    Re: Step chart with uptime and downtime

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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: 1
    Last Post: 07-11-2019, 12:52 PM
  2. Server Uptime/Downtime Calculation
    By rovert.natsud in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2018, 12:28 PM
  3. Convert server downtime to Uptime in Hours for whole month
    By AsuraSinX in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-29-2016, 09:07 PM
  4. Downtime chart
    By megamef in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-20-2015, 12:32 PM
  5. [SOLVED] Stock Chart apparence is different if Macro1 runs step by step not directly !
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-23-2014, 04:31 AM
  6. ~ Need Step-by-step Guide on How To Create A Chart ~
    By exceltoohard in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2013, 01:04 AM
  7. Help with creating uptime/downtime calculation/analysis
    By buerm009 in forum Excel General
    Replies: 0
    Last Post: 02-19-2013, 02:24 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