Forecasting for price

I am doing price forecasting analysis.
The problem that I faced:

When I compare the forecast price and the actual price, I realize that the forecast price for the month is showed months after in the actual price instead of its current month.
For example:
The forecast price for Jan is RM4.50 and the actual price is RM3.90. Yet, the forecast price in Jan is actually get more nearer to the actual price in November which is 2 moths forward.

I need to move the trend forward instead of backward.

The attachment file can show a better understanding on what i referring to.
Appreciate on all the helps.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



Do not post protected workbooks with sensitive data and personal information.