I have a chart, and several series contain data that comes from elsewhere
using a VLOOKUP. However, when the VLOOKUP finds a blank, it returns a zero.
I want the chart to interpolate the data, but Excel charts can only
interpolate blanks, not zeroes. I've used ISBLANK with the VLOOKUP to return
what appears to be a blank, but the chart still sees it as a zero, and thus
will not interpolate. I'd like to know if there's a way to set the value of
a cell to NULL, because "" doesn't work...