Hi,
I have an excel report with multiple pie charts across multiple sheets where I would like the charts to always have the same colour for the same data category.

These charts are from the data model, so I have created a bespoke order for the categories, thus the series are always charted in the same logical order (i.e. not numerically). This works fine, but in some cases there are zero records for a category. The excel colour theme uses the colours in order, so colour/category consistency is lost.

I've tried templates, but does not help, so I think VBA is the answer?charts.png Any help gratefully received.

Using Excel 2016