Consistent cross-tab chart colours
I'm working with a crosstab table that looks similar to the following.
From this I am creating a multi-pie chart, one per row which is split into true and false portions. However, what I am unable to do is set the colours for these portions, which is important given this is a report that is drilled down to from similar looking reports, and things become very confusing should those colours switch around as they sometimes do! How would I go about achieving this?
In the chart editor I have been able to hack a solution by setting the series colours (one series is true, the other false - though I don't see how that makes sense!), but upon leaving the chart editor and saving the report the colours switch again.