Sorting And Normalizing Chart Data?

I *think* I know the answers to this, but we'll see...

Let's say I have five salesmen:
Mr. Red
Dr. Green
Ms. Blue
Mr. White
Mr. Black

Each month they make sales.

So I have a table, where each salesman is a row and each month is a column, and the cell is populated with sales.

I'd like to do a COMBINED Horizontal Bar chart, where:
- Each row is a month
- The size of each person is actually their PERCENT of Sales, not the total amount (without me having to add rows of calculations)
- Each month automatically sorts the colored boxes in size order.

In other words, here's sample data:
Red - ( 0, 3, 0, 9)
Green - ( 8, 3, 6, 5)
Blue - ( 7, 3, 2, 8)
White - ( 4, 2, 3, 7)
Black - ( 5, 5, 5, 5)

So the top bar would have four colored boxes, in the following order: Green, Blue, Black, White The green box would be 33 percent of the total width, the blue one just a titch smaller, and so on

The next bar would have five boxes, and would be the same length as the one above, and have, in following order: Black, Red, Green, Blue, White The black box would be just smaller than a third (5/16 of the length); red, green, and blue would all be the same size, and the white box would be a titch smaller

The next bar would also have four boxes (time for Red to go!), and would be the same length as the ones above, and would have, in the following order: Green, black, white, blue The boxes would be sized appropriate to their ration in that row (ie, even though Black has sold five each month, each month it makes a different proportion)

and so on.

A doughnut chart does the percentage-of-total thing snazzily, but the sorting gets weird.

I actually havve a ton more data than in my example, so manual calcs and manually manipulating won't work here.