Line in Line Chart to be extended for a Value on y Axis and a missing date in X-axis

[SamDsouza]

Hello

Any simplest method to extend the line in line chart where there is missing date but value of Amount is given. So Approximation of missing date Date value is found.
So a line to be extended in line chart where value 200000 is displayed. Considering Period of Dates are not fixed and Amounts are too not fixed.
The below range selected and chart was inserted Date on X-Axis and Amount on Y-Axis

	A	B	C
1		01-01-2020	5000.00
2		25-02-2020	25000.00
3		09-04-2020	122000.00
4		15-04-2020	42000.00
5		27-08-2020	48000.00
6		25-12-2020	70000.00
7		07-02-2021	98000.00
8			200000.00
9
10

SamD
138

 

[mole999]

If you are estiating you could just insert any aprox valid date until the actual is known. as it stands there is no obvious progression on these presented dates 55.44.6.134.120.44

 

[SamDsouza]

Thank you Mole999

If you are estiating you could just insert any aprox valid date until the actual is known. as it stands there is no obvious progression on these presented dates 55.44.6.134.120.44

estiating I suppose a typo error for Estimating
55.44.6.134.120.44 there is no obvious progression means the no(s) of days.

Do you mean that i need to fix dates of each month ? So that missing date is found.
What if there +/- days near to date and can still a missing date be found ?

But as per post#1 That was my First time incorporating a line Graph or rather using a graph on a worksheet

Sorry but don't mind basic doubts may crop up.

SamD
139