对于我使用的二维绘图
graphicalProperties.line.solidFill
和
graphicalProperties.solidFill
:
wb = load_workbook('data.xlsx')
ws = wb['sheet1']
chart = BarChart()
chart.type = "col"
chart.style = 10
chart.title = "Chart Title"
chart.y_axis.title = 'Y Axis'
chart.x_axis.title = 'X Axis'
data = Reference(ws, min_col=3, min_row=1, max_row=3, max_col=3)
cats = Reference(ws, min_col=1, min_row=2, max_row=3)
chart.add_data(data, titles_from_data=True)
chart.set_categories(cats)
chart.shape = 4
# Change bar filling and line color
s = chart.series[0]
s.graphicalProperties.line.solidFill = "00000"
s.graphicalProperties.solidFill = "ff9900"
ws.add_chart(chart, "A10")
wb.save("bar.xlsx")
我希望3D绘图也一样
