After regaling us with an Unemployment Panel Chart a week ago, Paresh picked out yet another chart from the NYT pages and asked us to recreate it and improve it in the process.
The chart in question is a dot-plot (learn about them here), that shows the instances of repeat violations by big wall street firms after promising the government never to breach such acts again. Data shows 29 violations of section 17(a) of the Securities Act, and 16 infringements of section 15(c) of the Securities Exchange Act between 1997 - 2011.
The chart was easy to replicate in Excel. For improvement, I shaded every repeat instance in a different color and added labels to show the count.