Chart.Resize Event
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Occurs when the size of the Chart control is changed.
public:
event Microsoft::Office::Interop::Excel::ChartEvents_ResizeEventHandler ^ Resize;event Microsoft.Office.Interop.Excel.ChartEvents_ResizeEventHandler Resize;member this.Resize : Microsoft.Office.Interop.Excel.ChartEvents_ResizeEventHandler Event Resize As ChartEvents_ResizeEventHandler Event Type
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.
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.");
}
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