Chart.AutoScaling Property
Scales a 3-D chart so that it is closer in size to the equivalent 2-D chart.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property AutoScaling As Boolean
bool AutoScaling { get; set; }
Property Value
Type: System.Boolean
true if Microsoft Office Excel scales a 3-D chart so that it is closer in size to the equivalent 2-D chart; otherwise, false. The RightAngleAxes property must be true.
Examples
The following code example creates a 3-D Chart and then sets the AutoScaling property to true to automatically scale the chart. The example sets the RightAngleAxes property to true before the AutoScaling property is set.
Private Sub SetAutoScaling()
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.RightAngleAxes = True
Chart1.AutoScaling = True
End Sub
private void SetAutoScaling()
{
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.RightAngleAxes = true;
chart1.AutoScaling = true;
}
.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.