Jim, I do not know how to do this in Excel but, I agree with Dr. Boyce that this is fairly easy to do in R. If you do decide to do this in R, you may find this site helpful. http://rforsasandspssusers.com/
Also there are some circular plot examples in the R graphics gallery. http://addictedtor.free.fr/graphiques/RGraphGallery.php?graph=123 Hope this helps, Michael On Sat, Sep 26, 2009 at 9:38 AM, Richard L. Boyce <[email protected]> wrote: > Sure, R will both analyze and plot circular data, and it's free! Go to > http://cran.r-project.org/ for more information. The packages CircStats and > circular will be most useful for what you need. > >> Date: Fri, 25 Sep 2009 16:33:05 -0400 >> From: Jim Rentch <[email protected]> >> Subject: Circular data >> >> I want to graph circular data, and to compare mean direction of tree-fall >> = >> and slope aspect. I am using SAS code to generate means (Rayleigh and = >> Watson tests), but I am unable to graph without purchasing a special = >> graphics package. Does anyone know how to graph circular data using = >> Excel? >> =20 >> =20 >> Jim Rentch >> Assistant Research Professor >> Division of Forestry and Natural Resources >> West Virginia University >> Morgantown, WV 26506-6125 >> 344 Percival Hall >> Telephone: 304-293-6466 >> Fax: 304-293-2441 >> http://community.wvu.edu/~jsr008/ > > -- > ================================ > Richard L. Boyce > Department of Biological Sciences > Northern Kentucky University > Nunn Drive > Highland Heights, KY 41099 USA > > 859-572-1407 (tel.) > 859-572-5639 (fax) > [email protected] > http://www.nku.edu/~boycer/ > ================================= > > "One of the advantages of being disorderly is that one is constantly making > exciting discoveries." - A.A. Milne > -- Michael Denslow Graduate Student I.W. Carpenter Jr. Herbarium [BOON] Department of Biology Appalachian State University Boone, North Carolina U.S.A. -- AND -- Communications Manager Southeast Regional Network of Expertise and Collections sernec.org
