Any way to make line chart show null data points?

[Kamehameha]

The subject titles doesn't really explain this - I saw a similar subject to
this on this forum yesterday and now I can't find it.

I have a line chart, it doesn't matter how many series I have but I'm
plotting lets say one series over 52 weeks of the year.

If the data for the series stops before the end of the 52 weeks, I would
like the line to stop. This works if I clear the contents of the cell (which
I can do via macro but don't really want to, it's a big spreadsheet, lots of
data to crunch to get to my final graph.) As others have said on the forum,
if I get the formulas in the series range to return either #VALUE! or #ERROR!
or #N/A or FALSE then that doesn't replicate having a clear cell.

Is there no way to do this or is a macro my only choice?

 

[Kamehameha]

I think the answer to this is actually that there is no way to do this:

This article makes sense of it.

http://excel.tips.net/Pages/T002814_Returning_a_Blank_Value.html