Problem with multiple datasets

I am sure I am doing something wrong, but cannot work out what!! I am trying to build a graph with multiple series, when I build the graph with a single series it is fine, but as soon and I select multiple series I get a page error. My data is structured as follows:

09-12 22 Penarth and Barry
09-12 25 Cardiff
09-12 14 Bridgend
09-11 13 Vale Cowbridge
09-11 5 Penarth and Barry
09-11 29 Cardiff
09-11 7 Bridgend
09-10 15 Vale Cowbridge

and I want column 1 to be my x-axis, column 2 the y-axis and column 3 the series.

The recordset is defined in the data page as follows:

"SELECT [Column 1] AS XLABEL, [Column 2] AS YVALUE, [Column 3] AS DATAGROUP FROM dbo.TABLE WHERE [Column 4] = ? ORDER BY [Column 1] ASC"

But the page crashes. Have I defined the graph incorrectly?

Thank you.

Are you trying to show multiple graphs in one?

See the "Creating combined charts with the XML Editor" in the Solutions Recipe Section of the Dynamic Web Charts support page:
dynamic-web-charts/

Originally Said By: Jason Byrnes

  Are you trying to show multiple graphs in one?

See the "Creating combined charts with the XML Editor" in the Solutions Recipe Section of the Dynamic Web Charts support page:
dynamic-web-charts/  

Actually, I got it sorted by editing the xml by hand (that made sense in my head, but of course all the methods are by hand!!) using the wizard and xml editor seemed to break it. So that is now done. But, I can't seem to get each of the lines to be a different color at the moment. I have changed the color wheel color settings to be the right colors and have also tried adding a child color tag for the <point>, but all to no avail. Could you advise anything (other than trying to find something I am competent at!) Thank you :-)

sorry for being dim ... sorted ... I will get back in my box now .... thank you for your patience!

Ok, glad to hear it is working.