Share via

ChartSheet.HeightPercent Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets or sets the height of a 3-D chart as a percentage of the ChartSheet width.

public:
 property int HeightPercent { int get(); void set(int value); };
public int HeightPercent { get; set; }
member this.HeightPercent : int with get, set
Public Property HeightPercent As Integer

Property Value

Int32

The height of a 3-D chart as a percentage of the ChartSheet width (between 5 and 500 percent).

Examples

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

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;
}

Private Sub AdjustHeight()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DBarClustered
    Me.HeightPercent = 50
End Sub

Applies to