ChartSheet.Axes(Object, XlAxisGroup) Method

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

public object Axes (object Type, Microsoft.Office.Interop.Excel.XlAxisGroup AxisGroup = Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary);
abstract member Axes : obj * Microsoft.Office.Interop.Excel.XlAxisGroup -> obj
Public Function Axes (Optional Type As Object, Optional AxisGroup As XlAxisGroup = Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary) As Object

Parameters

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

Specifies the axis group. If this argument is omitted, the primary group is used. 3-D charts have only one axis group.

Returns

Object

Examples

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

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";
}

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

Remarks

Optional Parameters

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

Applies to