Posted: 2/20/2009 8:57:56 AM EDT
|
I have a spreadsheet that collects data monthly and then, based upon a chosen month, displays the data in charts covering a smaller range. To do this, I've had to create a table that is populated automatically based upon the specified criteria and from which the charts are generated. The problem arises when a particular datapoint is "N/A". The data table populates perfectly, but the chart displays ZERO. I know that BLANK cells can be skipped in charts, but this table has no blank cells because each cell is populated by a formula in that cell. Any idea how I can either a) get "N/A" cells not to plot, for "N/A" to appear in the data table on the chart, or both? Thanks. |
|
Quoted: You could try something like this, where "$AR$15" is the cell that may or may not contain a value, even though it contains a formula. =IF($AR$15="N/A","N/A",$AR$15) That's basically what I've got. Sadly, "" is not viewed as null, but rather as a zero value. |