用openpyx创建两个yaxis图表

Question

我试图在openpyxl中创建一个有两个轴的图表

# data is a sheet
# chart_data is a dataframe that's already been pasted onto the data sheet
# the first column of the dataframe is date (x-axis) and columns 2 and 3 are the two lines of the graph
chart = LineChart()
chart_data = Reference(data, min_col=2, max_col=3, min_row=1, max_row=len(chart_data))
chart.add_data(chart_data, titles_from_data=True)

labels = Reference(data, min_col=1, max_col=1, min_row=2, max_row=len(chart_data))

chart.title = 'Title'
chart.set_categories(labels)

chart.legend.position = 't'
chart.height = 20
chart.width = 25
chart.x_axis.tickLblPos = "low"
chart.x_axis.tickLblSkip = 30
chart.y_axis.number_format = '#,##0'

ws = wb['sheet_to_paste_chart']
ws.add_chart(chart, 'B24')

y轴实际上是相同的数据。但是我希望左边的y轴是y值/1000，右边的y轴是y值/100万。在

他们也将分别被标记为“千人”和“百万人”。在