Download it now!
Bug 96959 - Data series overlap setting has no effect on stacked bar/column charts
Summary: Data series overlap setting has no effect on stacked bar/column charts
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
Reported: 2016-01-08 12:15 UTC by Katarina Behrens (CIB)
Modified: 2018-08-15 13:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Katarina Behrens (CIB) 2016-01-08 12:15:55 UTC
* Open a document with a stacked bar chart (for example this one:
* Right-click on any data series > Format data series ... (or do the same in toolbar)
* Options tab > Settings > Overlap

 => 1st issue: default value of overlap for stacked charts should be 100% as the bars are, well, stacked one after another. The right edge of 1st bar 100% overlaps with the left edge of 2nd bar, they have the same Y-coordinates (after all, that's how Excel behaves).

* Change the value, e.g. to 50%

 => 2nd issue: nothing happens. I'd expect the bars to move upwards so that their edges now overlap only 50%.

The same issue for stacked column charts. It works for normal (!stacked) charts, i.e. the bars change their position according to settings. 

I'm not sure if it has always been like that. Probably yes.
Comment 1 raal 2016-01-08 20:29:28 UTC
Build ID: fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3

Build ID: c1258abe50f1508ea0f628ff963bc1914ab86b67
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-01-02_01:43:32
Comment 2 QA Administrators 2017-03-06 14:29:19 UTC Comment hidden (obsolete)
Comment 3 Timur 2018-08-15 13:35:23 UTC Comment hidden (me-too)
Comment 4 Timur 2018-08-15 13:36:42 UTC
Repro in 6.2+ as described, from OO. But I'm not sure what is expected here. 

Overlap defines settings for overlapping data series that can be used in normal chart. If we have blue and red columns and 100% overlap, we see a single color. 
In stacked chart what would this be? You stack data series (I guess) to get total sum. Even if they do overlap, maybe shown with different color, you'll get wrong sum.
I don't see that overlap for stacked charts should be 100%.
My view is that overlap should be disabled for stacked charts. I may be wrong. 

BTW, I'm also not clear with the use of Connection Lines. Help explains but without image not obvious:
For "stacked" and "percent" column (vertical bar) charts, mark this check box to connect the column layers that belong together with lines.