你好,我是一个新手,正在阅读openpyxl的文档。根据文档,这里是我写的代码。
from openpyxl import Workbook
from openpyxl.chart import (BarChart, Reference)
book = Workbook()
sheet = book.active
rows = (
('USA', 46),
('China', 38),
('UK', 29),
('Russia', 22),
('South Korea', 13),
('Germany', 11)
)
for row in rows:
sheet.append(row)
chart = BarChart()
data = Reference(sheet, min_row = 1, max_row=6, min_col=2, max_col=2)
cats = Reference(sheet, min_col=1, min_row=1, max_row=6)
chart.add_data(data)
chart.set_categories(cats)
sheet.add_chart(chart, 'A8')
book.save('chart.xlsx')
我运行了代码,然后使用LibreOffice打开文件,图表没有显示坐标轴。我必须手动“插入/删除坐标轴”才能让它们显示出来。这是由于代码还是LibreOffice引起的?有人可以指出吗?