If you have a formula producing zero, replace the zero by NA().
--
David Biddulph

"drjayr2002" wrote in message
...
I have a simple xy chart with months on the xxis. I am collecting data as
every month goes by. Is there a way to chart all 12 months on X axis and
the
Y axis to show the plot only when it is non zero. (typically it drops off
to
0, when there is not any data and have zero values). Thanks