up vote 2 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
78% accept rate
feedback

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

link|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?) – TutorialPoint 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) – TutorialPoint Oct 9 '11 at 19:13
Nevermind, I looked it up. Thanks for your help! – TutorialPoint Oct 9 '11 at 19:38
feedback

Your Answer

 
or
required, but never shown
discard

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