Data Labels on a Range of Values

[Pablo]

I am working in a scatter plot and want to label specific data points.
I know I can specify a data point label for ranges about a certain
value like this formatting: [>5]"high";

What do I do if I want to make the "high" labeled with the Y axis
value? So anything over 5 would be labeled with its own Y value.

 

[Hans Terkelsen]

I am working in a scatter plot and want to label specific data points.
I know I can specify a data point label for ranges about a certain
value like this formatting: [>5]"high";

What do I do if I want to make the "high" labeled with the Y axis
value? So anything over 5 would be labeled with its own Y value.

Hi Pablo.
I think I remember your previous post some time ago.
Try to userformat the labels [>5]0.0;
For example.
That would show the value with one decimal,
but show nothing if the value is 5 or under.
Hans T.

 

[Pablo]

Thanks Hans,

That was my post a while back and this worked. One more question.

Is there a way to do the same with the X also, which happens to be the
name in this case? So the scatter would show "Pablo, 5.5" for any
point above 5 and nothing for everything else.

 

[Hans Terkelsen]

Thanks Hans,

That was my post a while back and this worked. One more question.

Is there a way to do the same with the X also, which happens to be the
name in this case? So the scatter would show "Pablo, 5.5" for any
point above 5 and nothing for everything else.

Pablo,

without VBA I don't think one can control
the Series labels or X labels with the Y value.

Perhaps you would be satisfied with simply using this
userformat on the Y labels
[>5]"Pablo, "0.0;;;

One can make a lineshift in the labelformat by pressing Ctrl+J

Hans T.