jsnwtlr
Premium
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. |
|
zach3
Zach
Premium
join:2000-05-04
Saint Louis, MO
clubs: | 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 |
|
jsnwtlr
Premium
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. |
|
