Excel Graph Help

[ahirji]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Division[/TD]
[TD]Employee[/TD]
[TD]No. of Calls[/TD]
[TD]Talk Time [/TD]
[/TR]
[TR]
[TD]Division 1[/TD]
[TD]Ali Hirji[/TD]
[TD]33[/TD]
[TD]01:29:46[/TD]
[/TR]
[TR]
[TD]Division 1[/TD]
[TD]Sarah Toms[/TD]
[TD]24[/TD]
[TD]02:31:50[/TD]
[/TR]
[TR]
[TD]Division 2[/TD]
[TD]Amy Harris[/TD]
[TD]12[/TD]
[TD]00:56:01[/TD]
[/TR]
[TR]
[TD]Division 3[/TD]
[TD]Chris Smalling[/TD]
[TD]20[/TD]
[TD]01:05:30[/TD]
[/TR]
</tbody>[/TABLE]


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.