Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Error Bars in Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 - Custom error bars ?? | Charts and Charting in Excel | |||
cUSTOM error Bars in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Custom Error Bars | Excel Discussion (Misc queries) | |||
Custom error bars excel 2007 | Charts and Charting in Excel |