How can I change the width of a bar in a chart using a macro?

I can use edit a data series and change the properties in the Settings for Spacing and Overlap which seems to be the way to change the size of the bars.
I have tried for hours to find the properties to set for use with a macro.

Does anyone know how to change the size of the bars in a chart using a macro?


You should be able to access it from the axis properties. Look at The Structure of Charts - Apache OpenOffice Wiki on the section “Properties of Axes” → " Only for bar charts"

Indeed @ouyang.leyan your advice led to a solution.
Thank you so much.

I had to dig around a little but I got results. Here is My Options class file that also sets the bar width.

Here is my test to get an idea how it is used.