Wednesday, April 3, 2013

Strip plot / Strip Chart in Excel using RExcel

See the related posts on RExcel (for basic, Excel 2003 and Excel 2007) for basic information.

We already discussed in previous posts that how to install RExcel to how to load a data.

Let's get a data, here I am loading barley data from R/lattice library. The data is in the long form (unlike many datasets in Excel), data with many treatments or replications or samples are arranged this way.

It is very easy to generate stripe plot using RExcel. From graphics menu select Strip Chart. Then select one or more Factors (or no factors !) and a response variable. If you think there are stacked points, you can keep them as such or jitter so that points in same point will be visible in the plot. Click OK.



No comments:

Post a Comment