I have three pie charts on the same page with overlapping but not identical labels for the rows. e.g. say chart one has "china, india, nepal, germany", chart two has "germany, india, cuba, latvia", chart three has "china, germany, canada, mexico".
My problem is that the colors for the same "label" aren't the same between charts on the same page, e.g. Germany is red in chart 1, blue in chart 2, and pink in chart 3. I want a country to always be the same color on this page. Is there a way to specify this? Maybe I can make a single chart object with a single legend that contains three charts?
Its important enough I'd be happy to specifically set colors for each color myself manually, but I can't find a way to do this!