Steps to Reproduce

1. import the file

Current Result

the order of the series color is reversed to how it looks in Excel

the order of the categories for a horizontal stacked graph is reverse that of Excel

Expected Result

Debug Information

Original observations by Hawk

Caused by chart type, stacked column/bar chart. If you change to another 2D chart type, the colors are expected.

Further observations regarding color

// hightcharts will place the series in order
// here we need to add it in the reversed order

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.