Date: Thu, 13 Apr 2006 08:35:54 -0500
Reply-To: "Peck, Jon" <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Peck, Jon" <email@example.com>
Subject: Re: Repeated points in Excel scatter-plot
Content-Type: text/plain; charset="UTF-8"
The sunflower option in SPSS was replaced by point binning, which gives a better visual picture of the scatter, although you can't count the petals. Binning makes the size of the point symbol proportional to the number of points in that bin, and it adds a legend for this.
To get binnng, bring up the properties palette in the Chart Editor, select the points by clicking on any of them, click on the Point Bins tab, and make your choice.
Besides size, you can use color intensity to show the number of points, and you have control over the bin size and some other parameters.
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Margaret MacDougall
Sent: Thursday, April 13, 2006 7:30 AM
Subject: [SPSSX-L] Repeated points in Excel scatter-plot
I am sorry that this is an Excel question. I did have a try with SPSS first, but to no avail. I would be most grateful to learn of ways in Excel whereby individual points in a scatter-plot can be conveniently labelled so as to indicate the number of occasions when a given x-y point is replicated so that the number of instances labels the point in question.
There used to be a sunflower option in a not so recent version of SPSS that could do something a little similar, although I would prefer just to read the frequency, not count the number of petals!
Thank you very much in advance for your kind assistance.
If all else fails, I realise that one can resort to using text boxes in MS Word but possibly Excel has a nifty trick!
Switch an email account to Yahoo! Mail, you could win FIFA World Cup tickets.