chart displaying horizontal line for zero data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pseudonym@1NET.gr - 31 Jan 2005 19:11 GMT

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

Reply to this Message

Bernard Liengme - 31 Jan 2005 23:52 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hello,
> I am using a column chart in Excel. The chart is currently
[quoted text clipped - 5 lines]
> Thanks
> Pseud

Reply to this Message

pseudonym@1NET.gr - 01 Feb 2005 19:54 GMT

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

Reply to this Message

pseudonym@1NET.gr - 01 Feb 2005 20:22 GMT

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

Reply to this Message