Excel chart timeline to show process durations over several days

anaish

New Member
Joined
Mar 25, 2015
Messages
1
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 :confused:

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
Joined
May 27, 2011
Messages
993
Hi anaish,

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

Process-Schedule-Gantt-Chart.png


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
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top