Chart.Paste Method

Article
01/07/2014

Pastes chart data from the Clipboard into the specified Chart control.

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

Syntax

'Declaration
Sub Paste ( _
    Type As Object _
)

void Paste(
    Object Type
)

Parameters

Type
Type: System.Object

Specifies the chart information to paste if a chart is on the Clipboard. Can be one of the following XlPasteType constants: xlPasteFormats, xlPasteFormulas, or xlPasteAll. The default value is xlPasteAll. If there is data other than a chart on the Clipboard, this argument cannot be used.

Remarks

This method changes the current selection.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example creates a Chart and then uses the Paste method to paste additional range data from the Clipboard into the chart.

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

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    ' Set additional range values and copy them to the Clipboard. 
    Me.Range("A6", "A10").Value2 = 11
    Me.Range("B6", "B10").Value2 = 33
    Me.Range("A6", "B10").Copy()

    ' Paste the range data from the Clipboard into the chart.
    Chart1.Paste()
End Sub

private void PasteDataIntoChart()
{
    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;

    // Set additional range values and copy them to  
    // the Clipboard. 
    this.Range["A6", "A10"].Value2 = 11;
    this.Range["B6", "B10"].Value2 = 33;
    this.Range["A6", "B10"].Copy();

    // Paste the range data from the Clipboard into the chart.
    chart1.Paste();
}

.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.

Share via