VBA to make graph but trendline forecast issue

Hi people,

I have been trying to construct a graph from a data range. I used this code

Please Login or Register  to view this content.

The problem is that I cant get the trendline forecast to work. I would appreciate if you can help me find where I making a mistake. Thanks.
If you need a dummy file with the data, i can share that too just let me know.

Best regards,
FNa