Charting with missing data or empty strings from vlookup()

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

--Mike
 
Back
Top