This topic has not yet been rated - Rate this topic

ChartSheetBase.Axes Method

Visual Studio 2012

Visual Studio 2010

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

public Object Axes(
	Object type,
	XlAxisGroup axisGroup
)

Parameters

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

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)