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
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