Help with Excel

[bobsalot]

now i want a program that can put the data from my attachment into a scatter graph, (weight against height) and also have a different colour for each yeargroup. If microsoft exell can do this please tell me becasue i cannot find out how.

(the reason i have posted a new thread is because it wont let me post again in that thread for some reason. it says im posting a duplicate post. mod please merge thank you )

 

[kcnychief]

Re: new program wanted.

Excel can do this pretty easily - I'll have to figure it out later though as I don't have Excel on this PC.

As a side note, a great source for excel based questions is also http://www.mrexcel.com/board2/

 

[bobsalot]

Re: new program wanted.

o ok.

 

[lancer]

Re: new program wanted.

i can make the chart but have no idea how to separate the colors

 

[bobsalot]

Re: new program wanted.

yer i have made the chart now. just need to separate.

 

[NetRyder]

Re: new program wanted.

You need to separate the data into three sets - Series 1, 2 and 3, and then assign a different color to each series. This is what it ends up looking like:

I've attached the Excel file so you can look at the chart properties to see how it's done.

 

[jimi_81]

Re: new program wanted.

is that data real?
man i'm fat!
1.8 m, 87 kg. i am an outlyer
hehe

 

[NetRyder]

Re: new program wanted.

I have no idea if it's real. I just plotted the dataset from bobsalot's file.

 

[lancer]

Re: new program wanted.

i hate you net i wanted the glory.

 

[bobsalot]

Re: new program wanted.

Thank you very much.

edit:im confused, how the hell did you do it?

 

[NetRyder]

Re: new program wanted.

When you're creating the chart using the wizard, you first select the Scatter plot, as usual. In the second step, you'll see a tab on top labelled "Series." Click that, and you'll see an "Add" button to add additional sets. Basically, you want to create three of them, one for each year-group.

 

[bobsalot]

Re: new program wanted.

ok cheers thanks.