Excel Chart - 2 Sets of Data

[Al Mackay]

Surely this must be easy?......

I have two sets of data which I need to map against each other,
'Raised Date' held within column B, and Required Implementation in
column A.

This list will automatically refresh each month by ODBC and I want the
chart to basically show the amount per month/year (amount being Y
axis, Month/year being X axis). The chart would also need to
recognise that new data exists and refresh the chart accordingly -
note, Raised Date always exists whereas Required Implementation
doesn't necessarily exist.

Please can someone help with this - if you're able to send any
demonstrations this would be really useful, as I'm really struggling
with this.


********* SAMPLE SET OF DATA SHOULD THIS BE OF ANY HELP *********
Required Implementation Raised Date
01/07/2004 14:14
01/07/2004 16:22
29/06/2004 10:57
30/06/2004 15:43
01/07/2004 30/06/2004 16:34
01/07/2004 25/06/2004 08:37
25/06/2004 12:06
01/08/2004 25/06/2004 17:08
10/07/2004 24/06/2004 11:08
15/07/2004 24/06/2004 11:14
24/06/2004 15:33
29/06/2004 22/06/2004 13:34
23/06/2004 22/06/2004 13:39

Any help would be great. Cheers, Al ( (e-mail address removed) )