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 Division Employee No. of Calls Talk Time Division 1 Ali Hirji 33 01:29:46 Division 1 Sarah Toms 24 02:31:50 Division 2 Amy Harris 12 00:56:01 Division 3 Chris Smalling 20 01:05:30 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel Graph Help

Thread starter ahirji
Start date Sep 12, 2013
Tags

graph data pivot

ahirji

New Member

Sep 12, 2013

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

Division	Employee	No. of Calls	Talk Time
Division 1	Ali Hirji	33	01:29:46
Division 1	Sarah Toms	24	02:31:50
Division 2	Amy Harris	12	00:56:01
Division 3	Chris Smalling	20	01:05:30

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: Sep 12, 2013