AppEvents_Event.WorkbookNewChart Event

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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 a new chart is created in any open workbook.

public:
 event Microsoft::Office::Interop::Excel::AppEvents_WorkbookNewChartEventHandler ^ WorkbookNewChart;

event Microsoft.Office.Interop.Excel.AppEvents_WorkbookNewChartEventHandler WorkbookNewChart;

Event WorkbookNewChart As AppEvents_WorkbookNewChartEventHandler

Event Type

AppEvents_WorkbookNewChartEventHandler

Remarks

The WorkbookNewChart event occurs when a new chart is inserted or pasted in a worksheet, a chart sheet, or other sheet types. If multiple charts are inserted or pasted, the event will occur for each chart in the order they are inserted or pasted. If a chart object or chart sheet is moved from one location to another, the event will not occur. However, if the chart is moved between a chart object and a chart sheet, the event will occur because a new chart must be created.

The WorkbookNewChart event will not occur in the following scenarios: copying or pasting a chart sheet, changing a chart type, changing a chart data source, undoing or redoing inserting or pasting a chart, and loading a workbook that contains a chart.

Applies to