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.

Oliver Salzburg
  • 86,445
  • 63
  • 260
  • 306
adolf garlic
  • 2,007
  • 12
  • 37
  • 49

3 Answers3

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
  • 121
  • 4
  • It will be 2007 that we're using then. Sorry for the confusion. – adolf garlic Feb 25 '11 at 10:32
  • 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 Feb 25 '11 at 10:40
  • "Strips off all the other tasks" - what do you mean by this? – Ryan Feb 28 '11 at 08:22
1

  1. Make a calculated field that returns the max of whatever field tracks the task start date and today.

  2. 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.

jonsca
  • 4,077
  • 15
  • 35
  • 47
Gary Tomlinson
  • 11
  • 1
-1

The suggested solution with calculated column will not work, as calculated columns can't be used in Gannt view. View based on the proposed solution returns no start date at all.

The only working scenario seems to be the usage of scroll to date script in content editor WP.

Stan
  • 1
  • 1
    It would be better to add details from the link. Link only answers are discouraged – Dave M Jan 11 '21 at 13:07
  • 1
    Welcome to Super User! Please quote the essential parts of the answer from the reference link(s), as the answer can become invalid if the linked page(s) change. – DavidPostill Jan 11 '21 at 13:11