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.