Sometimes you have to strangle software to get what you want. I was looking for a new way to compare world growth across analytical groups. Starting with an excel bubble chart, I noticed that sorting the values by growth rate, and sizing them by GDP value, produces a very beautiful visualization of the distribution. Looking closer, however, I noticed that excel literally draws the graph in the sorted order (lowest to highest in this case), resulting in some of the smaller balls being hidden by the larger ones:
To fix this turned out to be quite complicated, requiring some software hopping. First you have to copy and paste the chart into Powerpoint, then right-click/save-as-picture into an enhanced metafile (.emf), which you can then open in Illustrator where you can bring all the hidden balls to the front. Anyways, the end result is below. I hope the technique is useful to anyone looking to do some post-production excel chart tweaking.
An addictive collection of beautiful charts, graphs, maps, and interactive data visualization toys -- on topics from around the world.