I have a series like so:

Jan 10,11,13,12
Feb 10,12,13,12
Mar 11,11,13,14
Apr 12,13,13,13
May
Jun
Jul

And so on - the rest of the year is blank. When I draw an area chart for the
full 12 months the series draws an area up to April, then plummets to zero in
May. I want the area to just stop at April. My cells use the formula
=IF($A11<=$D$17,G11,NA()) therefore, the NA stops any line charts goinf
beyond April, but the area chart is more problematic.

Please help!!