Ironically, if you'd left the #N/A in the cells, the chart would have not
plotted these cells. Instead of using the IF to hide the error, use
conditional formatting.

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


"MJS" wrote in message
...
I've used the vlookup() trick -- if(isna(vlookup(...)), "", vlookup(...))
to
construct an intermediate table, which I would like to chart. However,
charting cells which contain the empty string ("") works porly.

I really don't want to treat those missing values as zeros, if there's any
way to avoid it -- I just want the chart to treat them as missing.

How can I change either the way I'm using vlookup() or the way I'm
charting
to allow me to chart this data with missing values?

Thanks for your help,
Mike