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

Charting with missing data or empty strings from vlookup()
 

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

Charting with missing data or empty strings from vlookup()
 

Jon --

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

--Mike

"Jon Peltier" wrote:

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