How to Plot a Horizontal Stacked Bar Chart with Duration

[David Ku]

Hi Gurus,

I am trying to plot a chart in this format based on the data set I have.
Have been changing the X and Y axis and change the layout, no luck getting it right.

I suspect that I need to reproduce the data set in another format for Excel charting purpose.

Hope you can provide me some ideas on how to achieve it. Thanks.

Sample data :

Company,Product,StartDate,EndDate,Duration (Days)
C1,P1,01/05/2014 11:21,01/05/2014 16:56,0.23
C1,P2,01/05/2014 17:13,01/05/2014 22:07,0.20
C1,P3,02/05/2014 15:04,02/05/2014 19:56,0.20
C1,P4,03/05/2014 09:01,03/05/2014 14:22,0.22
C1,P5,04/05/2014 00:09,04/05/2014 00:11,0.00
C1,P6,04/05/2014 00:11,04/05/2014 09:00,0.37
C2,P7,04/05/2014 18:53,05/05/2014 00:03,0.22
C2,P8,05/05/2014 01:39,05/05/2014 10:35,0.37
C2,P9,05/05/2014 10:38,05/05/2014 17:53,0.30
C2,P10,05/05/2014 17:55,06/05/2014 05:35,0.49

 

[Faseeh]

Hi @David Ku

Welcome to the forums, can you upload a the sample xl sheet for making this chart?

 

[David Ku]

Hi Faseeh,

Sample file attached. I believe I might need to create another column to "push" the value for duration out.
Only problem is, I am not sure what additional column I need to create and how to assign the X and Y axis and series accordingly.

Will go through all the tutorials on this site to learn more.

Sorry, I am still a beginner in charting. Hope can provide some advice. Thanks.

 

[Faseeh]

HI @David Ku,

Please see sheet2 of this workbook

 

[David Ku]

Hi Faseeh, thanks for your effort but it is not a chart.

 

[Faseeh]

Hi @David Ku

Yes, because there is a problem. We can plot dates on x axis and the point on y axis, but there will still be issue in marking C1,C2,...on Y-Axis, even if i do something to mark it like, Labeling P1, P2... will remain a problem. Let me give it another try.

 

[Faseeh]

Please see sheet3