ChartSheet.SelectEvent Event


Occurs when the Microsoft.Office.Tools.Excel.ChartSheet is selected.

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

event ChartEvents_SelectEventHandler SelectEvent

The following code example demonstrates a handler for the SelectEvent event that displays a message box when the primary axis of the current Microsoft.Office.Tools.Excel.ChartSheet is selected.

private void DisplayPrimaryAxisSelections()
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
    this.ChartType = Excel.XlChartType.xl3DColumn;

    this.SelectEvent +=
        new Excel.ChartEvents_SelectEventHandler(

void ChartSheet1_SelectEvent(int ElementID, int Arg1, int Arg2)
    if (Excel.XlChartItem.xlAxis == (Excel.XlChartItem)ElementID)
        if (Excel.XlAxisGroup.xlPrimary == (Excel.XlAxisGroup)Arg1)
            MessageBox.Show("The primary axis of the chart " +
                "sheet was selected.");
Return to top