View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
MJS MJS is offline
external usenet poster
 
Posts: 16
Default 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