You cannot get a chart to treat 0 as anything but 0. You can have a chart
ignore missing data. In the missing cell enter =NA(); this could be part of
a formula =IF(whatever, somevalue, NA())
You can also, with the chart selected, use Tool|Option|Chart to tell Excel
how to treat missing values.
Hope this helps
Bernard
