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

The only way I can think of (other than VBA code) is to hide the rows
that contain the N/A (or you could just revert to ""). The easy way to
hide the rows would be with XL's filter capability (Data | Filter >
Autofilter).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <(E-Mail Removed)>,
(E-Mail Removed) says...
>
> 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
>
>

Thanks for the help,
but it still not function ... :
- reverting #N/A to "" in the table I got 0 on the chart, instead o
#N/A;
- I cannot hide the rows, since the N/A values can be positioned o
every cell of the table; I cannot know in advance.

Thanks anyway,
Sar

--
saretta7
-----------------------------------------------------------------------
saretta75's Profile: http://www.excelforum.com/member.php...fo&userid=2700
View this thread: http://www.excelforum.com/showthread.php?threadid=41432