chart displaying horizontal line for zero data

[pseudonym]

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

 

[Bernard Liengme]

In place of zeros use =NA() This displays as #N/A and these points are
ignored by chart
best wishes

 

[pseudonym]

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

 

[pseudonym]

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