ChartSheetBase.Calculate 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 after the ChartSheetBase plots new or changed data.
public:
event Microsoft::Office::Interop::Excel::ChartEvents_CalculateEventHandler ^ Calculate;public event Microsoft.Office.Interop.Excel.ChartEvents_CalculateEventHandler Calculate;member this.Calculate : Microsoft.Office.Interop.Excel.ChartEvents_CalculateEventHandler Public Custom Event Calculate As ChartEvents_CalculateEventHandler Event Type
Examples
The following code example demonstrates a handler for the Calculate event that displays a message box when the source data of the current Microsoft.Office.Tools.Excel.ChartSheetBase changes.
private void DisplayCalculations()
{
Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
Globals.Sheet1.Range["B1", "B5"].Value2 = 55;
this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
this.ChartType = Excel.XlChartType.xl3DColumn;
this.Calculate +=
new Excel.ChartEvents_CalculateEventHandler(
ChartSheet1_Calculate);
// This will raise the Calculate event.
Globals.Sheet1.Range["A1"].Value2 = 11;
}
void ChartSheet1_Calculate()
{
MessageBox.Show("The chart sheet plotted new data.");
}
Private Sub DisplayCalculations()
Globals.Sheet1.Range("A1", "A5").Value2 = 22
Globals.Sheet1.Range("B1", "B5").Value2 = 55
Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
Me.ChartType = Excel.XlChartType.xl3DColumn
' This will raise the Calculate event.
Globals.Sheet1.Range("A1").Value2 = 11
End Sub
Sub ChartSheet1_Calculate() Handles Me.Calculate
MsgBox("The chart sheet plotted new data.")
End Sub