Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get Excel 07 combobox to populate from MS Access table? | Excel Discussion (Misc queries) | |||
Access macros in Excel - populate results in spreadsheet | Excel Discussion (Misc queries) | |||
excel chart with data source from an access query | Charts and Charting in Excel | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
How to populate Excel Range from Access RecordSet? | Excel Programming |