Bubble Chart Not Updating Based on Macro

As per the attached workbook I have a bubble chart on sheet 'Prioritisation' which is taking its series data points from the sheet 'Master Copy'. I also have a macro which is designed to update the bubble colours based on the cell colour of column AJ on the 'Master Copy' worksheet.

The macro is:

Please Login or Register  to view this content.

As you will see the bubble colours do not reflect the cell and also do not update if I use the slicers associated to the 'Master Copy' worksheet

Thanks Andy. That works perfectly until I use the slicer and new data is loaded and then the bubble colours are wrong and I need to manually run the macro again for these to be corrected. Any thoughts on how this can be corrected so that the macro doesn't have to be manually run?

Also I don't know if there is any way for the macro to run without having to phyically click on the chart itself first?

Thanks Andy, in reference to "capture the calculate event of the table sheet" I am actually not sure how to do this but based on your description I am not sure it is the issue. Using the slicers does not change the conditional cell colour of any cell, these are based on a formula from data points only not related to the chart/slicers.

The issue seems to be that if I use the slicer the bubble colours are incorrect until I re-run the macro and then they are corrected, I would just like them to be correct without having to re-run the macro manually.

Thank you so much Andy, it works perfectly!!!!