recorded macro for chart has no x values

(using 2007)
I have a large number of results sheets to go through and to check for anomalies i select all the data (5 columns) and create chart>scatter and excel gives me the chart with col 1 as x vals and 2-5 as y series vals. i then modify the axis scales etc good fine done.

however when i have 40 of these sheets to do it can be time consuming so i figured just record a macro for creation of the chart and that would work.
the code recorded is:

Please Login or Register  to view this content.

when i run the script the graph is all the correct size however now the x values have defaulted to 1,2...n and the graph has set all 5 cols to y series values.

even odder is that if i select the box that surrounds the columns and drag it at all excel then auto sets the first column of the box to the x values as it does when i create a chart manually.

anyone know:
A) why it dose this? (is the macro not recording everything or is excel not performing an auto format action with macros it dose with manual work?)
B) how to fix the script to get what i want?