log_base property

AxisScaling.log_base property

Gets or sets the logarithmic base for a logarithmic axis.

@property
def log_base(self) -> float:
    ...

@log_base.setter
def log_base(self, value: float):
    ...

Remarks

The property is not supported by MS Office 2016 new charts.

Valid range of a floating point value is greater than or equal to 2 and less than or equal to 1000. The property has effect only if AxisScaling.type is set to AxisScaleType.LOGARITHMIC.

Setting this property sets the AxisScaling.type property to AxisScaleType.LOGARITHMIC.

Examples

Shows how to apply logarithmic scaling to a chart axis.

doc = aw.Document()
builder = aw.DocumentBuilder(doc=doc)
chart_shape = builder.insert_chart(chart_type=aw.drawing.charts.ChartType.SCATTER, width=450, height=300)
chart = chart_shape.chart
# Clear the chart's demo data series to start with a clean chart.
chart.series.clear()
# Insert a series with X/Y coordinates for five points.
chart.series.add(series_name='Series 1', x_values=[1, 2, 3, 4, 5], y_values=[1, 20, 400, 8000, 160000])
# The scaling of the X-axis is linear by default,
# displaying evenly incrementing values that cover our X-value range (0, 1, 2, 3...).
# A linear axis is not ideal for our Y-values
# since the points with the smaller Y-values will be harder to read.
# A logarithmic scaling with a base of 20 (1, 20, 400, 8000...)
# will spread the plotted points, allowing us to read their values on the chart more easily.
chart.axis_y.scaling.type = aw.drawing.charts.AxisScaleType.LOGARITHMIC
chart.axis_y.scaling.log_base = 20
doc.save(file_name=ARTIFACTS_DIR + 'Charts.AxisScaling.docx')

log_base property

AxisScaling.log_base property

Remarks

Examples

See Also