excel error bar command chart generation

Scripting Forums AppleScript | Mac OS X
,
#1

hello,
I need some help with converting the following vb code to Applescript.
I have managed to get the command to work with series that have only one data point,
the one I am trying to get it to work with has 6:
“”
ActiveChart.SeriesCollection(2).ErrorBar Direction:=xlY, Include:=xlBoth, _
Type:=xlCustom, Amount:=“={100,100,100,100,100,100}”, MinusValues:= _
“={100,100,100,100,100,100}”
“”

I tried the following:


tell application "Microsoft Excel"
	error bar series 2 of active chart direction error bar direction y include error bar include both type error bar type custom amount "={100, 100, 100, 100, 100, 100}" minus values "={100, 100, 100, 100, 100, 100}"
end tell

and


tell application "Microsoft Excel"
	error bar series 2 of active chart direction error bar direction y include error bar include both type error bar type custom amount {100, 100, 100, 100, 100, 100} minus values {100, 100, 100, 100, 100, 100}
end tell

the time I got the command to work (that is to say with only 1 data point) I used:


tell application "Microsoft Excel"
	error bar series 2 of active chart direction error bar direction y include error bar include both type error bar type fixed value amount 100
end tell

the command is “NOT SUPPORTED” by micro$oft so I can’t check the excel reference manual, and the AS dictionary does not help either

Thanks,
Nick