chart displaying horizontal line for zero data

  • Thread starter Thread starter pseudonym
  • Start date Start date
P

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
 
In place of zeros use =NA() This displays as #N/A and these points are
ignored by chart
best wishes
 
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
 
Back
Top