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?
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?
Last edited by ripcurlksm; 03-31-2020 at 08:47 PM.
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.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks