Export (0) Print
Expand All
Expand Minimize

ChartSheetBase.HasAxis Property

Gets or sets a value indicating whether a specific axis exists on the Microsoft.Office.Tools.Excel.ChartSheetBase.

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

public ChartSheet_HasAxisType HasAxis { get; }

Property Value

Type: Microsoft.Office.Tools.Excel.ChartSheet_HasAxisType
true if the specified axis exists on the Microsoft.Office.Tools.Excel.ChartSheetBase; otherwise, false.

Use the HasAxis property to hide or show a particular axis on a Microsoft.Office.Tools.Excel.ChartSheetBase. The HasAxis property is intended to be used with the following parameters.

Parameter

Description

Index1

One of the XlAxisType values that specifies the axis type. Series axes apply only to 3-D charts.

Index2

One of the XlAxisGroup values that specifies the axis group. 3-D charts have only one set of axes.

If you attempt to use HasAxis without specifying parameters, HasAxis will get a _HasAxisType object that is part of the Visual Studio infrastructure and is not intended to be used directly from your code.

Microsoft Office Excel may create or delete axes if you change the chart type or the AxisGroup property.

Optional Parameters

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

The following code example uses the HasAxis property to hide the primary category axis of the current Microsoft.Office.Tools.Excel.ChartSheetBase.

private void TurnOffCategoryAxis()
{
    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;

    this.HasAxis[Excel.XlAxisType.xlCategory,
        Excel.XlAxisGroup.xlPrimary] = false;
}

Show:
© 2014 Microsoft