Creating a time based line graph
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
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...