If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
using Access Data
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. |
#2
|
|||
|
|||
using Access Data
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. |
Thread Tools | |
Display Modes | |
|
|