Line and Clustered column chart - change the order of color legend

[Anonymous]

Hello All,

I have a requirement to modfiy the order of color legend in line and clustered column chart. By default, the line column color will be displayed in the last position of color legend.

@Greg_Deckler  Is there any way to customize the order of color legend in line and clustered column chart?

Thanks,

Vadigi

[MFelix]

Hi @Anonymous ,

You cannot edit the sorting of the legend based on different clustered values so lines will always be on the end.

One workaround is to create another similar char but just with columns or lines then place the values on the order you want, turn off responsive and title and reduce the chart that you only see the legend (be aware that this trick only works for horizontal style legends).

Now turn off the legend on the first chart and group both visualizations as they are one.

[Anonymous · Accepted solution]

Thank you Felix for your time and inputs. But the workaround doesn't solve my requirement.

I understood that, we cannot edit/modify the order of legend in Line and Clustered Column chart.

Thank you once again for your time.