Type =NA() in the empty cell; they show as #N/A
The chart engine ignores them.
best wishes

Signature
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
> Hello
>
[quoted text clipped - 6 lines]
>
> Kind regards
Igor - 18 May 2008 18:06 GMT
Thank you. It is just what I wanted.
> Type =NA() in the empty cell; they show as #N/A
> The chart engine ignores them.
[quoted text clipped - 9 lines]
>>
>> Kind regards