chart displaying horizontal line for zero data
 

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

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

Hi Bernard,
I tried this command =IF(E5 = 0, NA(), NA()) and the cell still
displays 0 when 0 is inputed into the cell. Do you have any other
suggestions?

Thanks,
Pseud

Never mind.... i was creating a circular reference.