Help Graphing data.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harvey Colwell - 13 Sep 2007 22:06 GMT

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

Reply to this Message

Dave Peterson - 14 Sep 2007 00:50 GMT

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

Maybe you'll find something there to start.

> 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.
[quoted text clipped - 30 lines]
> "2007-09-13","00:23",38,40
> "2007-09-13","00:28",47,31

Signature

Dave Peterson

Reply to this Message

Harvey Colwell - 14 Sep 2007 20:56 GMT

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

> Ron de Bruin shows some ways to combine text files:
> http://www.rondebruin.nl/csv.htm
[quoted text clipped - 36 lines]
>> "2007-09-13","00:23",38,40
>> "2007-09-13","00:28",47,31

Reply to this Message

Dave Peterson - 14 Sep 2007 21:19 GMT

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.

> 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
[quoted text clipped - 44 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message