Create a chart in excel using data from access?

Question

Hi is it possible to create a chart in excel using data from access?

I have a form with a subform and at the moment I can view a report with data that is shown on the form and subform, but I would also like the part the results put into a chart but i'm not having any luck with access charts so I thought maybe i could pass the data to excel to create the chart then bring the chart back into acess with a click of a button??

Is this possible and how plz?

Answer 1

Hi Max thanks for the linkt it has been most helpful, just one thing I can export the data to excel and I have created a chart using the exported data but I dont no how to bring it back into Access.

Because I'm not very good with VBA I thought I would use a macro to export the data and to import the chart but I am having problems importing the chart.

The macro ask the following:

Transfer spreadsheet

Transfer Type                 Import

SpreadsheetType           Microsoft Excel 3 

Table Name                    F:\FTSR17.mdb      ? not sure this is right this is the name od my db?

Filename                         F:\dmchart.xls

Has Field Names            No

Range                             ? I dont know what to put here?

Answer 2

There are many ways to do it.

See: Import, export, and link data between Access and Excel

http://office.microsoft.com/en-us/access-help/import-export-and-link-data-between-access-and-excel-HP001095095.aspx?CTT=1

Answer 3

Hi thanks for your help and I have tried this and it does as you say but how do I get the data from access to excel in the first place and the data to be what is on on view on my form and subform?

thank you

Jo

Answer 4

First, using Excel to get data from Access, create the chart and save it.

After that, in Access form, add an Unbound Object. In the dialogue box, select 'Create from File'; use the 'Browse' button to locate to the Excel file; select 'Link' and click "OK"