Time Line Chart

[#1]

I have to make this chart with the following data available.

Time Frame	Current Month Start Date	Current Month Last Date	Previous Month Start Date	Previous Month End Date
3 Months Vs 3 Months	12/1/2011	2/1/2012	9/1/2011	11/1/2011
6 Months Vs 6 Months	9/1/2011	2/1/2012	3/1/2011	8/1/2011
12 Months Vs 12 Months	3/1/2011	2/1/2012	3/1/2010	2/1/2011
Baseline Vs SPTD	1/1/2012	2/1/2012	4/1/2011	9/1/2011

How can i make this. I am really struggling to make this. Can anyone please attach a sample qvw file after making this. I will really be obliged.

Dates are in MM/DD/YYYY format

[hic · Accepted solution]

You can make a Gantt chart by using the expression attribute "Bar Offset".

HIC

[#3]

Hi Henric,

Its working. But i want to get Month name instead of Dates. How may i do that ??

[hic]

In the properties of the chart, under "Number", I have set the format of the axis to M/D/YYYY.

Change this to 'MMM YYYY'.

HIC

[#5]

Thank you Henric. It works