You need to use dynamic ranges as your data source:

http://peltiertech.com/Excel/Charts/Dynamics.html

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


"Phil Stanton" wrote in message
...
I am creating a map using Excel 2000 and a scatter chart. The
XY -coordinates come from a MS Access database. If I select those columns
which contain valid XY coordinates it all works fine In this case the
information is held in I3 to J67. If, however I select a few additional
columns where there is no data say I3 to J100 I only get (apparently) 1
data point near the bottom left hand corner of the chart. How, on the
"Source Data" form can I say ignore any blank cells (I68 to J100).
I need to specify more cells than are needed because I don't know how much
data the Access tables hold.
Is there possibly a way of telling the "Source Data" form which is the
last valid cell.

Thanks

Phil