Barry Ritholtz challenged readers to redesign an accurate graphical representation of some data here. The idea was to show how certain financials market caps have shrunk. The author of the original chart seems to have used circle radii to construct the graphic. The trouble is, you would want the area of the circles to be the comparison visual, not the radius. You could take the raw data divide by 3.14 (pi), then take square root. That would give you the correct radius size to use for comparison. If you can construct such circle charts in Excel, I don’t know how (I run an old version because I’m cheap as hell).
I would think you would need an engineering program, like AutoCAD to create the circles. You could also do it in a Google Sketch-up (free), but that’s a full pot of coffee assignment.
So here’s what I came up with using the author’s data:
Basic side by side.
I thought a more powerful presentation would be to show the losses, in Billions of dollars and percentage of Market Cap. Which looks like this:
Using the secondary scale, I could not get the data to display side by side (hopefully this has been corrected in more recent versions of excel), so I had to use the overlay style you see here.
Hope you like it (tough shit if you don’t).