I want to display the duration of my projects in a chart using the dates (quarters). I tried using the date data but the chart does not display the way I want. I was able to display the data using the actual duration data but that doesn't map to the quarters. Can you please let me know how I need to setup the data to have the dates as the hortizonal axis? Thanks in advance! This is the data the chart is based on.ResourcesProject NameFeasabilityInitiationProgramming & SD PhaseAuthorizationDD & CD PhaseConstructionApprovalMary Jones Jackson Library 7752382020962720 Macon GA Court House77253209383720 LA Center 2574392033999720 NYC 5th Avenue701753872036962520 Keller Museum701753872036962520 Kevin DeMichel CUBs Stadium 722132016542020 Dan Mitchell Newark DE Library 3563032025664420 John Daily Sears Tower100100100100100100100 This is the RAW data:ProjectResourceActivity NameStartFinishOriginal DurationJackson LibraryKevin DeMichelFeasability27-Nov-1720-Aug-180Initiation17-Aug-1820-Nov-20775Programming & SD Phase20-Nov-2019-Dec-20238Authorization19-Dec-2023-Sep-2220DD & CD Phase7-Oct-2213-Oct-25209Approval1-May-2326-May-23627Construction30-May-2330-May-2320CUBs StadiumChristina MarzoccaFeasability27-Nov-1720-Aug-18 Initiation15-Aug-1829-Jun-20 Programming & SD Phase29-Jun-2027-Jul-20 Authorization27-Jul-2023-May-22 DD & CD Phase9-Feb-224-Jun-25 Approval1-May-2326-May-23 Construction30-May-2330-May-23 Newark DE LibraryDan MitchellFeasability27-Apr-2012-Aug-24 Initiation27-Apr-205-Jul-21 Programming & SD Phase5-Jul-2123-May-22 Authorization23-May-2217-Jun-22 DD & CD Phase17-Jun-2226-May-23 Approval29-May-2326-Jun-23 Construction31-May-2312-Aug-24

E_Buck2010 Use the start date as first series, but make its bars transparent. Simplified example: Workbook attached

E_Buck2010

Copper Contributor

Jun 02, 2023

Solved

How do I display duration data in a Stacked Bar Chart using dates?

I want to display the duration of my projects in a chart using the dates (quarters). I tried using the date data but the chart does not display the way I want. I was able to display the data using the actual duration data but that doesn't map to the quarters.

Can you please let me know how I need to setup the data to have the dates as the hortizonal axis?

Thanks in advance!

This is the data the chart is based on.

Resources	Project Name	Feasability	Initiation	Programming & SD Phase	Authorization	DD & CD Phase	Construction	Approval
Mary Jones
	Jackson Library		775	238	20	209	627	20
	Macon GA Court House	772	53	20	93	837	20
	LA Center		257	439	20	339	997	20
	NYC 5th Avenue	70	175	387	20	369	625	20
	Keller Museum	70	175	387	20	369	625	20

Kevin DeMichel
	CUBs Stadium		72	213	20	165	420	20

Dan Mitchell
	Newark DE Library		356	303	20	256	644	20

John Daily
	Sears Tower	100	100	100	100	100	100	100

This is the RAW data:

Project	Resource	Activity Name	Start	Finish	Original Duration
Jackson Library	Kevin DeMichel	Feasability	27-Nov-17	20-Aug-18	0
Initiation	17-Aug-18	20-Nov-20	775
Programming & SD Phase	20-Nov-20	19-Dec-20	238
Authorization	19-Dec-20	23-Sep-22	20
DD & CD Phase	7-Oct-22	13-Oct-25	209
Approval	1-May-23	26-May-23	627
Construction	30-May-23	30-May-23	20
CUBs Stadium	Christina Marzocca	Feasability	27-Nov-17	20-Aug-18
Initiation	15-Aug-18	29-Jun-20
Programming & SD Phase	29-Jun-20	27-Jul-20
Authorization	27-Jul-20	23-May-22
DD & CD Phase	9-Feb-22	4-Jun-25
Approval	1-May-23	26-May-23
Construction	30-May-23	30-May-23
Newark DE Library	Dan Mitchell	Feasability	27-Apr-20	12-Aug-24
Initiation	27-Apr-20	5-Jul-21
Programming & SD Phase	5-Jul-21	23-May-22
Authorization	23-May-22	17-Jun-22
DD & CD Phase	17-Jun-22	26-May-23
Approval	29-May-23	26-Jun-23
Construction	31-May-23	12-Aug-24

BI & Data Analysis

excel

HansVogelaar
Jun 02, 2023
E_Buck2010

Use the start date as first series, but make its bars transparent. Simplified example:

Workbook attached
Gantt.xlsx14 KB

Forum Discussion

How do I display duration data in a Stacked Bar Chart using dates?

Share

Resources