Chart showing busiest time of day

[glaupie]

Hi there,

I need some tips as to what the best way would be to represent the following in a chart:

I have a table showing each day of the month (1st, 2nd, 3rd to 31st) as headers, and 24 one-hour intervals as rows (00:00 - 01:00, 01:00 - 02:00, ..... 23:00 - 24:00). Each cell then shows the percentage of total faxes for the day, that was received during that interval.
At the bottom (below the 23:00 - 24:00), I then have a formula which determines the busiest time of the day, for each day.

I want to represent this (busiest time of each day) in a chart, but nothing I do seems to work properly. I'm not sure if I need to format the time-period differently, or which chart type to use.

My data table will thus look like this (transposed):

1st	13:00 - 14:00
2nd	11:00 - 12:00
3rd	13:00 - 14:00
4th	11:00 - 12:00
5th	14:00 - 15:00
6th	11:00 - 12:00
7th	12:00 - 13:00
8th	12:00 - 13:00
9th	13:00 - 14:00
10th	13:00 - 14:00
11th	13:00 - 14:00
12th	16:00 - 17:00
13th	11:00 - 12:00
14th	12:00 - 13:00
15th	14:00 - 15:00
16th	12:00 - 13:00
17th	12:00 - 13:00
18th	16:00 - 17:00
19th	12:00 - 13:00
20th	12:00 - 13:00
21st	10:00 - 11:00
22nd	14:00 - 15:00
23rd	11:00 - 12:00
24th	12:00 - 13:00
25th	13:00 - 14:00
26th	13:00 - 14:00
27th	13:00 - 14:00
28th	13:00 - 14:00
29th	13:00 - 14:00
30th	13:00 - 14:00
31st	16:00 - 17:00

<tbody>
</tbody>

Any ideas?

Thanks,

Gerhard

 

[cyrilbrd]

Hi, what is the importance of 1st, 2nd, 3rd? why not a pivot table with the sum of occurrences per time period? could chart that as a line chart.
would that work?

 

[Andrew Poulsom]

To create any sort of chart you need to split the times into 2 columns like this:

Excel 2003
	A	B	C
1	1st	13:00	14:00
2	2nd	11:00	12:00
3	3rd	13:00	14:00
Sheet1

 

[glaupie]

Thank you - guess that is the way to go.

G