You're right about the treatment of Empty Cells: a formula renders a cell
not empty.

Excel assigns a value of zero to cells containing text, and "" is a short
piece of text. In a line or XY chart, the #N/A error is not plotted, and the
line extends from the point on one side of the #N/A to the point on the
other side. Change your formula to

=IF(A4<10,NA(),A4)

to produce this error value in a cell. If you don't like to see the error in
your table, hide it with conditional formatting.


Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


..
"Soccerboy83" wrote in message
...
I am trying to create a graph using data from my table, now some of my data
has blank cells, however they are blank because the formula i am using
tells
it to be blank, i.e. if (a4<10,"",a4). however when i graph this data it
graphs it as a zero value. Is there a way to omit this data from my
graph,
i have already tried going to the chart option table and selecting plot
empty
cells as NOT PLOTTED but i think that only applies is there is no formula
in
the cells. can someone please help me out, or at least point me in the
right
direction.