Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"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...