A quick way: Select your data and drag the fill handle (in the bottom right
corner of the selection) across to fill the blanks.

Otherwise use formulas like: =TREND(B2:E2,,5)

Both methods should agree and lie on the chart trendline.


"Denver" wrote:

Hi,
Jan3-8 Jan10-15 Jan17-22 Jan24-29
Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7
RcvdRL 6728 6732 7462 9034

I have this data in my excel, I want to make a forecast out of this data
in three weeks period.

I want to know what is my X, my Known_y's and known_x's? I'm not really
familiar
of any excel forecast fomula.

I appreciate for any help

thanks