how do I hide zeros in a graphic?

  • Thread starter Thread starter FLF
  • Start date Start date
F

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...
 
Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine
best wishes
 
Bernard said:
Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine
best wishes
Click to expand...

I tried something like this and it didn't work. I finally had to just
remove the values, leaving a blank cell.
 
"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" :-(
 
Back
Top