Download it now!
Bug 125323 - aligning data series to secondary Y-axis distorts column/bar width
Summary: aligning data series to secondary Y-axis distorts column/bar width
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevAdvice
Depends on:
Blocks:
 
Reported: 2019-05-16 16:19 UTC by Cathy Crumbley
Modified: 2019-08-26 21:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
data for reproducing the problem (19.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-16 16:19 UTC, Cathy Crumbley
Details
chart showing distorted columns (135.62 KB, image/jpeg)
2019-05-16 16:20 UTC, Cathy Crumbley
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Cathy Crumbley 2019-05-16 16:19:29 UTC
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.
Comment 1 Cathy Crumbley 2019-05-16 16:20:45 UTC
Created attachment 151463 [details]
chart showing distorted columns
Comment 2 Jacques Guilleron 2019-05-30 14:16:06 UTC
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
Comment 3 Cathy Crumbley 2019-05-30 16:13:45 UTC
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
Comment 4 Cathy Crumbley 2019-06-02 19:39:33 UTC
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?
Comment 5 Cathy Crumbley 2019-06-02 19:40:07 UTC Comment hidden (obsolete)
Comment 6 Buovjaga 2019-08-25 14:33:50 UTC
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.
Comment 7 Cathy Crumbley 2019-08-26 21:46:21 UTC
OK. I just added "bar " to the title.