M
MrGlass
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
When adding custom error bars to a bar chart using applescript it seems that I can only choose a REAL (number) at ammount or minus value.
When using "format dataseries" from within excel i can choose a range just fine, but this is not an option using applescript.
Examples:
error bar direction error bar direction y include error bar include both type error bar type custom amount 100 minus values 50
Works fine
but
error bar direction error bar direction y include error bar include both type error bar type custom amount "=FD!R54C9" minus values "=FD!R54C9"
fails with the message:
series 1 does not understand the error bar message
(also tried with A1 syntax)
using excel 12.1.3
Martin
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
When adding custom error bars to a bar chart using applescript it seems that I can only choose a REAL (number) at ammount or minus value.
When using "format dataseries" from within excel i can choose a range just fine, but this is not an option using applescript.
Examples:
error bar direction error bar direction y include error bar include both type error bar type custom amount 100 minus values 50
Works fine
but
error bar direction error bar direction y include error bar include both type error bar type custom amount "=FD!R54C9" minus values "=FD!R54C9"
fails with the message:
series 1 does not understand the error bar message
(also tried with A1 syntax)
using excel 12.1.3
Martin