Axis class

Axis class

Encapsulates the object that represents a chart’s axis.

The Axis type exposes the following members:

Properties

PropertyDescription
chartReturns the parent chart.
Read-only IChart.
axis_between_categoriesRepresents if the value axis crosses the category axis between categories.
This property applies only to category axes, and it doesn’t apply to 3-D charts.
Read/write bool.
category_axis_typeSpecifies the type of the category axis.
Read/write CategoryAxisType.
cross_atRepresents the point on the axis where the perpendicular axis crosses it.
Read/write float.
display_unitSpecifies the scaling value of the display units for the value axis.
Read/write DisplayUnitType.
actual_max_valueSpecifies actual maximum value on the axis. Call method IChart.ValidateChartLayout() previously to get actual value.
actual_min_valueSpecifies actual minimum value on the axis. Call method IChart.ValidateChartLayout() previously to get actual value.
actual_major_unitSpecifies actual major unit of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.
actual_minor_unitSpecifies actual minor unit of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.
actual_major_unit_scaleSpecifies actual major unit scale of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.
actual_minor_unit_scaleSpecifies actual minor unit scale of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.
is_automatic_max_valueIndicates whether the max value is automatically assigned.
Read/write bool.
max_valueRepresents the maximum value on the value axis.
Read/write float.
minor_unitRepresents the minor units for the date or value axis.
Read/write float.
is_automatic_minor_unitIndicates whether the minor unit of the axis is automatically assigned.
Read/write bool.
major_unitRepresents the major units for the date or value axis.
Read/write float.
is_automatic_major_unitIndicates whether the major unit of the axis is automatically assigned.
Read/write bool.
is_automatic_min_valueIndicates whether the min value is automatically assigned.
Read/write bool.
min_valueRepresents the minimum value on the value axis.
Read/write float.
is_logarithmicRepresents if the value axis scale type is logarithmic or not.
Read/write bool.
log_baseRepresents the logarithmic base. Default value is 10.
Read/write float.
is_plot_order_reversedRepresents if MS PowerPoint plots data points from last to first.
Read/write bool.
is_visibleRepresents if the axis is visible.
Read/write bool.
major_tick_markRepresents the type of major tick mark for the specified axis.
Read/write TickMarkType.
minor_tick_markRepresents the type of minor tick mark for the specified axis.
Read/write TickMarkType.
tick_label_positionRepresents the position of tick-mark labels on the specified axis.
Read/write TickLabelPositionType.
major_unit_scaleRepresents the major unit scale for the date axis.
Read/write TimeUnitType.
minor_unit_scaleRepresents the major unit scale for the date axis.
Read/write TimeUnitType.
base_unit_scaleSpecifies the smallest time unit that is represented on the date axis.
Read/write TimeUnitType.
minor_grid_lines_formatRepresents minor gridlines format on a chart axis.
Read-only IChartLinesFormat.
major_grid_lines_formatRepresents major gridlines format on a chart axis.
Read-only IChartLinesFormat.
show_minor_grid_linesTo hide minor gridline set MinorGridLinesFormat.Line.FillFormat.FillType to FillType.NoFill.
Read-only bool.
show_major_grid_linesTo hide major gridline set MajorGridLinesFormat.Line.FillFormat.FillType to FillType.NoFill.
Read-only bool.
formatRepresents format of axis.
Read-only IAxisFormat.
text_formatRepresents format of text.
Read-only IChartTextFormat.
titleGets the axis’ title.
Read-only IChartTitle.
cross_typeRepresents the CrossType on the specified axis where the other axis crosses.
Read/write CrossesType.
positionRepresents position of axis.
Read/write AxisPositionType.
has_titleDetermines whether a axis has a visible title.
Read/write bool.
number_formatRepresents the format string for the Axis Labels.
Read/write str.
is_number_format_linked_to_sourceIndicates whether the format is linked source data.
Read/write bool.
tick_label_rotation_angleRepresents the rotation angle of tick labels.
Read/write float.
tick_label_spacingSpecifies how many tick labels to skip between label that is drawn. Applied to category or series axis.
Read/write int.
is_automatic_tick_label_spacingSpecifies automatic tick label spacing value. If false: use TickLabelSpacing property.
Read/write bool.
tick_marks_spacingSpecifies how many tick marks shall be skipped before the next one shall be
drawn. Applied to category or series axis.
Read/write int.
is_automatic_tick_marks_spacingSpecifies automatic tick marks spacing value. If false: use TickMarksSpacing property.
Read/write bool.
label_offsetSpecifies the distance of labels from the axis. Applied to category or date axis. Value must be between 0% and 1000%.
Read/write int.
aggregation_typeRepresents aggregation type of category axis (binning). Applied to category. Used with Histogram or HistogramPareto series only.
bin_widthSpecifies bin width when AggregationType property value setted to AxisAggregationType.ByBinWidth.
Applied to category axes. Used with Histogram or HistogramPareto series only.
number_of_binsSpecifies number of bins when AggregationType property value setted to AxisAggregationType.ByNumberOfBins.
Applied to category axes. Used with Histogram or HistogramPareto series only.
is_overflow_binSpecifies if overflow bin applied. Use IsAutomaticOverflowBin and OverflowBin to adjust overflow bin value.
is_automatic_overflow_binSpecifies automatic overflow bin value. If false: use OverflowBin property.
overflow_binSpecifies overflow bin custom value. Applied when IsAutomaticOverflowBin property setted to false and IsOverflowBin property equals true.
is_underflow_binSpecifies if underflow bin applied. Use IsAutomaticUnderflowBin and UnderflowBin to adjust underflow bin value.
is_automatic_underflow_binSpecifies automatic underflow bin value. If false: use UnderflowBin property.
underflow_binSpecifies underflow bin custom value. Applied when IsAutomaticUnderflowBin property setted to false and IsUnderflowBin property equals true.
slide
presentation

Methods

MethodDescription
set_category_axis_type_automaticallySets IAxis.CategoryAxisType property with a value that is automatically determined based on axis data.

See Also