« Wannabell | Main | Proof of rampant U.S. deflation »



you can store your images on Amazon S3 quite easily.


Good if bandwidth is an issue, but even better is the technique of directing the subdomain. THis way if you need to move images, you can do it by changing a single setting!

You'll still get pain on your first migration though :((

Jon Peltier

"Resizing Excel charts is a common source of headache. Always right-size the chart inside Excel before exporting!"

Yes! True before exporting anywhere. Sometimes if you are using Word or PowerPoint, you can get away with resizing a bit, but only with constant aspect ratio, and with changes of no more than 25% either way.

I have a free Excel add-in which can be downloaded from my blog entry Enhanced Export Chart Procedure. It adds an Export Chart item to the Chart menu, and exports the chart in PNG (default), GIF, JPG (not recommended) and perhaps other formats, depending upon which graphic filters are loaded. I then FTP the images to my blog's image folder.


The life expectancy plot is nice, but it does require us to compare two curves to get the findings you describe. This is a difficult perceptual task as the visual system tends to look at the smallest distance between the curves, when mathematically we want the vertical distance.

Rachel Cunliffe

Some search and replaces wouldn't make it too painful to move over to Wordpress. Let me know if you need a hand, I enjoy reading your blog!


Martin, I think you mistyped, and meant that the range has been reduced, and not the variance. As you know, although in general variance is reduced when range is reduced, it is not always the case, and this chart does not show variance, but range.

It is true in this case, however, that that standard deviation decreases dramatically over time. A robust estimate of the variation, the inter-quartile range (IQR), doesn't have the same dramatic trend as the standard deviation; interestingly, it is much less smooth, probably because statistics are not available for every year for many countries (the sample size varies from as little as 17 to the maximum of 30).

The reduction in range is largely driven by outliers: Turkey, Mexico prior to 1989, and Hungary 1989 and later (which actually declined for several years starting in 1989, at the end of the Communist era).

Turkey's sudden increase starting in 1983 seems to be at the same time that the economy was modernized and liberalized.

Martin's suggestion to include quantiles would make this obvious, as the mean is actually less than the 1st quartile for most of 1960 to 1972!

Jock Mackinlay

In my blog entry Life expectancy, I show that Rachel Cunliffe is correct that the quartiles show that the variance has increased even though the range has reduced.

Jock Mackinlay

It's actually DavidS's post on variance that I explored here.

The comments to this entry are closed.

Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter