In place of zeros use =NA() This displays as #N/A and these points are
ignored by chart
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
Hello,
I am using a column chart in Excel. The chart is currently
displaying a horizontal line when there are zeros for the data. It is
working as it was designed to do... however I would like to make the
graph not display a line when there is all zero data. Is there an easy
way to fix this problem?

Thanks
Pseud