S
Scott_D
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.
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.