Try this code:
ActiveSheet.ChartObjects("Chart 1").Activate 'For selecting the
chart
ActiveChart.Legend.Select 'For selecting legend
Selection.Interior.Color = vbRed ' for coloring its interior
Selection.Font.Color = vbBlue 'for coloring its font
ActiveSheet.Cha
Hello Folks,
I'm trying to build a dynamic excel scattor plot with the data points
color coded based on their value. This chart will report different
values for different scenarios.
I could change the color of data points but was unable to change the
color of data labels. Please let me know if I
