Zero's
 

Hi
I have created a Bar graph to show timings on a job, my problem is I have
linked them to another page so when I have a sum formula the bar chart shows
Zeros.. can I stop this happening?

Much Appreciated


Kev

Zero's
 

In your link formula, put in something like

=IF(Sheet1!A1=0,"",Sheet1!A1)

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


"Bar Charts With =sum ... showing Zero" <Bar Charts With =sum ... showing
wrote in message
...
Hi
I have created a Bar graph to show timings on a job, my problem is I have
linked them to another page so when I have a sum formula the bar chart
shows
Zeros.. can I stop this happening?

Much Appreciated


Kev