Forecast 'S Curve' with only Start & Finish Values over a Given Time Period

[simondb]

Hi, please help. I'm not sure if this is even possible.
I am trying to create an "S Curve" chart as a predicted forecast. The only data I have is Years to go on the X Axis and "Start / Finish" values for the Y Axis.

X Axis	Y Axis
2022	0
2023
2024
2025
2026
2027
2028	150000

Many thanks, Simon

 

[JamesCanale]

I don't know at all if this is what you need. This is a normal distribution. The standard deviation has to be in there somewhere, so I put in a "Standard Deviation Factor" which changes the S-iness of the output.

MrExcelPlayground6.xlsx
	A	B
1	2022	$ -
2	2023	$ 7,169
3	2024	$ 30,349
4	2025	$ 75,000
5	2026	$ 119,651
6	2027	$ 142,831
7	2028	$ 150,000
8
9	SD factor	5
Sheet18

Cell Formulas
Range	Formula
B2:B6	B2	=B1+NORM.DIST(A2:A6,AVERAGE(A1,A7),(A7-A1)/B9,TRUE)*(B7-B1)
Dynamic array formulas.

 

[simondb]

Thank you