# Data Loss Aversion II – R Lattice Plot

Click to Enlarge

This post continues Jorges Camoes discussion on data loss aversion.  In my first post on this topic,  I used a dot plot to show the 1967 and 2005 values to summarize relative shifts in households by total household income bracket.   Derek, giving in to data loss aversion, used a logarithmic axis technique to show all data in intervening years between 1967 and 2005. Andreas Lipphardt used small multiples to show 1967 and 2005 values as well as the overall change by bracket. We can combine Dereks “giving into loss aversion” and Andreas’s “small multiples” approaches to show all data for the 9 series in a compact trellis chart by using the R Lattice package. I have a brief discussion on using R  for advanced charting here. This R lattice plot has several advantages:

• Shows all data
• All plots share common X and Y axes, reducing axis labeling
• Plot uses banking to 45 to enhance visualization
The terms trellis, lattice and panel charts seem to be used interchangably, depending on which software was used to develop the chart. Small multiples is a more generic term that applies to Tufte’s approach of making a series of small, similar charts.

Excel has limited tools for effective multivariate charts, no trellis or lattice charts and no built-in small multiples capabilities.  While we can use clever Excel workarounds like panel charts or manually generated small mutiples,  I find that it is wise to move beyond Excel’s chart limits for multivariate charts.

R, a powerful and free statistical analysis and graphing package, has excellent multivariate charting tools. The R learning curve is well worth it for those Excel charters who want to move beyond Excel to the wider world of advanced charting.

### 8 Responses to Data Loss Aversion II – R Lattice Plot

1. derek

I have added a link to Chapter 4 of Paul Murrells’s R Graphics book. It’s free. You can check it out to see if you think it’s worth \$80 for the other 6 chapters and info packed appendix.

2. derek

I saw those other links, but they weren’t the ones that looked great

3. derek

I listed quit a few resources. All CRAN documents and software are free.

The 7 tutorial links are all free.

The 3 video links are free.

The 3 books may seem pricey, however, remember the software is free.

The GGPlot2 is software free.

Kelly

4. I too would like to get started but haven’t been able to crack the starting barrier yet. The resource Kelly links to on his web site looks great, until you realise it’s an \$80 book!

5. Yeah, I think some tutorials would be a great idea and very welcomed by readers. Being that R is available to all, I think there would be more people apt to dive into it if there was a solid resource out there. Also, I don’t think it has to be very advanced either. Something simple to start.

I would be absolutely open to a guest post or at a minimum a link back to here if you are interested.

6. Tony

I’ll work up a post on my R Graphics learning curve and suggestions soon.

I’m thinking about a series of R graphics video tutorials. Do you think there would be much interest?

There are plenty on Excel charting and I’ve done a few myself. Any suggestions?

Any interested readers? Let me know.

7. I agree that Excel was not designed well for advanced charting and have been meaning to dive more into R. Are there any references that you would recommend for those starting to learn R?