P
Phil Stanton
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
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