Asking this question from a PC w/o Excel, therefore I can not post my code.
I am beefing up my Excel 97 macro which links labels/textboxes of a chart with a cell. So far so good. I have seen from the VBA Help that there is a 'xlLabelPositionBestFit' constant for the Datalabel, see also http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/xhtml/output/F1/D3/S5A6E8.asp
Besides the Format Label dialog not offering this option, it does not seem to work from inside VBA. Any ideas ?
Will double the points to 200 if there is a solution.