Need Design Direction for Charting Spread Sheet

[Ufdah]

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!

[exceluserforeman]

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
>
>