View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default how do I hide zeros in a graphic?

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

"FLF" wrote in message
...
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...