Automatic rolling dates in an embedded chart

khilly

New Member
Joined
Jan 5, 2017
Messages
1
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?
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,109,011
Messages
5,526,263
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top