I need help with making a scatter graph! I cant work out quite how to do it.......... Sad i know. Anyone help me out?

 

It's easy once your data is in: Insert, chart, chose scatter

Give us your titles and figures and I'll put it into a graph

Z

 

Hi Cabrio, in gotta shot i will be back on line about 7pm Will chuck info up agian. Cheers for help

 

I'll be back online tomorrow a.m try to help you then if not too late

Z

 

Ok Cabrio cheers. Anyone else able to help this eve? if not be for morn. though would be better asap.

This is the info:


Importance...................BMW Strength
R1: 7..................................7
R2: 8...................................6
R3: 6................................... 5
R4: 8.................................... 7
C1: 7....................................9
C2: 8....................................8
C3: 9...................................7
C4: 7...................................4
C5: 9...................................5


What i would like is x axis on bottom labled Strategic Important and Y Relative Stregnth. Then i need R1 ploted on that axis etc.

Anyone?

 

seems a litle unclear to me. why is there a space between each set of two numbers?

do you want r1 etc on x axis and the numbers on the y axis?

 

kevandalice
Sorry the bb dont like me leaving spaces for some reason on here

So have ammend it crudley now! for the first one R1: first 7 is Strategoc importance and then the 7 next to it is relative strength.


Thanks for help...

 

ok i was unable to add r1 r2 etc labels to it but the dots are there:
if you want the jpg pm me and i'll mail it to you

 

really need it in scatter graph so the first one on a 7 & 7 R1 would be located near top left corner etc. I got example here but for somereason my scanner is not working Computers dont you just love them? lol

 

updated, see above

 

Mine looks different to that one

 

kevandalice
That looks spot on mate, though i need to distinguish what dot is what. Ie Re 1 blue R2 is red etc? Sry being a pain

Got my scanner to work, just uploading cop of thing i need now.


Right i know im taking the pissssss now. But I need the table then to have to lines one horizontal and the other verticl. With top right corner saying Key Strengths, Top left, Superfluous Strengths bottom left Xone of Irrelevance and bottom right Key Weaknesses.


I know im taking the piss but im desperate has i got old shitty comp that cant do fook all. and the operater isnt much better

 

Right pic of table is not uploading onto Photobucket now

Can i email it to anyone to post up please?

 

Right finall here it is..... Basically i need it to look close to this. I know its not going to be identialy. but if could have legend on side of which point is what etc.

 

Rhys I'll add you to MSN I think I've done it

 

Well doesn't look like you're coming on MSN does it

This any good?



Obviously photobucket re sized it but you get the idea

Edit - hopefully better pic

 

Smidsy sorry mate, was away from computer. I just added u. doesnt look like your about now

 

I couldn't see a way of doing in it Excel, I'm not clever enough, so I just copied it in PowerPoint is this how you wanted it? Can email you the powerpoint slide or in Word if you like

 

Cabrio it would have been nice like i have posted above. but tbh i know its never going to get like that without serious programe. Smidsy sorted me out with excel Scatter graph though.. Which will do for the assignment

 

I didn't read your post only looked at the example! Least your sorted now!

Zo