ChartSheetBase.Axes Method

Article
07/25/2011

Gets an object that represents either a single axis or a collection of the axes on the chart.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Function Axes ( _
    type As Object, _
    axisGroup As XlAxisGroup _
) As Object

public Object Axes(
    Object type,
    XlAxisGroup axisGroup
)

Parameters

type
Type: System.Object
Specifies the axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3-D charts).

axisGroup
Type: Microsoft.Office.Interop.Excel.XlAxisGroup
Specifies the axis group. If this argument is omitted, the primary group is used. 3-D charts have only one axis group.

Return Value

Type: System.Object

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example uses the Axes method to set the title of the primary axis of the current Microsoft.Office.Tools.Excel.ChartSheetBase.

Private Sub SetAxisText()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn

    Dim Axis1 As Excel.Axis = _
        CType(Me.Axes(Excel.XlAxisType.xlValue, _
        Excel.XlAxisGroup.xlPrimary), Excel.Axis)
    Axis1.HasTitle = True
    Axis1.AxisTitle.Text = "Sales Figures"
End Sub

private void SetAxisText()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    Excel.Axis axis = (Excel.Axis)this.Axes(Excel.XlAxisType.xlValue,
        Excel.XlAxisGroup.xlPrimary);

    axis.HasTitle = true;
    axis.AxisTitle.Text = "Sales Figures";
}

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

Share via