Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am not sure if this is the right site, though here's my question:

I've been trying to make a scattergraph with Excel, but not getting the result I want. I have 2 data values for one thing. I don't want them to display two different dots for both data values, I want to have one dot, but with the name of the thing. To make myself more clear, here's what I currently have:

enter image description here

And this is kinda what I want: (but then also the names by the dots)

enter image description here

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

A XY scatter plot is correct. When you highlight the data and select scatter plot it will assume some things. In your case, you want to "switch row/column" in the data values page. In 2007+, you can select chart tools --> design and then "switch row/column". Once that is done go back to edit the data and change the X values and Y values to their own value. enter image description here

share|improve this answer
    
I get this: piclair.com/v3164 For some reason it does that, why and how can I solve this? Do I need to change something in settings? (BTW, Excel sees the countries as series. Could that be the problem, and if so, how to change?) –  Deniz Zoeteman Oct 9 '11 at 16:37
    
Yup. That is what I got at first too. You will need to right click on the plot area --> Select Data. For each country series edit place the life expectancy on the X value and the birth rate on the Y value. You need to do it for each series. Excel isn't smart enough to do it for us. –  wbeard52 Oct 9 '11 at 18:26
    
Yes, that works! Now lastly, do you know how I can get a name on the X and Y axes? (Life expectancy/Birth rate) –  Deniz Zoeteman Oct 9 '11 at 19:13
    
Nevermind, I looked it up. Thanks for your help! –  Deniz Zoeteman Oct 9 '11 at 19:38
    
@TutorialPoint If you want to add the labels from Column A to your data points (rather than just in the legend) let me know. –  David Zemens Feb 14 '13 at 22:01
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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