ChartSheet.HasAxis Property (2007 System)

Article
10/30/2012

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

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Overridable ReadOnly Property HasAxis As ChartSheet._HasAxisType

'Usage
Dim instance As ChartSheet 
Dim value As ChartSheet._HasAxisType 

value = instance.HasAxis

[BrowsableAttribute(false)]
public virtual ChartSheet._HasAxisType HasAxis { get; }

[BrowsableAttribute(false)]
public:
virtual property ChartSheet._HasAxisType^ HasAxis {
    ChartSheet._HasAxisType^ get ();
}

public function get HasAxis () : ChartSheet._HasAxisType

Property Value

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

Remarks

Use the HasAxis property to hide or show a particular axis on a Microsoft.Office.Tools.Excel.ChartSheet. 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 ChartSheet._HasAxisType object that is part of the Visual Studio Tools for Office 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 The Variable missing and Optional Parameters in Office Solutions.

Examples

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

Private Sub TurnOffCategoryAxis()
    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
    Me.HasAxis(Excel.XlAxisType.xlCategory, _
        Excel.XlAxisGroup.xlPrimary) = False 
End Sub

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

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

Share via