I am trying to use Excel 2000 to create a map of our boat storage areas.
There are a number of Locations such as Boat Compound and Mast Shed. There
are currently 8 such locations.
I have an MSAccess database that stores each area, combined (spaceno and
owner's name) and x & y co-ordinates.
Each worksheet has an xy scatter graph with a plan of the location
concerned, the xy plot and thanks to Bob Bovey's xy labeller, the number and
name of each space.

E.g. Location SpaceAndName X Y
Mast Shed 2 - Smith 47 23
Mast Shed 5 - Jones 20 23
Mast Shed 17 - Robinson 5 48
Boat Compound 42 - Donby 47 20
Boat Compound 41 - Sonny 53 20

2 Problems.
1 The plan (background to the chart) is embedded. I would like it to be
linked so that changes in the plan are reflected in the chart.
2 I have had to create separate queries to extract the data from Access
for each of the 8 location. It appears that each query has to be refreshed
separately. I would like to have a single query linked to Access with all
the locations and break them down in Excel. Is this possible?

Thanks

Phil