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

  6. Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi

  7. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
    Devops Training courses
    Devops Training in Bangalore
    Best Devops Training in pune
    Devops interview questions and answers

  8. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    excel advanced excel training in bangalore

  9. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging.
    python interview questions and answers
    python tutorials
    python course institute in electronic city

  10. Thanks Admin for sharing such a useful post, I hope it’s useful to many individuals for developing their skill to get good career.
    python training in chennai
    python course in chennai
    python training in bangalore


  11. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.
    Advanced AWS Training in Chennai | Best Amazon Web Services Training in Chennai
    Best Amazon Web Services Training Course in Bangalore | AWS Training in Bangalore
    AWS Online Training and Certification | AWS Certification Course