ExcelBanter - Pivot Table ... Suppress "0" Values?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table ... Suppress "0" Values? (https://www.excelbanter.com/excel-discussion-misc-queries/243780-re-pivot-table-suppress-0-values.html)

Pivot Table ... Suppress "0" Values?

Hi,

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

"Eduardo" wrote:

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

"Ken" wrote:

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