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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart display of no value cells 1
Dynamic Chart Help 3
Blank Values in Excel Charts 7
Paste Values in linked Cells Only 4
excel displays formula instead of value in one cell 3
Graphing 0 values from blank cells 7
How can I use the value from a cell in one worksheet in another 5
Excel Excel Vlookup formula based on cell data 7

Back
Top