Cutting a line in a line chart when data series stops

I have a series like so:

Jan 10
Feb 10
Mar 11
Apr 12
May
Jun
Jul

And so on - the rest of the year is blank. When I draw a line chart for the
full 12 months the series draws a line up to April, then plummets to zero in
May. I want the line to just stop at April. If I use a series as above and
genuine empty cells for the end of the year this ok, but since my May cell
reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
blank cell.

Please help!!

Change your formula to =IF($A11<=$D$17,G11,NA())
--
David Biddulph

"DannyS" <DannyS@discussions.microsoft.com> wrote in message
news:4ACCC806-D571-46B2-817F-D9B08F7B7236@microsoft.com...
>I have a series like so:
>
> Jan 10
> Feb 10
> Mar 11
> Apr 12
> May
> Jun
> Jul
>
> And so on - the rest of the year is blank. When I draw a line chart for
> the
> full 12 months the series draws a line up to April, then plummets to zero
> in
> May. I want the line to just stop at April. If I use a series as above
> and
> genuine empty cells for the end of the year this ok, but since my May cell
> reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
> blank cell.
>
> Please help!!

Thanks David,

That works a treat for everything except area charts - I guess as they stack
they treat the N/As as 0's? Any idfeas for this case?

Much appreciated, Dan

"David Biddulph" wrote:

> Change your formula to =IF($A11<=$D$17,G11,NA())
> --
> David Biddulph
>
> "DannyS" <DannyS@discussions.microsoft.com> wrote in message
> news:4ACCC806-D571-46B2-817F-D9B08F7B7236@microsoft.com...
> >I have a series like so:
> >
> > Jan 10
> > Feb 10
> > Mar 11
> > Apr 12
> > May
> > Jun
> > Jul
> >
> > And so on - the rest of the year is blank. When I draw a line chart for
> > the
> > full 12 months the series draws a line up to April, then plummets to zero
> > in
> > May. I want the line to just stop at April. If I use a series as above
> > and
> > genuine empty cells for the end of the year this ok, but since my May cell
> > reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
> > blank cell.
> >
> > Please help!!
>
>
>