Have a look at Jon Peltier's advice at this google search thread.

http://snipurl.com/14ik0


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 13:32:01 -0800, Bar chart shows Zero''s
wrote:

I want it to show nothing on the graph

"bj" wrote:

what do you want it to show?

"Bar chart shows Zero's" wrote:

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