Thread: Zero's
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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