Syntax
Private Sub Chart_SeriesChange(ByVal SeriesIndex As Long, ByVal PointIndex As Long)
Enter
Code
End Sub
This event will run code when the user
changes the value of a chart data point by clicking a bar in the chart and
dragging the top edge up or down thus changing the value of the data point.
Required Parameters
SeriesIndex
The offset within the Series Collection for
the changed series.
PointIndex
The offset within the Points Collection for
the changed point.
Example
Private Sub Chart_SeriesChange(ByVal SeriesIndex As Long, _
ByVal
PointIndex As Long)
Set p
= Me.SeriesCollection(SeriesIndex).Points(PointIndex)
p.Border.ColorIndex = 3
End Sub
Result
This example changes the point's border color when the
user changes the point value.
