1

I have 3 columns of data, one is the label, the second and third are numeric values with a range from positive to negative numbers.

I couldn't create a scatter plot with a label in each of these points, because I didn't find how to get the label value from this column, as X is column A value and Y is column B value.

enter image description here

DATA:
LABEL   X-AXIS    Y-AXIS
Apple    -5         3
Banana    0        -5
[and so on]
  • You sample data gives me this chart. By default, you have the legend at the bottom. If that is not what you want, can you edit your question to show us an image showing the desired result – cybernetic.nomad Jul 4 '19 at 20:43
  • I don't see any points at (-5,3) or (0,-5). Please post consistent data. – Scott Jul 4 '19 at 20:52
  • @cybernetic.nomad: You're plotting (1,-5), (2,3), (1,0) and (2,-5). I believe that's not what the OP wants — but I agree that the question is unclear. – Scott Jul 4 '19 at 20:53
  • @Scott ah!, I see, I,m used to working with series not individual points – cybernetic.nomad Jul 4 '19 at 21:01
  • The data is just an example!! Banana or Apple should be the label, but as a label i get only the numbers from x or y! – Carlos Jul 4 '19 at 21:09
1
  1. Select only the data and insert a scatter chart

enter image description here

  1. Select, then right-click on one of the data points and select "Add Data Labels" from the dropdown menu

enter image description here

  1. Right-click on the data point again and select "Format Data Label" from the dropdown menu

enter image description here

  1. Check "Value From Cells" and choose the range for the labels

enter image description here

Your chart should now look like this:

enter image description here

|improve this answer|||||
  • I don't have these options in my excel 2010 :( – Carlos Jul 4 '19 at 21:08
  • But that's what i need!! – Carlos Jul 4 '19 at 21:10
  • I believe that the horizontal axis is usually called X, and the vertical axis is usually called Y.  So I believe that you need to “Switch Row/Column”.  (But, if the OP says you’ve got it right, who am I to disagree?) – Scott Jul 4 '19 at 21:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.