Apache OpenOffice (AOO) Bugzilla – Issue 62364
Stacked Bars charts : bars are (also) not really stacked
Last modified: 2013-02-24 21:19:20 UTC
In this spreadsheet : http://www.openoffice.org/nonav/issues/showattachment.cgi/3572/9184-BadStackedChart.sxc In Column C3, the yellow bar should go from -17 to 1 and not from 0 to 18. There is a similar problem in column C5.
@IHA: I think the behaviour is correct. Maybe an idea for an new Charttype?
The current behaviour is as designed. Negative bars are stacked below and positive bars are stacked on top, thus the length of all bars are visible. This issue is requesting a different behaviour that maybe can be introduced by a parameter for bar charts or by introducing a completly new charttype. I am not sure about that yet. It is also not clear to me why you want the bars to be summed up independent from their sign. This will only lead to bars hiding each other. Maybe choosing the area or line chart does fit your needs much better and will do the trick for you?
I reported this issue because the current behaviour seemed unexpected to me. I agree there isn't much practical uses for negative stacked bars. I just see one case where it would be useful : building a Gantt chart using stacked bars, where you have a task planned to start a fixed number of days before the end of another task.
As the Gantt chart is targeted already with issue 10704 I close this issue as duplicate. *** This issue has been marked as a duplicate of 10704 ***
closed