I'm going to touch on the last question and then move on:
Check Excel Help for charting specifications, and you'll find (both in Excel
2003 and 2007)
Data series in one chart: maximum 255
Data POINTS in a data series for 2-D charts: max 32,000
Data POINTS in a data series for 3-D charts: max 4,000
Data points for ALL data series in one chart: max 256,000

So see if there's even a possibility of charting the information. Even with
just 1 series in a 2-D chart, it appears you exceed Excel's data points
limit. The 'work around' is to graph different pieces of the data and
overlay the charts.

For the other questions, I'm sorry, I just don't have the answers, hopefully
someone else will.

"G Ray" wrote:

I want to bring a lot of data into Excel from a database. Using SQL I
can retreive much more data than one worksheet can hold.

I have found I can create and name a range that includes multiple
worksheets.

If I retreive 80,000 records from a database can I import them into my
multi-sheet range?
Does Excel recognize such a range as a contineous list of data?

I want to analyze this type of data with averages and statistical
functions and create graphs to show the results of my analysis.

Will Excel be able to graph across my multiple sheet range?

Thanks
Glen
.