How to plot occurrences of various times for each hour in a

GeorgeAdamson · Apr 24th, 2002, 04:57 AM

Hello anyone!

I have a long list of date-times ('readings') that need to be plotted by how many occur in each hour of the day. (X-axis=hours through day, Y-axis=number of readings in each hour)

Eg: say I have a column with cell values: 9:50, 10:10, 10:20, 10:30, 11:00 which must be plotted as 3 vertical bars (representing 9-10am, 10-11am, 11-12) on a chart. The height of each bar will be determined by the number of readings that occur in each hour(in this case 1, 3 and 1 respectively).

There are in fact several thousand readings to plot through the day. Each reading is in date-time format (dd-mm-yyyy hh:mm:ss)

Many thanks!

Mudface · Apr 24th, 2002, 05:59 AM

You could try making a pivot table of your data, grouping the entries by hours and then plotting directly from that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 04:57 AM	#1
GeorgeAdamson New Member Join Date: Feb 2002 Posts: 14	Hello anyone! I have a long list of date-times ('readings') that need to be plotted by how many occur in each hour of the day. (X-axis=hours through day, Y-axis=number of readings in each hour) Eg: say I have a column with cell values: 9:50, 10:10, 10:20, 10:30, 11:00 which must be plotted as 3 vertical bars (representing 9-10am, 10-11am, 11-12) on a chart. The height of each bar will be determined by the number of readings that occur in each hour(in this case 1, 3 and 1 respectively). There are in fact several thousand readings to plot through the day. Each reading is in date-time format (dd-mm-yyyy hh:mm:ss) Many thanks!

Apr 24th, 2002, 05:59 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You could try making a pivot table of your data, grouping the entries by hours and then plotting directly from that.