Source data for XY scatter chart
 

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

Source data for XY scatter chart
 

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

Source data for XY scatter chart
 

Thanks Jon

Problem solved

Phil

"Jon Peltier" wrote in message
...
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