trendlines and dimensions

[anonymous1]

hi guys, 

i have a question regarding a forecasting chart.  I have a line chart that is forecasting future shipments, however i was wondering if there is some sort of method/expression that i could use to dynamically extend the y-axis dimension?

so the data i have imported only goes as far as august2019, however, when the trendline has been applied it extends off the chart with no y-axis applied to it. 

x-axis is sum(shipments), y-axis is master calendar showing monthyear.

any ideas on how to amend the dimension this from happening? 

[Lisa_P · Accepted solution]

On the Axes tab in the properties for the Dimension Axis Select the Forecast and in the expression box add either an expression or a fixed number to extend the axis by