This question is locked. New answers and comments are not allowed.
I've got a data set that needs to be displayed as a set of stacked columns.
So far so good, now the tricky part.
The values in a given stack may belong to a different data set:
e.g.
1st value belongs to set A,
2nd value belongs to set B,
3rd value belongs to set C
4th value belongs to set B
5th value belongs to set A
If we say A is Red, B is Green, and C is Blue the stacked bars need to be
Red
Green
Blue
Green
Red
Is there any way to accomplish this?