Created attachment 151462 [details]
data for reproducing the problem
Seen in versions 18.104.22.168 and 22.214.171.124
Select the data such as in the attached file.
Click on the Chart Wizard in the Standard toolbar to open the Chart Wizard.
Click Finish in the Chart Wizard dialog.
Click a bar once in the chart to select its data series.
Go to Format > Format Selection to open the Data Series dialog.
Under Align Data Series to, select Secondary Y-axis.
Click OK to close the dialog.
The resulting chart shows one of the data series aligned to the secondary Y-axis. However, the columns for that data series are significantly wider than the columns for the other data series. See attached screenshot.
Created attachment 151463 [details]
chart showing distorted columns
You get the same behavior with Excel. Only the spacing is not the same:
100% in Calc; 150% in Excel. Did you try to increase spacing from 150% to 300%?
Yes, I see a similar bug in Excel. Increasing the gap width to 420% or so seems to correct the way it looks.
In Chart, increasing spacing to 340% or so corrects the appearance.
The same behavior occurs for both column and bar charts. My description was not clear about this since I was thinking about column charts but wrote "bar".
Should another bug report be filed or can this report cover both column and bar charts?
This seems to be a rather common cause of frustration for Excel users!
I guess it would be nice to have some solution (if it is scientifically possible) - adding needsDevAdvice in case there is something fundamental that will block this.
Cathy: one report for column/bar is fine.
OK. I just added "bar " to the title.