Right click Master Copy sheet and add the following event code

Private Sub Worksheet_Calculate()
ColorChartSeries

End Sub