We are showing a Stack Chart with Contribution Quantity on Y axis and Months on the X axis .
The chart is coming absolutely fine in report with legends in descending order , but when the report is saved as excel the sort order of legends is changed to ascending .
Please note that this problem is not occurring while saving it to PDF and also the line chart is also there which also shows correct legend order while exporting to excel .
We have tried scheduling the report with output format to excel , but it did not work too .
Any help is greatly appreciated .