Udostępnij za pośrednictwem

Chart.AutoScaling Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.dll

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, set
Public Property AutoScaling As Boolean

Property Value

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 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

Applies to