Assign specific colours to multiple Pivot Chart Data Series

Hi All, hoping someone can help please!

I have created Dashboards that contains approx. 40+ pivot chart across multiple tabs within a single excel worksheet.

All the pivot table and data sources are contained in the same excel worksheet and the data sources are within a 'Dynamic' tables.

Note: As this file is so large, complicated and confidential i cannot post an example, so apologies.

The dashboard contains x3 types of graphs (Pie, Column and Bar Charts).

When i replace and/or update the data source info and select 'Refresh All', the graphs are updated, FAB. However, the assigned colours i manually nominated revert back to excel pallet of some description. Having to manually alter these across so many graphs each month is not practical especially as multiple people will be updating this worksheet and it need to be user friendly.

The dashboards have slicers (Mainly Year and Months), as primarily monthly data will be reviewing across numerous business functions.

Across all the graphs, i need the colours i have assigned manually to the month series (Jan to Dec) to be applied automatically.

I am not advanced enough with VBA code but have looked at examples and cant find one that works. I have also tried to save a template, however this is specific to graph type and is also not suitable as different titles etc. are unique to several graphs.

If you require any further info please ask, any help would be appreciated.

Kind Regards

Thanks jeversf this seems to be working. Only time will tell. Much appreciated.