Change angle of gradient chart bars in xlxswriter

Question

Hi how do I change the angle of the angle in the bars - is there an option like 'angle' : 90?

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community, Jul 27 '22 at 14:10

score 0 · Accepted Answer · answered Jul 27 '22 at 15:32

You can set the chart gradient fill angle in XlsxWriter like this:

chart.add_series({
    'values': '=Sheet1!$A$1:$A$6',
    'gradient': {'colors': ['#DDEBCF', '#9CB86E', '#156B13'],
                 'angle': 45}
})

See the Chart formatting: Gradient Fill section of the XlsxWriter docs.

1 Answers1