Hi,
I would like to make a chart similar to the attached photo. I think I can make something similar to this using a stacked horizontal bars but:
1) There are approx. 125 "many colored" rectangles in one bar. Does that mean I have to make 125 series of a bar in order t make this chart?
2) How do I control the colors so that a rectangle of barseries1 is red in one bar but yellow in another bar? For instance, the very first rectangle is green at the bar at the top but blue at the third highest bar - How do I control this if I'm using the same barseries?