Downtime time line

[klesqus]

Hi,

I have been thinking for some time now about making a downtime tracking timeline in a form of a line graph. The x axis would be time and y axis would be different stations (max of about 25 unique stations). Downtime would be represented as a vertical line. I have a data sheet with start time, end time, unique station identifier and duration in seconds. I have been trying to find some sort of solution or where to start using web search but no luck. I am not sure if this is possible but can anyone help?

Thanks in advance.

Attached a small data sample.

 

[etaf]

i'm struggling visualising the Vertical Lines - Horizontal yes from each Station and total downtime
Are all the Alarm conditions classed as downtime
Rather than an image can you use the XL2BB Add-in or add a sample sheet to a share like dropbox/onedrive or googlesheets
I dont see the Station ID

But as I say - I'm not sure how a vertical line with a Vertical Axis "Y" , would work with all the different Stations and time horizontally "X" Axis
Maybe even a rough sketch of the chart and posted here

 

[klesqus]

Sorry I've made a mistake yeah the lines were supposed to be horizontal. All the alarms listed there are stop conditions sometimes they are different type, at the moment I am not worried about the type just need to focus on downtime. I've added a column with station ID.

Example worksheet:

sample.xlsm

drive.google.com

I do realize the graph will be massive (especially for 9hrs shift) but I was wondering if I can put a filter and track it hour by hour.

Thanks for reply.