Share via


ChartSheetBase.Axes Method

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

  • axisGroup
    Type: 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

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace