python范围缩放_Python实用之openpyxl坐标轴范围和对数缩放

在使用openpyxl时，坐标轴的调整就难住了小编。经过一番资料搜索，不光解决了这个问题还找到了对数缩放的方法，接下来就让我们一起看看吧~

坐标轴最小和最大值

为了在图表上显示特定区域，可以手动设置坐标轴的最小值和最大值。from openpyxl import Workbook

from openpyxl.chart import (

ScatterChart,

Reference,

Series,

)

wb = Workbook()

ws = wb.active

ws.append(['X', '1/X'])

for x in range(-10, 11):

if x:

ws.append([x, 1.0 / x])

chart1 = ScatterChart()

chart1.title = "Full Axes"

chart1.x_axis.title = 'x'

chart1.y_axis.title = '1/x'

chart1.legend = None

chart2 = ScatterChart()

chart2.title = "Clipped Axes"

chart2.x_axis.title = 'x'

chart2.y_axis.title = '1/x'

chart2.legend = None

chart2.x_axis.scaling.min = 0

chart2.y_axis.scaling.min = 0

chart2.x_axis.scaling.max = 11

chart2.y_axis.scaling.max = 1.5

x = Reference(ws, min_col=1, min_row=2, max_row=22)

y = Reference(ws, min_col=2, min_row=2, max_row=22)

s = Series(y, xvalues=x)

chart1.append(s)

chart2.append(s)

ws.add_chart(chart1,