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?