views:

146

answers:

0

I've got a scatter plot which I generate and set the data for programatically. The only problem is that if the data series are close together the labels find themselves right on top of each other. I have an algorithm in mind for moving the labels around so they remain close to their corresponding data series and are positioned so that the labels are in the same order and relative position to each other as the data series. For example if I have data series X, Y and Z with X to the left and lower, Y in the middle and higher and Z on the right and at the same level of X, I want X's label to be to the left and above X, Y's label to be above Y and Z's label to be to the right and above Z.

The only problem is I need the X and Y coordinate of the data series which is something I haven't been able to find. The only option I have right now to find this is to take the width (height) of the chart and divide it by the range of the Y (X) axis. Then use the data itself to find the corresponding series' location.

I can also randomly choose the label's location in relation to the data point, but that may have varying results and I'd prefer not to do that.

What I'm looking for is either a way to find the data series' X and Y coordinates on the chart directly or a Property/Method in the object model which will give me this information.