Chart.HasAxis Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets a value indicating whether a specific axis exists on the Chart control.

public:
 property Microsoft::Office::Tools::Excel::Chart_HasAxisType ^ HasAxis { Microsoft::Office::Tools::Excel::Chart_HasAxisType ^ get(); };

public Microsoft.Office.Tools.Excel.Chart_HasAxisType HasAxis { get; }

member this.HasAxis : Microsoft.Office.Tools.Excel.Chart_HasAxisType

Public ReadOnly Property HasAxis As Chart_HasAxisType

Property Value

Chart_HasAxisType

true if the specified axis exists on the Chart; otherwise, false.

Examples

The following code example creates a Chart and then uses the HasAxis property to hide the primary category axis of the chart.

private void TurnOffCategoryAxis()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DBarClustered;

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

Private Sub TurnOffCategoryAxis()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DBarClustered

    Chart1.HasAxis(Excel.XlAxisType.xlCategory, _
        Excel.XlAxisGroup.xlPrimary) = False
End Sub

Remarks

Use the HasAxis property to hide or show a particular axis on a Chart. 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 <xref:Microsoft.Office.Tools.Excel.Chart._HasAxisType> object that is part of the Office development tools in 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.

Applies to

Share via