Stacked Chart dilemma

[shakin8]

Hi guys.

I'm looking to create a stacked bar chart like the one in the attached picture. The issue is with the series of data. Colours always have to be in the same order and for the example of booking out an area in the diagram, this isn't possible.

Does anyone have any ideas as to the best way to go about producing a diagram like this in Excel?

Many thanks in advance!

[Andy Pope]

Without resorting to code you could use 16 series rather than 4 and formula to populate the correct set of bars in order to get the colour in the required order.

You can delete the 12 excess legend entries