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?


--
Regards,

Steve

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_...ank_Value.html



--
Regards,

Steve


"Kamehameha" wrote:

> 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?
>
>
> --
> Regards,
>
> Steve