Chart.SeriesChange Event

Occurs when the value of a Chart control data point is changed.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Event SeriesChange As ChartEvents_SeriesChangeEventHandler

event ChartEvents_SeriesChangeEventHandler SeriesChange

Examples

The following code example creates a Chart with a handler for the SeriesChange event that sets a point's border color to green when a data point of the chart is changed.

WithEvents SeriesChart As Microsoft.Office.Tools.Excel.Chart

Private Sub ChangePointColorWhenSeriesChange()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    SeriesChart = Me.Controls.AddChart(Me.Range("D2", "H12"), _
        "SeriesChart")
    SeriesChart.SetSourceData(Me.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    SeriesChart.ChartType = Excel.XlChartType.xl3DColumn
End Sub

Sub SeriesChart_SeriesChange(ByVal SeriesIndex As Integer, _
    ByVal PointIndex As Integer) Handles SeriesChart.SeriesChange

    Dim series1 As Excel.Series = _
         CType(SeriesChart.SeriesCollection(SeriesIndex), _
         Excel.Series)
    Dim point1 As Excel.Point = _
        CType(series1.Points(PointIndex), Excel.Point)

    point1.Border.Color = _
            ColorTranslator.ToOle(Color.Green)
End Sub

Microsoft.Office.Tools.Excel.Chart seriesChart;

private void ChangePointColorWhenSeriesChange()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    seriesChart = this.Controls.AddChart(this.Range["D2", "H12"],
        "seriesChart");
    seriesChart.SetSourceData(this.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    seriesChart.ChartType = Excel.XlChartType.xl3DColumn;

    seriesChart.SeriesChange +=
        new Excel.ChartEvents_SeriesChangeEventHandler(
        seriesChart_SeriesChange);
}

void seriesChart_SeriesChange(int SeriesIndex, int PointIndex)
{
    Excel.Series series1 =
        (Excel.Series)seriesChart.SeriesCollection(SeriesIndex);
    Excel.Point point1 = (Excel.Point)series1.Points(PointIndex);

    point1.Border.Color =
        ColorTranslator.ToOle(Color.Green);
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace