ChartSheet.Axes Method (2007 System)

Article
10/30/2012

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.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
Public Function Axes ( _
    Type As Object, _
    AxisGroup As XlAxisGroup _
) As Object

'Usage
Dim instance As ChartSheet 
Dim Type As Object 
Dim AxisGroup As XlAxisGroup 
Dim returnValue As Object 

returnValue = instance.Axes(Type, AxisGroup)

public Object Axes(
    Object Type,
    XlAxisGroup AxisGroup
)

public:
Object^ Axes(
    Object^ Type, 
    XlAxisGroup AxisGroup
)

public function Axes(
    Type : Object, 
    AxisGroup : XlAxisGroup
) : Object

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: 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 The Variable missing and 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.ChartSheet.

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.