I am trying build a Sales vs Year Line chart where I want to show the Sales line continued after the current year as dotted forecast line. I tried the forecast option under 'Axes' but it gives me a separate line and not in continuation with the existing line. Also, I want the forecast line to be dotted. Please help
I think that you will have to create your own least squares regression analysis (or whatever algorythm that you require) to do this in the way that you want (without the dotted lines).
