So Ive got a dataset with multiple pie charts for different sub-groups in a sample, shown below:
As you can see, excel has automatically assigned the default colour scheme, which is fine. The problem is that Id like it to assign the same colour to the same data label for each chart. So for example H2c would want to be Dark red, not lighter red or blue, for all the charts.
Is there a way of setting this automatically or is it a case of going through and assigning the colours individually?