Building a chart based on "time slots" - frequency distribution

chamsters

New Member
Joined
Jun 2, 2009
Messages
16
timestamp / count in location 1 / count in location 2

e.g. rows:

15:05 / 22 / 12
15:32 / 21 / 10
15:44 / 20 / 9
17:30 / 10 / 8


What I'm trying to do is plot a graph that shows each 1/2 hour time slot on the X axis (can i configure how long each slot is?) between say, 7am and 9pm (once again, don't mind 24 hours!), with the lines on the chart showing the average count during that period.

so e.g. in this case on x axis i'd like 15:00 - 15:30, with the y axis valud being 21.5 for location 1 and 11 for location 2; showing no lines for the rest of the containers, and then having the 17:30-18:00 container having 10 in location 1 and 8 in location 2.

Quite complex given it needs to average?

Any ideas how to go about doing this?

Thanks!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,113
Messages
5,857,453
Members
431,880
Latest member
kar2rost

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top