How not to draw cells with formula but no value in Excel charts?

  • Thread starter Thread starter Joe Chan
  • Start date Start date
J

Joe Chan

Can anyone please help?
I have a chart referring to a table of cells with formulae
pointing to other worksheets. Those worksheets are
captured and created periodically (every 30 min). When
the sheets are not created, the formulae will check their
absence and display "" (empty value). Once the sheets are
created, the wanted value would be extracted and
displayed.
However, with empty value, the chart will treat it as zero
and draw it. How may I skip those cells and not draw
them? I now have to delete the formula and copy back the
formula when the referenced sheets are created.
Any suggestion? Please help. Thanks.
 
Use the NA() function : something like =IF(ISBLANK(A1),NA(),A1). Excel charting passes over the NA() function as if it wasn't there - doesn't see a zero.
 
Back
Top