Chart.Axes method (Excel)
Returns an object that represents either a single axis or a collection of the axes on the chart.
Syntax
expression.Axes (Type, AxisGroup)
expression A variable that represents a Chart object.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
Type | Optional | Variant | Specifies the axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3D charts). |
AxisGroup | Optional | XlAxisGroup | Specifies the axis group. If this argument is omitted, the primary group is used. 3D charts have only one axis group. |
Return value
Object
Example
This example adds an axis label to the category axis on Chart1.
With Charts("Chart1").Axes(xlCategory)
.HasTitle = True
.AxisTitle.Text = "July Sales"
End With
This example turns off major gridlines for the category axis on Chart1.
Charts("Chart1").Axes(xlCategory).HasMajorGridlines = False
This example turns off all gridlines for all axes on Chart1.
For Each a In Charts("Chart1").Axes
a.HasMajorGridlines = False
a.HasMinorGridlines = False
Next a
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om