On Error Resume Next
Dim mWb As Workbook
Dim mWs As Worksheet
Dim trGraph As ChartObject
Dim errRange As Range
Set mWb = ActiveWorkbook
Set mWs = mWb.ActiveSheet
Set trGraph = mWs.ChartObjects(1)
Set errRange = mWs.Range(mWs.Cells(13, 4), mWs.Cells(21, 4))
trGraph.Chart.FullSeriesCollection(21).HasErrorBars = True
trGraph.Chart.FullSeriesCollection(21).ErrorBars.EndStyle = xlNoCap
trGraph.Chart.FullSeriesCollection(21).ErrorBar Direction:=xlY, Include:=xlY, Type:=xlFixedValue, Amount:=0
trGraph.Chart.FullSeriesCollection(21).ErrorBar Direction:=xlX, Include:=xlMinusValues, Type:=xlCustom, Amount:=errRange
If Err.Number <> 0 Then
MsgBox ("err1=" & Err.Description)
End If