CategoryAxis

A category axis of a chart.

Attributes

`axis_title`

attributeaxis_title

An AxisTitle object providing access to title properties.

Calling this property is destructive in the sense that it adds an axis title element (c:title) to the axis XML if one is not already present. Use :attr:has_title to test for presence of axis title non-destructively.

`category_type`

attributecategory_type

A member of :ref:XlCategoryType specifying the scale type of this axis. Unconditionally CATEGORY_SCALE for a CategoryAxis object.

`format`

attributeformat

The ChartFormat object providing access to the shape formatting properties of this axis, such as its line color and fill.

`has_major_gridlines`

attributehas_major_gridlines

Read/write boolean value specifying whether this axis has gridlines at its major tick mark locations. Assigning True to this property causes major gridlines to be displayed. Assigning False causes them to be removed.

`has_minor_gridlines`

attributehas_minor_gridlines

Read/write boolean value specifying whether this axis has gridlines at its minor tick mark locations. Assigning True to this property causes minor gridlines to be displayed. Assigning False causes them to be removed.

`has_title`

attributehas_title

Read/write boolean specifying whether this axis has a title.

True if this axis has a title, False otherwise. Assigning True causes an axis title to be added if not already present. Assigning False causes any existing title to be deleted.

`major_gridlines`

attributemajor_gridlines

The MajorGridlines object representing the major gridlines for this axis.

`major_tick_mark`

attributemajor_tick_mark

Read/write :ref:XlTickMark value specifying the type of major tick mark to display on this axis.

`maximum_scale`

attributemaximum_scale

Read/write float value specifying the upper limit of the value range for this axis, the number at the top or right of the vertical or horizontal value scale, respectively. The value None indicates the upper limit should be determined automatically based on the range of data point values associated with the axis.

`minimum_scale`

attributeminimum_scale

Read/write float value specifying lower limit of value range, the number at the bottom or left of the value scale. None if no minimum scale has been set. The value None indicates the lower limit should be determined automatically based on the range of data point values associated with the axis.

`minor_tick_mark`

attributeminor_tick_mark

Read/write :ref:XlTickMark value specifying the type of minor tick mark for this axis.

`reverse_order`

attributereverse_order

Read/write bool value specifying whether to reverse plotting order for axis.

For a category axis, this reverses the order in which the categories are displayed. This may be desired, for example, on a (horizontal) bar-chart where by default the first category appears at the bottom. Since we read from top-to-bottom, many viewers may find it most natural for the first category to appear on top.

For a value axis, it reverses the direction of increasing value from bottom-to-top to top-to-bottom.