How to make Barplots with secondary y-axis not to overlap eachothers

I have three series. The 1st and 2nd are using primary Y-axis on the left. The 3rd one is using secondary Y-axis on the right side of the chart. Now the 3rd series bars are overlapping with the 1st and 2nd series bars in barplot.

I would want to have 3rd series bars to be like they would be if assigned to primary Y-axis, so not overloapping with 1st and 2nd series bars. How/where to tell LibreOffice Calc chart-methods to not overlap secondary bars with primary bars?

If the answer works for you, please accept it so that others can find it (click the checkmark to the left of the answer).

The same problem occurs with column charts, as reported in this bug report: https://bugs.documentfoundation.org/show_bug.cgi?id=125323 It is not clear if another bug report should be filed.

Note that there is a work-around. Select the data series and right-click to open the Data series dialog. On the first page, drastically increase the spacing to 350% or so. (You probably don’t need detailed instructions for this but am including them for others who run into this problem.)