Chart.DragPlot Event

Occurs when a range of cells is dragged and dropped on the Chart control.

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

Syntax

'Declaration
Event DragPlot As ChartEvents_DragPlotEventHandler

event ChartEvents_DragPlotEventHandler DragPlot

Examples

The following code example creates a Chart with a handler for the DragPlot event that displays a message box when a range of cells is dragged and dropped on the chart.

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

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

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

Sub DragPlotChart_DragPlot() Handles DragPlotChart.DragPlot
    MsgBox("A range was dragged and dropped on the chart.")
End Sub

private void DisplayDragPlot()
{
    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.DragPlot +=
        new Excel.ChartEvents_DragPlotEventHandler(
        chart1_DragPlot);
}

void chart1_DragPlot()
{
    MessageBox.Show("A range was dragged and dropped on the chart.");
}

.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