Charts - Excel Vs. Access

[JoshuaAnthony]

Hi all,

I tried inserting a chart into a form in my Access database to display some data but just can't seem to make it do what I want to. Basically, I have 8 fields (representing the total time an object spends in a particular location). All I want to do is show this data on a bar chart (one bar for each field) with only the information for ONE record at a time. Does anybody know how to do this with the charts in Access or would I be better off just exporting the data to Excel and doing the chart there?

What would be the best way of exporting the data? Would I export the data to cells in Excel and create a chart for the user to view in excel or is it possible to display that chart in Access? What is the best method for the actual exporting of the data?

I've tried DoCmd.OutputTo but that exports ALL records. Ideally I would like to have Access export the data for the CURRENT record to excel (have excel make my charts), and have that chart displayed in Access on the form (all in VB code for OnLoad of the form).

Thanks,

Joshua

 

[JoshuaAnthony]

I've decided just to open a new form with a filter to display just the current record on the old form and export the data from there. I'd still like to know if I can place an object on my old form that exports the data as explained to excel, allows me to perform my macros in excel to create a chart, and then display that chart in the access object? Is that possible?