ValueAxis

An axis having continuous (as opposed to discrete) values.

The vertical axis is generally a value axis, however both axes of an XY-type chart are value axes.

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.

`crosses`

attributecrosses

Member of :ref:XlAxisCrosses enumeration specifying the point on this axis where the other axis crosses, such as auto/zero, minimum, or maximum. Returns XL_AXIS_CROSSES.CUSTOM when a specific numeric crossing point (e.g. 1.5) is defined.

`crosses_at`

attributecrosses_at

Numeric value on this axis at which the perpendicular axis crosses. Returns None if no crossing value is set.

`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.

`major_unit`

attributemajor_unit

The float number of units between major tick marks on this value axis. None corresponds to the 'Auto' setting in the UI, and specifies the value should be calculated by PowerPoint based on the underlying chart data.

`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.

`minor_unit`

attributeminor_unit

The float number of units between minor tick marks on this value axis. None corresponds to the 'Auto' setting in the UI, and specifies the value should be calculated by PowerPoint based on the underlying chart data.

`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.