Setting the Range Minimum & Maximum Value on a Gantt type chart on the Chart Marco

[C]

Hi

I have a Gantt Chart type chart using the Chart Marco.

I have everything working (almost) and am able to show my project list gantt chart from the Confiform Table Merger.

I can set the Min and Max Value for this gantt chart to specific Dates, but I need it to be dynamic.

I need it to show from 2 months ago to 12 months ahead - but I cant seem to find the correct form to make this work.

For example in excel setting the lower range would be  "=today()-60" 

[Katie Averill]

Try just using this approach: -30d (for a 30 day lookback) and +30d for a 30 day look ahead.