I have a slight problem with Charts in Excel & Access. I'm creating charts
that can use up to 50,000 data points (if not more) and in Excel there is
significant lag time (up to 2 minutes just to rescale an axis or change the
title). I decided to try and use Access to organize the data, but creating a
chart in Access is a pain because there is a 4000 data point limit per series
(really stupid).

My question is: Is there a way to link the data from Access to an Excel
chart without importing the data (importing would just cause my initial
problem)? I do know some basic VBA (from previous work in Access) if that
might help.

Didn't mentioned earlier, I'm using Office 2007

"Scott_D" wrote:

I have a slight problem with Charts in Excel & Access. I'm creating charts
that can use up to 50,000 data points (if not more) and in Excel there is
significant lag time (up to 2 minutes just to rescale an axis or change the
title). I decided to try and use Access to organize the data, but creating a
chart in Access is a pain because there is a 4000 data point limit per series
(really stupid).

My question is: Is there a way to link the data from Access to an Excel
chart without importing the data (importing would just cause my initial
problem)? I do know some basic VBA (from previous work in Access) if that
might help.