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
SamD
138
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