Chart legend order reverses

[Anonymous]

I have created two charts using the same data. When I create a mekko chart the legends reverse and the colours are backwards from the pie chart.

I figured out that I had to reverse the order in the mekko chart to get them in the correct order, but how do I get the colours to match between the two charts?

Thank you

[neelamsaroha157]

I am not sure but you can try checking 'Persistent Color' option on color tab.

[Anonymous]

Hi,

You can use in your background color this kind of formula : =Color(FieldIndex('Country',Country))

Country is a dimension and you will have the same color for each country if you apply the color background in your charts ( mekko and piechart)

[Anonymous]

I can get the colours to match by reversing the order of the Expressions in the Mekko chart, but then, of course, they appear in reverse order on the legend.

[Anonymous · Accepted solution]

In the pie chart the Expression is a count of the category. For the Mekko chart I've had to list the count of each of the categories as a separate Expression.

Still no joy on this one. Seems odd that the Mekko chart displays the legend in the opposite order to the Expressions.

[Anonymous]

Could you post a sample?