1
I have a gantt chart which always defaults to the start of the first bar (earliest point in time)
This is very annoying in our dashboard as I can't see where we are on this i.e. it should be dynamic based on the current date
Is there any way to change the view to have it move to show that?
I think it's sharepoint 2003 we're using.
adolf garlic
Posted 2011-02-22T08:59:24.553
Reputation: 1 618
1
There isn't a Gantt chart in SharePoint 2003 so I am assuming you are using 2007/2010.
What you can do is setup a filter to show only items where
End Date >= [Today]
and then base your Gantt chart on that.
Note - using End Date as otherwise if you had a task that started yesterday, but finished in a weeks time then it would not show 'today'
Otherwise if this doesn't work for you there are 3rd party products that allow you to have more control over the chart - cough, blatant plug, cough such as Planner.
Ryan
Posted 2011-02-22T08:59:24.553
Reputation: 111
1
Make a calculated field that returns the max of whatever field tracks the task start date and today.
Set this calculated field as the start date for the Gantt chart view.
Tasks that start in the future will have their bars start at a future date. Tasks that start in the past will all show a minimum value of today.
Gary Tomlinson
Posted 2011-02-22T08:59:24.553
Reputation: 11
It will be 2007 that we're using then. Sorry for the confusion. – adolf garlic – 2011-02-25T10:32:40.077
I tried your suggestion which moves the view closer to where 'today' is but it strips off all the other tasks which is somewhat confusing. Alas I don't have control over the MOSS box so I wouldn't be able to implement anything like that. – adolf garlic – 2011-02-25T10:40:20.610
"Strips off all the other tasks" - what do you mean by this? – Ryan – 2011-02-28T08:22:56.430