Allen wrote:
What I want is a bar graph that has seven segments divided into 24
blocks on the X axis. This means there would be 168 columns total, one
per hour for a whole week.
X axis would look like this, approx:
| 1 | 2 | 3 | 4 |...| 23 | 24 | 1 | 2 | 3 | 4 |... (etc) |
| ---------> Sunday <-------- | --------> Monday <------ |(etc.)
The Y axis would be the number for that hour and day.
The number of files is much more important than their size so for the
sample data set I've dumped it.
Here is a sample data set that is a bit more complete.
(Time) (Day) (Day #)
12:01:00 AM Sunday 1
12:02:00 AM Sunday 1
02:02:00 AM Sunday 1
03:03:00 AM Sunday 1
04:01:00 AM Sunday 1
05:01:00 AM Sunday 1
05:02:00 AM Sunday 1
05:03:00 AM Sunday 1
06:01:00 AM Sunday 1
07:01:00 AM Sunday 1
07:02:00 AM Sunday 1
07:03:00 AM Sunday 1
12:01:00 AM Monday 2
12:01:00 AM Monday 2
12:01:00 AM Monday 2
01:01:00 AM Monday 2
02:02:00 AM Monday 2
03:03:00 AM Monday 2
12:01:00 AM Tuesday 3
12:01:00 AM Tuesday 3
01:01:00 AM Tuesday 3
02:02:00 AM Tuesday 3
03:03:00 AM Tuesday 3
12:01:00 AM Wednesday 4
01:01:00 AM Wednesday 4
02:02:00 AM Wednesday 4
03:03:00 AM Wednesday 4
03:07:00 AM Wednesday 4
03:09:00 AM Wednesday 4
03:13:00 AM Wednesday 4
03:15:00 AM Wednesday 4
03:21:00 AM Wednesday 4
So the first column on Sunday would have two entries, the second column
would be empty, the third column would one entry.
The fourth column on Wednesday would have six entries.
Is this clearer?
Thanks,
Allen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Allen:
I found that if I created a new column with some special formatting, I
could come close to the format you are looking for. The name of the day
was created by making it equal to the Date/Time column (=c?), then
format as NNN, which gives the name of the day. The ? indicating the
row number. The next 23 rows have =hour(c?)+1 in the New col, the ?
being the row Number. The "1" offset was added so that the numbering
starts with 1. I repeated this for each day. In the bar chart the
x-axis properties label tab, I set the "Order" to "Stagger Even". Below
is a partial list of how the columns look. I am using version 2.3.1 on
an xp pro machine. At the moment I am unwilling to upgrade to 2.4.1, so
I do not know if any new features would make this any easier. It is
definitely easier in Excel 97/03.
New Col Date/Time col Data Col
Sunday 06/22/2008 00:00:10
2 06/22/2008 01:00:10
3 06/22/2008 02:00:10
4 06/22/2008 03:00:10
5 06/22/2008 04:00:10
6 06/22/2008 05:00:10
7 06/22/2008 06:00:10
8 06/22/2008 07:00:10
9 06/22/2008 08:00:10
10 06/22/2008 09:00:10
11 06/22/2008 10:00:10
12 06/22/2008 11:00:10
13 06/22/2008 12:00:10
14 06/22/2008 13:00:10
15 06/22/2008 14:00:10
16 06/22/2008 15:00:10
17 06/22/2008 16:00:10
18 06/22/2008 17:00:10
19 06/22/2008 18:00:10
20 06/22/2008 19:00:10
21 06/22/2008 20:00:10
22 06/22/2008 21:00:10
23 06/22/2008 22:00:10
24 06/22/2008 23:00:10
Monday 06/23/2008 00:00:10
2 06/23/2008 01:00:10
3 06/23/2008 02:00:10
4 06/23/2008 03:00:10
5 06/23/2008 04:00:10
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
