Time Series Chart

[Anonymous]

Hi All,

I have a requirement where i need to represent a single project details on a chart as shown in the attached image.

The Project details gets updated every week.It has the below Details.

ProjectName

Start Date

End Date

Phase End Date

Release Date

Quarter

Reload Date

As the details are getting updated weekly, Due to some reasons The Phase End Date or Release Date or Quarter may change than the actual dates.

Now the requirement is to create a bar which indicates the duration of the project(Similar to Gantt) and also if there is change in the Phase End Date or Release Date or Quarter then a marker should be placed on the bar indicating that the value has been changed on this paricular Reload date.

I have the same solution for these in 2 seperate charts i.e. one chart indicating the Project duaration and one more chart that shows the date on which the Date fields have changed.

But I m not able to show both the things in the same chart.Could anyone help in doing this?

Thanks in Advance

[Anonymous]

HI Experts,

Any idea how we can achieve this?

[Jason_Michaelides]

Can you provide some example data?

[Anonymous]

Here is the Sample Data:

Project Name	Reload Date	Release Date	Quarter	Phase End Date
ABCD	24/07/2014	0	0	0
ABCD	25/07/2014	0	0	0
ABCD	29/07/2014	0	0	0
ABCD	04/08/2014	0	0	0
ABCD	11/08/2014	0	0	0
ABCD	18/08/2014	0	0	0
ABCD	25/08/2014	0	0	1
ABCD	01/09/2014	0	0	1
ABCD	08/09/2014	0	0	0
ABCD	15/09/2014	0	1	0
ABCD	19/09/2014	0	0	1
ABCD	30/09/2014	1	0	1
Start Date of the project	27/05/2014
End Date of the project	15/01/2015

if u see the image the grey color bar:is based on the Start Date and End Date

and

the thin bars is based should be shown wherever the Release Date or Quarter or Phase End Date is 1.