Here's the big picture. Design an Excel spreadsheet that will import a
csv data file that is 575 colums wide (fields) and 720 rows (records)
that I can then graph.

Now the details. The purpose is to be able to graph historical data
that is collected every two minutes (720 rows a day) for 575 different
pieces of equipment, and I will only need to graph a couple things at a
time. I started doing this through Access and imported the file into a
2-D Array since there is the 256 column (field) limit, then just pulled
the data I needed out of the array and put it into a table which I could
use to chart. But all the access guys say that Excel is much better at
charting and more flexible so I decided to see what was possible on
this side. I really am doing no calculations and the only user input
will be to select what pieces of equipment they want to graph and the
time frame for which to graph. I currently don't have plans for the
ability to do more than one day as that would be more than one file
import but it would be a nice feature.

I guess what I'm looking for is a little direction from those of you
who are more seasoned in this to hopefully make this development a
little less painful. Thanks!


--
Ufdah
------------------------------------------------------------------------
Ufdah's Profile: http://www.excelforum.com/member.php...o&userid=29239
View this thread: http://www.excelforum.com/showthread...hreadid=489638