ExcelBanter - VBA ErrorBar method does not allow custom minusvalues

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA ErrorBar method does not allow custom minusvalues (https://www.excelbanter.com/excel-programming/415370-vba-errorbar-method-does-not-allow-custom-minusvalues.html)

ALEX

VBA ErrorBar method does not allow custom minusvalues

This does not work in Excel2007 VBA, but works in previous versions.

ActiveChart.SeriesCollection(1).ErrorBar Direction:=xlY, Include:= _
xlMinusValues, Type:=xlCustom, minusvalues:=Sheet4.Range("B2:B102")

Is there a workaround?

All times are GMT +1. The time now is 01:21 PM.