Add label to selected XYscatter datapoint

M

Martin Los

I have a XY scatter graph with about 250 points.

I want to add a label to the data points I consider
outliers. To that end I want to select the datapoint and
run a macro.

The macro should select three columns (this can be a named
range DATA): the first colum holds the labels, the second
colum holds the Xdata and the third column holds the Ydata.

The macro should look for the x and y data in the range
DATA corresponding to the selected datapoint. Then it
should draw the label of the first column next to the
selected datapoint.

Any ideas how this macro could look like?

Thanks in advance

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top