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
news
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.