View Single Post
  #1   Report Post  
saretta75
 
Posts: n/a
Default How do I hide data labels that show a zero value on histograms?


Hi,
I need to know how to hide data labels that show a zero value on
histograms.

On *line chart*, I've put "=NA()" instead of the zero returned by the
formula, and it functions, but using the same technique *with
histograms* I got "#N/A" displayed on the chart.
The only way to avoid it, it seems to me, it's leaving the cells blank,
but I need to keep formula inside.
Any suggestions?
Thanks in advance,
Sara


--
saretta75
------------------------------------------------------------------------
saretta75's Profile: http://www.excelforum.com/member.php...o&userid=27008
View this thread: http://www.excelforum.com/showthread...hreadid=414322