[Excel 2010] fails to record macro for Custom Error Bars
 

Please help!

I want to automate the "custom error bars" creation in a series of
xy-charts, but the macro recorder seems to fail into recording actions.
These are the steps to reproduce the problem:
0. create 4 columns (A1:C3) with few rows of numbers
1. create a xy-chart from columns A1:B3
2. select the chart and activate the recorder
3. in the "chart tools" select tab "Layout"
4. select the button "Error bars" and choose "More error bars options..."
5. in the Format Error bars window select the "Custom:" radio button and
press the "Specify value" button
6. with the "positive error value" box highlighted, select the range C1:C3
7. stop the recorder
8. things run smooth till here, but...
9. delete the chart and repeat step 1
10. select the chart and run the macro recorded: you get a "Type mismatch"
error

If you look at the code you find no reference to the D1:D3 range.

How can I programmatically create a Custom error bars over a point serie?

TIA

DAvid