per PAQ :
I see that Access 2003 has a limiti of showing 3999 points on a scatter chart. I have 30000 records and If I paste that into Excel 2003 and chart it it plots fine, all data is shown.
I have 2 related questions :
1 Why? Do not both Access 2003 and Excel 2003 both use MSChart? The property sheets on both objects are the same?
2. Does Access 2007 still have this problem?
For those of you who are sure to ask "why on earth are you wanint to plot that much data", it is scientific data that I need to plot and chart and get the regresssion equation for (y=mx+b) and this amount of data in peanuts in our industry.
Note really keen on getting a third party charting addon but feel free to offer that advise