Help Graphing data.

[Harvey Colwell]

I have CSV files containing 5 minute averages of a router's throughput.
There are 4 fields/columns, Day, time, packets/sec in, and packets/sec out.
A new file is created each day at midnight.


I have no problem graphing the data for a single day. But how do I
import/combine the data from several days and graph each day's packets in
and packets out on their own separate line, using the Date to start a new
graph line?

TIA

---Example-Day1------------
"2007-09-11","00:03",97,140
"2007-09-11","00:08",108,155
"2007-09-11","00:13",36,59
"2007-09-11","00:18",77,112
"2007-09-11","00:23",48,78
"2007-09-11","00:28",12,32

---Example-Day2------------
"2007-09-12","00:03",18,22
"2007-09-12","00:08",10,16
"2007-09-12","00:13",44,41
"2007-09-12","00:18",34,22
"2007-09-12","00:23",23,23
"2007-09-12","00:28",13,11

---Example-Day3------------
"2007-09-13","00:03",22,12
"2007-09-13","00:08",14,14
"2007-09-13","00:13",23,22
"2007-09-13","00:18",34,43
"2007-09-13","00:23",38,40
"2007-09-13","00:28",47,31

 

[Dave Peterson]

Ron de Bruin shows some ways to combine text files:
http://www.rondebruin.nl/csv.htm

Maybe you'll find something there to start.

 

[Harvey Colwell]

I should have said, I have no problem merging the multiple files into one.
My problem is a lack of experience with Excel. I don't know how to start a
new graph for each day (column 1).

 

[Dave Peterson]

You really want separate graphs for each day?

If yes, then I would think that keeping the data in separate worksheets (open
each separately). Then creating the graphs for each day/sheet.

If you really meant different lines on the same graph for each day, I think I
would rearrange my data into more of a table:

time day1-x day1-y day2-x day2-x
00:03 97 140 18 22
00:08 108 155 10 16
00:13 36 59 44 41
00:18 77 112 34 22
00:23 48 78 23 23
00:28 12 32 13 11

Maybe use the real dates for each column header.

Then graph from there.

If the times for each day are always the same, you could use some copy|pasting
to "merge" the data into one sheet.