Help with zero values on spreadsheet and no zeros on line chart

[mike]

Ok, I have looked around on the web for a explanation on how to do this but
I never good find anything that came close to what I am looking for. I'll
try to explain this as best I can. Lets say I have a bunch of numbers with
zeros in my spreadsheet. The numbers are in columns c2,d2,e2 to
c706,d706,e706 rows.(see example)
a b c d
e
1 test1 test2 test3 test4 test5
2 a b 0
3 b c 200
4 c d
0
etc y f 300
etc u l 250
706 z d 0
Now what I would like is to show the zero and the other numbers in the
spreadsheet but when creating a line chart I would just like to have all
other numbers except zeros. How can this be done.
thanks for your help

 

[Frank Kabel]

Hi
see for an example: http://andypope.info/charts/piezeros.htm