Chart.AutoScaling Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Scales a 3-D chart so that it is closer in size to the equivalent 2-D chart.
public:
property bool AutoScaling { bool get(); void set(bool value); };public bool AutoScaling { get; set; }member this.AutoScaling : bool with get, setPublic Property AutoScaling As BooleanProperty Value
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 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;
}
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