PC Review


Reply
Thread Tools Rate Thread

Data Labels on a Range of Values

 
 
Pablo
Guest
Posts: n/a
 
      10th Jun 2011
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.

 
Reply With Quote
 
 
 
 
Hans Terkelsen
Guest
Posts: n/a
 
      11th Jun 2011

"Pablo" <(E-Mail Removed)> wrote in message
news:9d206c12-9195-4e03-81cc-(E-Mail Removed)...
>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.

 
Reply With Quote
 
Pablo
Guest
Posts: n/a
 
      14th Jun 2011
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.




 
Reply With Quote
 
Hans Terkelsen
Guest
Posts: n/a
 
      14th Jun 2011

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Labels on Certain Values Pablo Microsoft Excel Discussion 2 13th May 2011 08:52 PM
Cond. Format Data Bars of range based on values of another range alexmo Microsoft Excel Worksheet Functions 4 16th Jan 2009 04:03 AM
is it possible that the data values shown on the data labels be in a duifferent range tweety127 Microsoft Excel Programming 0 7th Jun 2006 10:16 PM
Using different values for data labels =?Utf-8?B?QnJ1Y2UgU2t5ZXI=?= Microsoft Excel Charting 3 20th Mar 2006 09:27 PM
Data Range - Why wont it pick up my series values and Xaxis Values? vankallm Microsoft Excel Charting 1 8th May 2004 06:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:34 AM.