Chart.Resize Event

Occurs when the size of the Chart control is changed.

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

Syntax

'Declaration
Event Resize As ChartEvents_ResizeEventHandler

event ChartEvents_ResizeEventHandler Resize

Examples

The following code example creates a Chart with a handler for the Resize event that displays a message box when the chart is resized.

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

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

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

Sub ResizeChart_Resize() Handles ResizeChart.Resize
    MsgBox("The chart was resized.")
End Sub

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

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

    chart1.Resize +=
        new Excel.ChartEvents_ResizeEventHandler(chart1_Resize);
}

void chart1_Resize()
{
    MessageBox.Show("The chart was resized.");
}

.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