Change your formula to this:

=IF(Sheet2!A1+Sheet2!A2=0,"",Sheet2!A1+Sheet2!A2)

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


"Bar chart shows Zero's" <Bar chart shows
wrote in message ...
Hi

I have created a Bar chart using data imported from another page, my
problem
is when I have no data in the cell the bar chart shows a Zero is there any
way I can stop this happening

Regards

Kev