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):
<tbody>
</tbody>
Any ideas?
Thanks,
Gerhard
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
