Chart.PageSetup Property

Gets a PageSetup that contains all the page setup settings for the specified object.

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

Syntax

'Declaration
ReadOnly Property PageSetup As PageSetup
    Get

PageSetup PageSetup { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.PageSetup
A PageSetup that contains all the page setup settings for the specified object.

Examples

The following code example creates a Chart and then uses the PageSetup property to modify the orientation.

Private Sub SetPageOrientation()
    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.PageSetup.Orientation = Excel.XlPageOrientation.xlPortrait
End Sub

private void SetPageOrientation()
{
    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.PageSetup.Orientation = 
        Excel.XlPageOrientation.xlPortrait;
}

.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