Chart help!! Please...

[Joaqman]

Help please! My chart is recognizing the formula in my Source Data as a zero, and charting it as such. Under the Chart options, I've checked the box that says only show visible cells, but it still charts the formula as a zero. So my graph takes a nose dive with those cells that don't have a value in them.

How do I get the Chart to ignore the formula and only show the result of the formula if there happens to be one?

 

[awriter]

An easy way to fix that is just right click on a horizontal line in the chart to Format the gridlines. Then under the minimum value enter a number just under your mininimum calculated value.