[EMAIL PROTECTED] 2008/6/26 TomW <[EMAIL PROTECTED]>:
> 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] > >
