I am looking to create a Gantt Chart with date/duration data. The setup is that each column header is a milestone, each row is a different project, and the data in between are a mix of dates and durations in order to build the Gantt Chart. I have embedded this chart in SharePoint but was hoping to see if there was a way I could get the dates on the axis bounds to automatically update to a formula (i.e. the minimum would be TODAY-30 days and the maximum would be TODAY+180 days). this way, when the data refreshes, it will update to the most up to day info instead of having to do it manually.
Is there a way to do this? Any ideas?
Is there a way to do this? Any ideas?
