Pivot Chart & Null Value

[sailcm]

I am having a problem with the pivot chart and a Null value. In the query,
the value is null - as there is no data for a certain group. The pivot chart
is plotting a zero. Does anyone know how to correct this?

Example:
Group A 3%
Group B No data
Group C 2%

Thanks.