Populate Excel Chart Data from Access
 

Hello,

Two questions:

I am trying to populate SHEET2 of a particular spreadsheet from an Access
query. Data in SHEET2 is the source of data for a graph on SHEET1.

1. When I run the DoCmd.TransferSpreadsheet from Access, naming SHEET2 as
the destination RANGE, it creates SHEET21. However, when I delete SHEET2,
run the DoCmd.TransferSpreadsheet it creates SHEET2. If I run it again, it
updates SHEET2.

Is there something in Excel that recognizes a link between the graph on
SHEET1 and the data in SHEET2 which prevents me from doing this?

2. Assuming I can resolve #1 above, how can I dynamically define the range
of data for the X and Y axis? As the query is returning a different data set
each time I run it, I cannot pre-determine the last cell in the X and Y data
columns.
--
David