Exporting multiple charts to Excel

  • Thread starter Thread starter Ian Millward
  • Start date Start date
I

Ian Millward

I need to export several tables and charts from an Access 2000 db into Excel
2000 because Access is very limited for displaying Charts. Ideally, I would
like to group data of a similar nature on the same sheet, tables down the
left side in blocks and charts adjacent. I can't seem to manage that.



The best I can do is one table of data per sheet. I can live with that but
the problem is that all the charts seem to go onto "Sheet1" and stack-up on
top of each other. I have played all the various combinations of
ActiveChart.Location and ActiveChart.SetSourceData but all to no avail. It
works fine if I import the tables into Excel and handraulically create the
charts but not using VBA, although this is not an acceptable option.



My question is: Am I trying to defy the laws of nature by trying to do
something Excel can't do or have I just not hit the correct permutation of
possibilities

I've tried posting this to the Microsoft.Public.Excel.Charting NG but no
replies so far.



Many thanks,



Ian Millward
 
Disregard.

I have just found the definitive answer on MS KB Page.

It is a bug and cannot be done.
 
It might work if you import the data from Excel instead of exporting from
Access. Could be completely automated and the Excel VBA code could place the
data where you will.
 
Back
Top