Excel Point Plotting

Hello Shorty,

thanks for your reply. Yes I did presume using excel linear forecast function to forecast the values, but
I want those values plotted not only based on the past values but by also taking into consideration the
end value.

Otherwise, the values from 2022 to 2029 would show a subtle change and there would be spike because of the
end value for year 2030 which would be a bigger value.

I also tried using trendline and adjusting it such that it intersects the end point i.e value at 2030 but then
it is very difficult to estimate exact values of the points on the curve manually.

Would you have any other better ideas for this problem?