Using applescript to add custom error bars

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top