1. import the file
Caused by chart type, stacked column/bar chart. If you change to another 2D chart type, the colors are expected.
The comment above in CategoryModelSelector.toCharts in ChartsModelManager.java means that if the "series" order is not inverted we will get an upside-down stack:
Compare the figure above with the correct result of excel:
However, when we set the colors in drawChartInner (in HighchartsHelper.java) we didn't access the "series" in the correct order to account for our manual inversion in CategoryModelSelector.toCharts. Hence, we have the stacks in correct order but color not so:
Also note the order of the text and color of the legends for the three diagrams.