Fill required point color with worksheet event

     

  • Create the Chart
  •  

  • Add Worksheet event - Activate
  •