Share via


ChartSheet.HeightPercent Property

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

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

Syntax

'Declaration
Property HeightPercent As Integer
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.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 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
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;
}

.NET Framework Security

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace