Excel project

  Graham. 10:30 13 Sep 2006
Locked

I have a record of daily events, eg. 7.05, 11.30, 15.40, which vary from day to day.

Can Excel plot a chart to show the peak time, or more explicitly, the likely time of an event occuring.

For convenience, assume each event lasts for 10 minutes.

  VoG II 10:52 13 Sep 2006

I assume 7.05 etc. are times (in which case they should be entered as 7:05 etc. for Excel to recognise them as times). But what does an 'event' consist of or is there simply a record of times when an event occurs?

  Graham. 11:22 13 Sep 2006

Times when an event occurs.

  VoG II 11:31 13 Sep 2006

First you will need to create a list of all possible times e.g. 7:00, 7:10, ... 23:50.

Then make sure that Analysis Toolpak is ticked in Tools > Add-ins.

Then choose Tools > Data Analysis > Histogram.

In the Input Range box select the range of your events.

In the Bin Range box select the range of your list of all possible times.

Tick Output range and enter the starting cell for the output.

Tick Chart Output. Click OK.

  Graham. 11:35 13 Sep 2006

Give me a minute :-)

  Graham. 11:37 13 Sep 2006

Is the list to be in one column, eg. A?

  VoG II 11:38 13 Sep 2006

Er, yes sorry, each possible time in its own cell in one column.

  Graham. 11:40 13 Sep 2006

Right, that should take me a few minutes, unless a copy down function exists.

  Graham. 11:46 13 Sep 2006

Sussed the copy down!

  VoG II 11:48 13 Sep 2006

Type in the first two times. Select them both. Hover the cursor over the bottom right corner of the second time until the cursor turns into a +, hold down the mouse button and drag down.

  Graham. 12:00 13 Sep 2006

Do I enter the actual times in column B and these are the Bin range?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone