Kenny,

I suggest a different approach to what you are doing!

If you need to store the numbers permanently, they need to be stored in a table.
You can then use a query to return the specific numbers you need and easily
graph the numbers in Access.

If the numbers already exist in your database, you need to create a query that
returns the specific numbers you need and then again easily graph the numbers in
Access.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


Kenny wrote in message ...
Hi all,

I have stored a bunch of numbers in an array through VBA. I would like to
turn this array into a graph.

I have managed to save the array to a text file and import that file into
Excel from where I can graph it.

Unfortunately this is cumbersome - I would like to automate the process. Any
ideas how........

Thanks

Kenny