Thread: VBA ErrorBar method does not allow custom minusvalues
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
  
Posts: 493
Default 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?
Reply With QuoteReply With Quote