Data Labels on a Range of Values

  • Thread starter Thread starter Pablo
  • Start date Start date
P

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.
 
Pablo said:
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.
Click to expand...

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.
 
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 said:
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.
Click to expand...

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.
 
Back
Top