Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the height of a 3-D chart as a percentage of the Chart control 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 Chart
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 Chart control width (between 5 and 500 percent).
Examples
The following code example creates a 3-D Chart and then changes the height of the chart to 250 percent of the chart width by using the HeightPercent property.
Private Sub SetHeightPercent()
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.HeightPercent = 250
End Sub
private void SetHeightPercent()
{
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.HeightPercent = 250;
}
.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.