Pivot Table ... Suppress "0" Values?

[Ken]

Excel2003 ... This is a repost from 09/02/09 (I had no responses?)

Pivot Table ... Some Data Fields return a "Blank"
Pivot Chart ... Expresses these "Blanks" as "0"

Is there a way to "supress" the "0" values from appearing on the Chart?

The Chart is "busy" so I would like to "not" display any "0" values.

Thanks ... Kha

 

[Eduardo]

Hi,
In the pivot table, click in the data arrow and uncheck the "0" value

 

[Ken]

Hi,

Excel2003 ... Can you better define "data arrow" ... Thanks ... Kha