Re: [users] Graphing question for Calc

[JOE Conner]

I am not sure what you really want. Check the attachment and give further requirements. i think an X-Y chart would make more sense, but your preference governs.

Joe Conner, Poulsbo, WA USA

Allen wrote:

Hi Gang,





The data looks like this:

(Time)         (Size)   (Day)    (Day #)
12:00:00 AM    5000    Sunday        1
12:01:00 AM    6000    Sunday      1
12:02:00 AM    6000    Sunday      1
12:03:00 AM    2000    Sunday      1



How do I do this?

Thanks,

Allen

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Okay, I'm making a hash of this, but then I've never had to do much graphing. What I want is a bar graph that has seven segments divided into 24 blocks on the X axis. Each segment is a day of the week, and each block is an hour of the day from 00:00:01 to 23:59:59. The Y axis is the total number for each hour of each day. The data is in three columns sorted by a number representing the day with 1 = Sunday through 7 = Saturday. Then the data is sorted by the hour of the day. The third column is the size of the file. I don't really need that in the graph at this point but may well in the future so suggestions are most welcome. This is only 4 lines of 60,000 lines on the first page that I have completed scrubbing.

Allen.ods
Description: application/vnd.oasis.opendocument.spreadsheet

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]