Another option might be to use dynamic names for the series areas, with those
names referring to something like

=OFFSET($C$2,0,0,COUNTIF($C$2:$C$13,"0",1)

where you have some monthly data in C2:C13 that will never be <= 0

On Thu, 27 Jan 2005 09:50:18 +1300, "Rob van Gelder"
wrote:

Excel Charts ignore cells #N/A,
Try putting =NA() into those blank cells.
You should be able to build a solution from there.