Chart Wizard

I have been asked to devise a chart - please see below, but I am having trouble putting it together. All I need is a graph showing % of calls answered live and date. Please see what I have done so far:

If you average the figures over 2 weeks it will halve the dates so you will be able to fit them in.

I would like the 80% KPI line in as well please

Hi Steve

Not sure how I can fit all the dates in at the bottom, as it is showing as week number. Will this be OK?



Telephone Call Survey 2009
% Answered Live Presented Date
82 168 12/01/2009
82 129 19/01/2009
70 123 26/01/2009
70 134 02/02/2009
79 97 16/02/2009
82 127 23/02/2009
82 127 02/03/2009
86 151 09/03/2009
83 112 16/03/2009
81 118 23/03/2009
80 119 30/03/2009
93 59 13/04/2009
84 98 20/04/2009
94 87 27/04/2009
79 84 04/05/2009
82 134 11/05/2009
80 79 18/05/2009
84 61 25/05/2009
83 72 01/06/2009
83 101 06/06/2009
84 68 22/06/2009
53 85 29/06/2009
74 78 06/07/2009
55 86 13/07/2009
80 60 20/07/2009
87 68 27/07/2009
72 92 03/08/2009
65 74 10/08/2009
90 71 24/08/2009
83 65 31/08/2009
76 117 07/09/2009
80 79 14/09/2009
79 114 21/09/2009
56 117 28/09/2009
48 151 05/10/2009
83 132 12/10/2009
67 119 26/10/2009
51 178 02/11/2009
90 106 09/11/2009
83 77 16/11/2009
70 101 30/11/2009


Can you help me put the info above into graph form?

Thanks Diane