Creating a custom legend for XY Scatter Plot

[imranq]

I need a way to make a customized legend for a scatter plot, is there any way to do that through VBA? I have a scatter plot with some points highlighted green, and some points grey depending on the user selection and need to be able to create a legend based on what the user selects (e.g. Green - Category B, Grey - Category A, etc.).

For some reason I can't get Excel to rename points on the scatter, so I feel like there is only one option: create custom images and align them correctly with labels on the plot.

 

[Derek Brown]

Could this be the answer:
The XY Chart Labeler Add-in

 

[imranq]

Thanks.

Unfortunately this only adds a label to points. As I have many points per category, I need to be able to generate a legend with VBA - so far it seems like you can't edit the legend in excel for each individual point