# Excel chart timeline to show process durations over several days

#### anaish

##### New Member
Hi I am looking for a bit of help on a graphical representation of some processes over a 15 hour period for a 2 day sample period ( I will extend this out further , when resolved)

The end user when looking at this data should easily be able to see:
- how long each process took for each of the days, as well as
-how much latency there is between the processes

On the x axis I am looking for the time, starting at 8pm and ending at say 11am the next day, the x axis can simply just have a scale of 15 hours

On the y axis I want the calendar day. 9th and 10th of February

The visual graph of the data then needs to show the duration of these processes including any latency between at the correct point on the x axis ( i.e. start and end time) 24 hour format in data below
The data is linked to the day that it started on i.e. process A

Please refer to the table below over which has 2 days worth of data for 4 processes run each day
I did have a play around with pivot charts etc. but struggled to get a representation that I liked

Many thanks to any Excel gurus out there who can help

Date System Start time End time Duration
9-Feb A 20:00 23:00 3:00
9-Feb B 0:27 2:48 2:21
9-Feb C 4:30 6:00 1:30
9-Feb D 7:30 9:46 2:16
10-Feb A 20:00 23:00 3:00
10-Feb B 0:19 3:07 2:48
10-Feb C 3:05 4:50 1:45
10-Feb D 7:30 9:42 2:12

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### Steve=True

##### Well-known Member
Hi anaish,

Here is a picture of how you will need to set up your data.

1) Make a Stacked Bar Chart
2) Change Fill of Start Date/Time series to No Fill
3) Reverse the Vertical Axis
4) Row 13 is (process 1 start date + time)
5) Row 14 is the process 1 duration
6) Row 15 is the difference between (process 2 start date + time) - (Process 1 start date + time) - (Process 1 duration)
7) Row 16 is the process 2 duration

Steve=True

Replies
1
Views
110
Replies
3
Views
553
Replies
0
Views
70
Replies
1
Views
350
Replies
1
Views
60

1,137,113
Messages
5,679,701
Members
419,850
Latest member
Cbell07958

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back