View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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