Share via


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

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace