Forum Discussion
Difficulty extending the trend line to the bottom of a graph
So i have a graph with a trendline. I want to extend this trendline to the bottom of the chart, but when i change the forward period, it shifts everything upwards. I've attached images of before and ...
When it comes to BI & Data Analysis, I'm not the big one (to put it mildly).
But I'm not so sure, as far as I can remember, with earlier Excel versions,
you could simply select the “Options” window under “Format trend line” and select “Trend forward”.
This information without guarantee, I have not tried it myself beforehand.
If I'm wrong, one of the community residents will surely correct me:).
Of course, knowing the Excel version and the OS helps to convey more precise information.
Hope I could help you.
Nikolino
I know that I know nothing (Socrates)