Chart.PrintPreview Method (2007 System)

Shows a preview of the Chart control as it would look when printed.

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

Syntax

'Declaration
Public Sub PrintPreview ( _
    EnableChanges As Object _
)

'Usage
Dim instance As Chart 
Dim EnableChanges As Object

instance.PrintPreview(EnableChanges)

public void PrintPreview(
    Object EnableChanges
)

public:
void PrintPreview(
    Object^ EnableChanges
)

public function PrintPreview(
    EnableChanges : Object
)

Parameters

• EnableChanges
  Type: System.Object

  true if changes can be made to the print preview window; otherwise, false.

Examples

The following code example creates a Chart and then uses the PrintPreview method to preview the printout of the chart.

Private Sub PreviewChart()
    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

    Chart1.PrintPreview(False)
End Sub

private void PreviewChart()
{
    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.PrintPreview(false);
}

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

Chart Members

Microsoft.Office.Tools.Excel Namespace