Chart.HasAxis Property (2007 System)
Gets or sets a value indicating whether a specific axis exists on the Chart control.
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 ReadOnly Property HasAxis As Chart._HasAxisType
'Usage
Dim instance As Chart
Dim value As Chart._HasAxisType
value = instance.HasAxis
[BrowsableAttribute(false)]
public Chart._HasAxisType HasAxis { get; }
[BrowsableAttribute(false)]
public:
property Chart._HasAxisType^ HasAxis {
Chart._HasAxisType^ get ();
}
public function get HasAxis () : Chart._HasAxisType
Property Value
Type: Microsoft.Office.Tools.Excel.Chart._HasAxisType
true if the specified axis exists on the Chart; otherwise, false.
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 Chart._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 creates a Chart and then uses the HasAxis property to hide the primary category axis of the chart.
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
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;
}
.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.