ChartSheet.HeightPercent Property (2007 System)
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
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Property HeightPercent As Integer
'Usage
Dim instance As ChartSheet
Dim value As Integer
value = instance.HeightPercent
instance.HeightPercent = value
public int HeightPercent { get; set; }
public:
property int HeightPercent {
int get ();
void set (int value);
}
public function get HeightPercent () : int
public function set HeightPercent (value : int)
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
- 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.