jsnwtlrPremium
join:2004-12-16
Carrollton, TX | reply to zach3
Re: [Excel] Formula Question Use the formula:
=IF(A1>0,A1,NA())
The NA function should cause the chart to ignore the cell. |
|
zach3ZachPremium
join:2000-05-04
Saint Louis, MO | JSN,
I thought that I had tried that before. Anyway, it doesn't work.
The result is shown as a #N/A in the cell and it also shows up in the chart exactly as shown in the cell.
Thanks,
Zach |
|
jsnwtlrPremium
join:2004-12-16
Carrollton, TX | Can you post a small sample of the spreadsheet including the problem chart? I guess I don't understand the problem. |
|
|
|
