D
David
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
3 range.
How can I programmatically create a Custom error bars over a point serie?
TIA
DAvid
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
3 range.How can I programmatically create a Custom error bars over a point serie?
TIA
DAvid