PC Review


Reply
Thread Tools Rate Thread

Data Labels on Certain Values

 
 
Pablo
Guest
Posts: n/a
 
      29th Mar 2011
Is it possible to only label data points in a scatter graph that are
above a certain, set value?
 
Reply With Quote
 
 
 
 
Hans Terkelsen
Guest
Posts: n/a
 
      31st Mar 2011

"Pablo" <(E-Mail Removed)> wrote in message
news:9e22f30d-4491-4a66-b53f-(E-Mail Removed)...
> Is it possible to only label data points in a scatter graph that are
> above a certain, set value?


Pablo.
To label only data points larger than the value 5 with the word 'high'
one could set data labels to be the Y values,
and then format the labels with the userformat [>5]"high";
Hans T.

 
Reply With Quote
 
Pablo
Guest
Posts: n/a
 
      13th May 2011
How would I code it if I wanted it to show the X value of points
larger than 5 instead of the label "high". [>5]"Xvalue"; - This
doesn't work, but I assume there is some coding for xValue.
 
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
Add values of data that might have duplicate labels Tony Microsoft Excel Worksheet Functions 5 11th Dec 2008 12:26 PM
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
How do I show both data labels and values? =?Utf-8?B?Q2FydGVyIERldmVyZWF1eA==?= Microsoft Excel Charting 1 26th Jun 2005 07:12 PM
Data in cells is actually labels not values jruppert Microsoft Excel Misc 2 26th Nov 2003 03:21 PM


Features
 

Advertising
 

Newsgroups
 


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