Negative Values in Stacked Columns

[randmike]

Building stacked column charts seems to plot each value on top of the last. This produces expected results when all the values are positive. But if some of the values are negative then they may not appear below the axis.

For example for the following series:
Series A={ 5, 4, 3 }; Series B={ -3, -2, -1 }; Series C={ 4, 3, 2}
The values for Series B will not be shown as they will be plotted over by the values in Series C

Is this what is expected? it is different from other stacked column behaviour (e.g. MSExcel
Stacked Column Expected.xlsx
)