I have the fioloowing data
Place1 cat1
67.7
0.0
Cat2
4.4
24.1
Cat3 4.3
25.4
Cat419.4
64.2
Cat531.5
60.6
Place1
Cat12.7
12.4
Cat23.2
31.8
Cat312.3
43.1
Cat411.1
71.5
Cat519.7
63.4
There are 5 data sets within each place and eventually I will have 10
places, only the dat relating to places 1 and 2 are shown
What I want to do is to draw a scatter graph in excel where all the places
are the same colour, so for example place 1 would all be yellow and place 2
would be blue, and within each place each category would have the same
symbol, so all the cat1s would be squares and all the cat2s would be
diamonds
Does anyone know how to set up this excel worksheet to achieve this grpph
Regards
ann
Ann E Fitzmaurice
Medical Statistician
University of Aberdeen
Department of Obstetrics & Gynaecology
Aberdeen Maternity Hospital
Cornhill Road, Aberdeen. AB25 2ZL
Tel: +44 (0) 1224 553876
Fax: +44 (0) 1224 553708
e-mail: <mailto:[log in to unmask]> [log in to unmask]
<http://www.abdn.ac.uk/dugaldbairdcentre/>
http://www.abdn.ac.uk/dugaldbairdcentre/
|