Use data labels in legend with X Y scatter chart

**CostCare** · 10-02-2016, 06:27 AM

Hi,

I have a scatter chart with data labels. To add the data labels, I use this VBA code form microsoft:

Please Login or Register  to view this content.

This works perfectly but what I actually want is the labels to be in a legend and for each label a different color..

Any help is much appreciated!

**MrShorty** · 10-02-2016, 09:49 AM

It is not clear to me what you want to do. Jon Peltier has a series of essays on his site that describe several different aspects and tricks for working with legends (first in the series: http://peltiertech.com/legends-excel...hape-position/ links to follow up posts at the bottom of the essay). You might look through those and see if his ideas point you in the right direction.