Zero Values in chart

[Rajkumar]

Hi,

Is there any way to avoid displaying zero values in a chart.

Raj

 

[Bernard Liengme]

Assuming you mean you want empty cells not to be treated as zeros:
1) click on chart; use Tools|Options|Chart and specify how you want blanks
to be treated
or
2) replace blanks by =NA()
best wishes

 

[Rajkumar]

Thanks Bernard,

But my Source Data is depended on some formulaes,hence when the result
of them returns zero,the same gets displayed in the chart also.

Is there any other way.

I am sure you can help me.

Regards,
Rajkumar

 

[Andy Pope]

Hi,

Use Bernard's suggestion of NA() in your formula. Something like,

=IF(test<>0,test , =NA() )

Cheers
Andy

 

[Jon Peltier]

Take out the internal "=":

=IF(test<>0,test,NA())

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Andy Pope]

Thanks Jon, too lazy with my cut & paste

Take out the internal "=":

=IF(test<>0,test,NA())

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______