Excel Graph Help

ahirji

New Member
Joined
Sep 12, 2013
Messages
1
Hi all,

New to the forum, and was hoping for a bit of help... I need to create a graph which will show the total number of calls made and the total time on the phone for the day for each employee. Each employee belongs to a Division. I would like to show both info; number of calls made and total talk time on one graph.

The Data I have is as follows

DivisionEmployeeNo. of CallsTalk Time
Division 1Ali Hirji3301:29:46
Division 1Sarah Toms2402:31:50
Division 2Amy Harris1200:56:01
Division 3Chris Smalling2001:05:30

<tbody>
</tbody>


Is there any way I can produce a graph of the above? I created a Pivot Table to show the Division below the Employee name, and pulled the number of calls fine, but the talk time was a problem.

Can anyone help?

Any help would be much appreciated.

Thanks, Ali.
 
Last edited:

Forum statistics

Threads
1,082,612
Messages
5,366,610
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top