Stacked bar charts ordering is data-dependent, producing confusing graphs

Bug description

When you're using a 100% stacked bar charts with specific colors, it's not possible to actually order colors, because the graph will auto-order them by mean values across the set. The ordering is defined by the data, which will change rather than the chart itself.

This makes creating a readable consistent chart difficult.

If I'm defining my colors, I want to be able to define their ordering.

Expected behavior

A way to opt-in to setting a fixed series ordering.

How to reproduce

1. Create a Bar Chart panel w/ Stack Series enabled
2. Add 3 formulas in order: A, B, C with fixed legends (good, bad, very bad) and fixed colors
3. Point them at a scope where values rank to something like 70 / 25 / 5
4. Duplicate the panel, and point it at a scope where values rank to something like 5 / 25 / 70
5. Note the two panels have opposite ordering, which defeats the purpose of setting up a logical ordering of bands on the data

Version information

• Signoz version: SigNoz Cloud v0.141.0
• Browser version: Chrome 152.0.7977.83
• Your OS and version: macOS 26.6.2
• Your CPU Architecture(ARM/Intel): Apple Silicon, arm64

Additional context

Have tried renaming legend titles to be alphabetical order, but that does nothing Have tried the order field on a builder query/formula, but that effects nothing