Report with Chart in an object frame

[Guest]

Hi,

I have an Access report with a Bound Object Frame to show an Excel Chart.
However, it takes too long to view each record if report has multiple pages.
Each line chart was created in Excel with about 4000 data points. Is there
any way to take a snap shot of the chart instead of pasting as a link?
Currently I have to shrink the chart then paste into each record on an Access
form so if fits into my Access Report. Or, is there an more efficient way of
getting the chart to appear quickly as I view the Access report pages?

Using
Access 2000
Excel 2000
Windows XP Prof.

Thanks,

 

[Guest]

You haven't stated why you couldn't use the chart object in Access rather
than messing around with Excel.

 

[Guest]

Duane,
It would be great if I could stop using Excel and collect this data in
Access and report chart using an Access report.

To begin I need to be able to collect 4000 or so data points for each
record. Then display a line chart with the results on an Access Report. Can
this be done? I don't thing 4000 or so field names would we practical. What
am I doing wrong?

 

[Guest]

We don't know anything about your data. I would expect you could use 4,000
records rather than 4,000 fields in a single record. This is generally
referred to as normalizing your tables.