How about
:
=If(' Data'!$O$32=0, "",' Data'!$O$32)
Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"JEM" wrote in message
...
Could anyone please tell me, I have developed a worksheet template were I
have sourced the data labels in my chart. Sometimes this means 0 is
inserted
in the chart and I wondered if it was possible when I used the formulae
below
that I could state that if the source cell equalled 0 then this should not
be
used.
=' Data'!$O$32
Many Thanks in anticipation.