Charting week values against monthly target

[staticbob]

Guys,

I need to create a line chart from the data below. The users enter 3 values each week, and I also need to plot the predefined monthly target.

The month labels are actually in date format, just converted to mmm

Any help ?
Thanks
Bob

EDIT - Ah, after another phone call . . . what I actually need to chart is the monthly target against the LAST entry for that month from the weekly data.

Midlands2005.xls
	A	B	C	D	E	F	G	H
7	MidlandsHistory
8	Date	2004Figure	2005Figure	2006Figure		Month	Target
9	04/01/05	59	12	0		Jan
10	06/12/04	51	12	0		Feb
11	22/11/04	51	12	0		Mar
12	08/11/04	51	12	0		Apr
13	25/10/04	52	12	0		May
14	18/10/04	52	12	0		Jun	45
15	11/10/04	52	12	0		Jul	45
16	04/10/04	51	10	0		Aug	45
17	20/09/04	51	10	0		Sep	45
18	13/09/04	51	10	0		Oct	50
19	06/09/04	50	10	0		Nov	50
20	31/08/04	50	9	0		Dec	50
21	09/08/04	50	9	0
22	02/08/04	49	9	0
23	26/07/04	49	8	0
24	19/07/04	48	8	0
25	12/07/04	46	8	0
26	28/06/04	44	4	0
27	21/06/04	44	9.2	0
28	14/06/04	44	9	0
29	07/06/04	42	7	0
30
Midlands