Chart.DragPlot 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 a range of cells is dragged and dropped on the Chart control.
public:
event Microsoft::Office::Interop::Excel::ChartEvents_DragPlotEventHandler ^ DragPlot;event Microsoft.Office.Interop.Excel.ChartEvents_DragPlotEventHandler DragPlot;member this.DragPlot : Microsoft.Office.Interop.Excel.ChartEvents_DragPlotEventHandler Event DragPlot As ChartEvents_DragPlotEventHandler Event Type
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.
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.");
}
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