Getting Excel's charting capabilities from Access

G

Guest

Hi,
i currently export from Access to Excel in order to leverage Excel's
advanced charting features.

Is there a way to generate those Excel charts directly from Access?

thx

vince
 
D

Debra Dalgleish

In Access, you could use the TransferSpreadsheet method to send the data
to Excel. Then, in your Excel workbook, you could use Workbook_Open code
to create the chart as the file is opened.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel charting features from Access 2
VBA Code to Export Data from Chart 4
Copy-Paste Chart into Word from Excel 2007 3
How to export sharepoint 2010 chart webpart to excel? 0
Printing Excel 2007 Chart 2
Excel 2007: continuously update scatter chart from scroll bars 1
Using Excel to create weekly music charts 0
Excel 2007 XY Scatter Chart 2

Top