Chart to track time of calls (Excel 2010)

[tcrank472]

I have an Excel file that tracks new call with name, date of call, time of call and other useful information. What I want to do is create a chart that will show the various call times so we can see visually when the most frequent calls come in.

Any advice on the type of chart to use, and how to create it?

Second step after I get the general chart done would be to analyze the call time by day of the week. But first things first. I am having trouble understanding how I can create the "Time of Call" chart.
Thanks for any assistance!
Tom

 

[Vidar]

Hi Tom

First, you might want to make a histogram by grouping the calls that falls within a time range of a day.
For example by 1 hour intervalls: 00:00 - 01:00, 01:00 - 02:00, and so on.
A pivottable is perfect for this task.

Vidar

 

[Robert Mika]

I have an Excel file that tracks new call with name, date of call, time of call and other useful information. What I want to do is create a chart that will show the various call times so we can see visually when the most frequent calls come in.

Any advice on the type of chart to use, and how to create it?

Second step after I get the general chart done would be to analyze the call time by day of the week. But first things first. I am having trouble understanding how I can create the "Time of Call" chart.
Thanks for any assistance!
Tom

Care post your sample?
Pivot Table/chart would be probably the best option.

 

[tcrank472]

Hi Tom

First, you might want to make a histogram by grouping the calls that falls within a time range of a day.
For example by 1 hour intervalls: 00:00 - 01:00, 01:00 - 02:00, and so on.
A pivottable is perfect for this task.

Vidar

This is my first time using a histogram, looks like it is the best solution, but when I try to create it, I get an error message that my data input is non-numeric. I have the "Call Times" as my data input and they look like 11:30 AM, 4:24 PM, etc. My Bin amounts range from 7:00 AM to 6:00 PM. Any suggestions on how to proceed with the histogram? Thanks.

 

[oldfisher]

First you can try to convert the non-numeric data into numbers by adding 0 to all of them using "specail paste" (add).
Then work with array function "frequency" to group the calls by time intervals (Bin) you want to set.