Thursday, April 4, 2013

plotting multiple scatter plots arranged in facets (trallis type) in Excel using RExcel with (with KMggplot2 plugins)

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

In previous post we created mutiple histograms arrange in row and column (facets, trallis type plots), we can do the same for the scatter plot using RExcel with (with KMggplot2 plugins). Basic step in data loading etc are same. We will use the same cabbage dataset  to deomstrate how we can do this.

 Data is loaded and active, we need to check histograms under KMggplot2 menu. Now we have choice for X variable, Y variable, stratum variable, Facet variable in row or column direction. We can add smoothing curves or opt out by clicking none.

See the nicely arranged publication ready graphs:


  1. This kind of Pie Chart creating is really helpful while data analysis.

  2. its very useful for us. thanks for share this informative article.Advance Excel training in Chandigarh

  3. Cultural Holidays is a leading Tour & Travel management company with the specialization of various kinds of tour packages developed by the group of professionals which make it unique and one of the most-sought after tour and travel organization in India located in Agra, Uttar Pradesh. We offer domestic tours to a Delhi, Rajasthan, Uttar Pradesh including Jaipur and Agra.

    Same Day Tour Package by Car
    Golden Triangle Tour 4 Days
    Golden Triangle Tour with ranthambore

    Know More Visit Our Website.


    Mobile: +91 - 9837236920, 9368745567

  4. Your blog is so nice, and the article is very good it helps to so many people.
    Advanced Excel Training in Hyderabad

  5. Anda merasa butuh dana tambahan? anda ingin mencoba sedikit kerjaan yang tidak membosankan dan juga ingin mendapatkan penghasilan tambahan?Anda bisa Klik di agen s128
    Dapatkan informasi penting dalam dunia sabung ayam di website bawah ini