r/excel•
switchbackk

Creating a time based line graph

Waiting on OP

Hi all,

I have what I think will be an easy question for most of you. I have a series of data of telephone calls and the time they took place at. I want to create a line graph with the time of day along the bottom and umber of calls made on the y-axis. This would allow an easy representation of what times of the day have the most calls.

What would I need to tell excel to do in order to make this happen. I have a csv of the call logs available if needed.

Thanks

Posted Aug 25, 2015, 4:02 PM UTC

11
rtdeacha45•

You could create a summary counting the number of lines you have for a specific time, and then make a line graph based on that summary...

It could be a Pivot Table as well... and a Pivot Chart based on that summary...

1
ITRAINEDYOURMONKEY3•

Line graph isn't ideal for this - it doesn't really let you set an x-axis. Scatter plot (with lines connect between the dots) should be what you want. Use your time values as your x-values and number of calls on the y-axis.

To convert your list of calls with times to "number of calls at X time", I'd use the FREQUENCY function. Set up the time ranges you want to represent as a list of times, and the function will count how many calls happen between each time. It's essentially giving you a histogram.

1
switchbackkOP•

Worked perfectly, thank you.

1
switchbackkOP•

This sounds like just the ticket. Will try it in the morning when I get in the office. Cheers

1