Dear Aspose Team,
I’ve encountered an issue with the legend order in charts generated using Aspose Cells version 25.6 with JDK 21. Specifically, the legend items are not appearing in the expected sequence. For example, the legend currently starts with “Grocery,” whereas it should begin with “Alcohol.”
Interestingly, when switching to other chart types (e.g., Line, Clustered Bar, etc.), the legend order correctly starts with “Alcohol.” I’ve attached the relevant file for your reference.
Could you please confirm whether this is expected behavior or a potential bug in Aspose Cells or slides?
Looking forward to your clarification.
Downloads.7z (58.0 KB)
Best regards,
Manikandan Chinnasamy
@Mani.niq
Hello Manikandan,
The issue you’re experiencing with the legend order in the stacked column chart may be related to how Aspose.Cells handles legend items for different chart types. It’s common for different chart types to display legend items in varying orders based on the arrangement of the data series.
To troubleshoot this, you can try the following steps:
-
Check Data Series Order: Ensure that the data series in your stacked column chart are arranged in the order you expect. The legend typically reflects the order of the data series.
-
Recreate the Chart: If the order still appears incorrect, consider recreating the chart from scratch to see if the issue persists.
-
Update Aspose.Cells: If possible, consider updating to a newer version of Aspose.Cells, as there may have been bug fixes or improvements related to chart rendering since version 25.6.
-
Contact Support: If the problem continues, it may be beneficial to reach out to Aspose support with your specific file and code snippet for further assistance.
If you have any additional questions or need further clarification, feel free to ask!
Best regards.
@Mani.niq
It should be behavior of MS Excel.
Please create a stacked column chart in MS Excel , you will find the same result.