Need to hide null value bar on a stacked bar chart

[pl1101]

I have a report that I need to create a stacked bar chart. The chart appears to work correctly except I have a bar that totals my null values. I need to hide that bar. Does anyone know how to do that. I am using Crystal reports 2008. Against an Oracle database. The chart uses a formula field that takes the total and subtracts a distinct count. One of the bars is the total of null values. I can't filter the report on the nulls because I need them for the total count.

Help please.

 

[lbass]

Please explain how the chart is set up in the chart expert and show the contents of your formula. What exactly is the "total" of null values? A count? Or are there labels that are identifying a zero result?

-LB