Hi,
I'm throwing together a series of reports with pie charts, where I'd like the same category names to always get the same colour.
From what I can tell, the only way to do this is by affecting the order the categories are passed in. This is no good to me as for one pie chart I may get:
CategoryA 5
CategoryB 19
CategoryC 1

and for the next:
CategoryA 13
CategoryC 8

So in chart one, CategoryC would be coloured Lime, but in chart two, it would be coloured Blue. Is there any way of saying I always want CategoryC to be Red for instance?
I've thought about passing in
CategoryA 13
CategoryB 0
CategoryC 8
But can't think how to do this.
Thanks in advance for any suggestions.