Charting with missing data or empty strings from vlookup()
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
|