Continue Line chart based on a value until 100%

[SajZadeh]

Hi, 

I have the line chart below and we have data until 23 July but I want the graph to continue until 100% based on the previous speed of the graph. 

It will be the prediction of when this will be finished. If you want to see what I mean in excel this is the chart in excel. 

The blue line is the extension line. 

We subtract %Completion of each day with the previous day and the average of all these days will be the average progress speed and I want to continue the line based on that number until it reaches 100%. 

Is there a way that this can be acheived? 

[Rakesh1705 · Accepted solution]

Another way I have just figured out.
Source data

Monthly Progress

Cumulative Progress

Cumulative Actual Progress

Cumulative Forecst Progress

Overall Graph

[Rakesh1705]

Hi you need to align the actual and forecast line in a single line. its possible. I am sharing my youtube video link

https://www.youtube.com/watch?v=hNU6M1yjz80&t=11s
also you can refer my S-Curve Playlist for the same.