how do I hide zeros in a graphic?

[FLF]

If I have a table with 'zero' values and don't want them to appear in my
graphic, but do want the rest of the values to show, how do I hide them?
Hiding them on the table doesn't work, they still show up in the graphic...

 

[David Biddulph]

Replace the zeros by =NA() or #N/A

 

[Bernard Liengme]

Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine
best wishes

 

[doofy]

Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine
best wishes

I tried something like this and it didn't work. I finally had to just
remove the values, leaving a blank cell.

 

[David Biddulph]

"Something like this" was obviously not close enough. Next time, don't do
it that way.

I think you win today's newsgroup prize for useful and detailed description
of a problem:
"Something like this", and "it didn't work" :-(