Graph

[Maddy]

Hello Mentors,

I'm working on a project for work and I really need help on this part.

I have a data set with two columns, the start time and end time of a machine.


I want to show graph start time and end time process wise and gap in starting of one process to another


Please guide me.

Best
Maddy

 

[Luke M]

Calculate duration, and then do a stacked bar chart using Start time and duration. Format the Start time series so that the duration bars appear to be floating.

With your example data, I'm assuming Branch was supposed to go from 11 am to 1 pm (you had till 1 am).

The processes don't appear to be in order, but you could sort it if you want.

 

[Maddy]

Calculate duration, and then do a stacked bar chart using Start time and duration. Format the Start time series so that the duration bars appear to be floating.

With your example data, I'm assuming Branch was supposed to go from 11 am to 1 pm (you had till 1 am).

The processes don't appear to be in order, but you could sort it if you want.

thanks for the response. Is it not possible to show the start time and end time alone in stacked bar ?

 

[vletm]

Maddy
Something like this based Your given data?

 

[Luke M]

thanks for the response. Is it not possible to show the start time and end time alone in stacked bar ?

I'm not sure what you mean. If you have all the literal numbers on the chart, then you didn't need a chart. Could just do a data table.

 

[Peter Bartholomew]

It is also possible to use a scatter chart with error bars used to represent time intervals.