Export (0) Print
Expand All
Expand Minimize

ChartSheetBase.HeightPercent Property

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Gets or sets the height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheetBase width.

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

public int HeightPercent { get; set; }

Property Value

Type: System.Int32
The height of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheetBase width (between 5 and 500 percent).

The following code example uses the HeightPercent property to set the height of the current Microsoft.Office.Tools.Excel.ChartSheetBase to 50 percent of the width of the Microsoft.Office.Tools.Excel.ChartSheetBase.

private void AdjustHeight()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DBarClustered; 
    this.HeightPercent = 50;
}

Show:
© 2014 Microsoft