Created attachment 151462 [details] data for reproducing the problem Seen in versions 6.1.5.2 and 6.2.3.2 To reproduce: 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
Hi Cathy, 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%? Regard, Jacques
Hi Jaques, 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. Cathy
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! https://www.exceldashboardtemplates.com/why-is-excel-overlapping-columns-when-i-move-them-to-the-secondary-axis/ https://www.exceldashboardtemplates.com/stop-excel-from-overlapping-the-columns-when-moving-a-data-series-to-the-second-axis/ https://stackoverflow.com/questions/17712980/column-chart-with-primary-and-secondary-y-axes 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.
Dear Cathy Crumbley, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug