Prev: Drawing attention to difference in bar chart
Next: Min and Max Value Changes
From: Scott_D on 15 Apr 2010 11:50
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.
From: Scott_D on 15 Apr 2010 14:07
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.
 | 
Pages: 1
Prev: Drawing attention to difference in bar chart
Next: Min and Max Value Changes