I just tested this (Excel 2003 SP2) and discovered that

<format;;;

does not prevent display of #N/A in the chart (data labels showing values of
points) nor in the sheet. If what you have is text that looks like the
error, such as '#N/A, then the format hides this label in the chart and in
the sheet, because the format for text (after the third ;) is blank.

This is why NA() works for charts with markers (XY, line, and radar),
because points (markers) are not plotted for #N/A (and therefore the labels
do not show), while "" works for column or bar charts, because the
zero-thickness column/bar doesn't show, and neither does the "" label.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Wed, 16 May 2007, in microsoft.public.excel.charting,
David Biddulph said:
Format/ Conditional formatting/ Formula is/ =ISNA(A1)
Set font colour to the same as the background colour.

Alternatively, using the custom number format

General;;;

also works, as suggested by tmirelle in a previous post

http://groups.google.com/group/
microsoft.public.excel.charting/msg/8d3ae44f522983f4

The funny thing is that, now I've tested it, the reason why I never
found it by myself is clear. I was testing it on cells, and in cells
that format does *not* obscure the #N/A. But it does in the chart.
Weird!

Also, although it works fine in line and scatter charts, it produced a
very strange result in a bar chart. The actual "#N/A" text appeared
superimposed on the label of the previous data point, and the label
frame associated with that text was way up in the top left hand corner.
Very buggy.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.