View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default HIDE VALUE 0 FROM CHART

Hi Barry,

Am Wed, 27 Nov 2013 07:49:16 -0800 (PST) schrieb Barry Mitchell:

I have a table from which I create a chart. This table shows the number of times a certain incident happens. When there is "0" number of incidents on that cell, is it possible for it not to show on the chart.


instead of 0 use
=NA()


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2