"Pablo" <(E-Mail Removed)> wrote in message
news:6b9b9d6f-8441-4535-99bc-(E-Mail Removed)...
> 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.
|