Hi Bob,

Separate colour segments in one bar is not a problem with a stacked bar chart.
However automating their appearance over different times can be quite complex.
Maybe you should go for 'conditional formatting' rather than a chart.

Regards

Holger