Data Labels on Certain Values

P

Pablo

Is it possible to only label data points in a scatter graph that are
above a certain, set value?
 
H

Hans Terkelsen

Pablo said:
Is it possible to only label data points in a scatter graph that are
above a certain, set value?
Click to expand...

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

Pablo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Labels on a Range of Values 3
Connecting ALL Data Points; Sequential Or Not ? 1
Aligning tick marks and labels on line charts or scatter charts 2
'Automatic' change to Line Chart from XY Scatter Chart - cannotchange back 2
Data Labels for a chart in Excel 2
problem with scatter plot an the millennium 2
Sr. Citizen Question On Adding A Trendline, Please ? 1
Scatter plot / Data from matrices? 1

Top