Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Gantt chart looks like this: http://i46.tinypic.com/nlo08p.gif
Dimension: ProjectName
Expression Design Phase: Max (ConstructionStart) - Min (Design Start)
Expression Construction Phase: Max (ConstructionEnd) - Min (ConstructionStart)
My data looks like this: http://i45.tinypic.com/2cgcydu.gif
So what's going on? Design and construction should be staggered. But they're not...?
For the second expression, click on + and enter the first expression as Bar Offset if you want to see the bars one below the other.
Message was edited by: Nagaian Krishnamoorthy
Have you select the Stacked style in style tab of the chart properties?
Could you upload a small sample file or your input data here?
For the second expression, click on + and enter the first expression as Bar Offset if you want to see the bars one below the other.
Message was edited by: Nagaian Krishnamoorthy
Stacked style causes it to look like this: http://i47.tinypic.com/205qg3l.gif
I've attached the Excel sheet I was working on. Or here: http://dl.dropbox.com/u/46307240/Gantt_sample.xlsx
Ahh, that did the trick. I needed to offset 'Construction' by its start date. Thanks! You helped me again.