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

If there are 575 pieces of equipment then
create a sheet for each piece of equipment. You can then graph as much as
you like.
You will end up with 575 sheets but you can download my Easy sheet changer
from
http://www.geocities.com/excelmarksway

If you need data from each sheet then add another sheet that does all the
graph work.

- Mark



"Ufdah" wrote:


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