Moving average line continues after data stops

[yowzadave]

I put together a little spreadsheet to help with weight loss--it tracks weight, along with a 5-day moving average and a goal line. For some reason, even though my "5-day average" data set shows no value for the days for which there is no value, the chart is plotting it as 0.

Is there any way to make the line end where the data stops?

I've attached an image of the way it looks on my screen, along with the spreadsheet.

Thanks!

[zbor]

Try this: Instead of
=IF(B6=""; ""; AVERAGE(B2:B6))
write this formula
=IF(B6=""; NA(); AVERAGE(B2:B6))

And extend down...

If it's ugly for you to see #N/A try to solve it with conditional formating