put dates in col A, Calls received in col B, number that result in
service call in col C, and in col D calculate % service call.

Make a multi column chart, highlight the third series ie % service
calls and convert to line chart.

BUT...

if you only receive 50 calls, presumably it is easier for you to assign
service calls so you need some type of waiting, perhaps?


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=524177