Chart.Axes (Word)

Returns a collection of axes on the chart.

Axes (Type, AxisGroup)


With ActiveDocument.InlineShapes(1) 
    If .HasChart Then 
        With .Chart.Axes(xlCategory) 
            .HasTitle = True 
            .AxisTitle.Text = "July Sales" 
        End With 
    End If 
End With

Arguments

Optional arguments

The following arguments are optional

Type (XlAxisType) - The axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3D charts).

Possible return values are xlCategory - Axis displays categories, xlSeriesAxis - Axis displays data series, xlValue - Axis displays values.

AxisGroup (XlAxisGroup) - One of the enumeration values that specifies the axis group. The default is xlPrimary.

Possible return values are xlPrimary - The primary axis group, xlSecondary - The secondary axis group.