Charting with missing data or empty strings from vlookup()

[Guest]

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

 

[Jon Peltier]

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

 

[Guest]

Jon --

Thank you VERY much. That was exactly the problem I had and the solution I
needed.

--Mike