Macro to Autofit Data Labels on Scatterplot

[ttbuson]

Tried searching the forums, but couldn't find anything.

I have an XY scatterplot of data with data labels in excel 2010. The problem is that the data lables tend to overlap each other or they'll appear right on the data point and I end up spending excessive amounts of time formatting them manually.

Is there some code or a macro that someone has written that can automatically fit data labels so they don't touch each other or cover any data labels?

Thanks!

 

[VoG]

This might help you http://www.appspro.com/Utilities/ChartLabeler.htm

 

[ttbuson]

Thanks, I had seen that link before but it's not quite what I'm after. That program will move the labels right, left, up, or down, but it won't autofit them so that there's no overlap between the datalabels.