If the problem is the data stops after 20 rows and the chart is plotting 50,
you need to set up dynamic ranges that only include the first 20 rows with
data, and use these as your chart source. Check these pages:

http://peltiertech.com/WordPress/200...ynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

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


"Dan Thompson" wrote in message
...
I am pulling my hair out over this stupid thing. I am using MS Excel 2003
I have a column of data that I am trying to graph the problem is the
column
derives its data from a formula in the cell if the formula is true than
the
cell has a visible data value in it if it is false the cell has no visible
data value just the formula value that shows as a blank cell except for in
the formula window. My problem is that My plot for my chart is from Cells
A1
to A50 which all have formulas but only A1 to A20 actualy has visible
value
in the spread sheet because the rest of the cells have a formual boolean
value of false and only display a visible value in the cell when the
formula
is true. Now when I plot A1 to A50 I still get the line plot on the graph
dropping to a zero value after cell A20 even though the cells in the
spread
sheet have no visible values. Oh and I already went into chart settings
and
set it to "Do Not Plot Empty Cells" Technicaly the cells I am ploting are
not
empty they contain formulas but visibly they are empty untill that formula
=
a true value.

Can someone tell me how to plot cells with formulas that don't have a
visible value in that cell on the spread sheet as "NOT Ploted"

Thanks
Dan Thompson