Chart.AutoScaling Property (2007 System)
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.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public Property AutoScaling As Boolean
'Usage
Dim instance As Chart
Dim value As Boolean
value = instance.AutoScaling
instance.AutoScaling = value
[BrowsableAttribute(false)]
public bool AutoScaling { get; set; }
[BrowsableAttribute(false)]
public:
property bool AutoScaling {
bool get ();
void set (bool value);
}
public function get AutoScaling () : boolean
public function set AutoScaling (value : boolean)
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.