Skip to main content

US Open Tennis

Charting a sporting event is always great fun. More so, if that happens to be the vibrant US Open Tennis Championships which I came across in this piece. But to me, it appeared somewhat wayward and lacking purpose. Most of its charts could have been more efficiently represented through a table, and the only one which made some sense, or added some value was the one that depicted the US women’s singles champion by country over time (1900 - 2011).

I decided to approach this from a different perspective. Firstly, I separated the amateur years from the Open era which began in 1968. From 1881-1911, the US Open used a challenge system whereby the defending champion automatically qualified for the next year's final, creating in the bargain, some unbelievable feats like Richard Sears remaining undefeated in the tournament and winning the inaugural seven editions of the Championships. Furthermore, the difficulty in travelling to and from the USA in the earlier years can also be attributed to US ladies winning 26 of the first 28 editions, with only Mabel Cahill from Britain managing to break the stranglehold, and the men topping it by winning all but one between 1881-1925, when in 1903, Lawrence Doherty triumphed.

It also threw up some quirky facts:
  • Players from 5 nations have won the US Open Men's & Ladies Championship before the Open Era. 
  • Players from 11 nations have won the US Open Men's & Ladies Championship in the Open Era. 
  • In 44 years of the US Open since 1968, a total of 44 players has won either the Men or the Ladies Championship. 
My Chart looks as follows.

Pick a Country:


Pick a Year:


and finally, Pick a Champion:

Comments

Popular posts from this blog

Florence Nightingale Circumplex Chart

I was taken to the  Florence Nightingale's Wiki page   during a recent research, and one of the interesting things I noted was her contribution to statistics. It came to me as a pleasant surprise that she is credited with inventing the polar area diagram , or occasionally the Nightingale rose diagram, which is equivalent to a modern circular histogram. Following the completion of my project and in my weekend to spare, I devoted time to recreating the chart in Excel. It took a combination of Doughnut-Pie-and XY charts and close to four hours to finish it. The colours are a bit darker, the values are approximate and the labels differently oriented, yet the chart looks fairly close to the original as is shown by the picture below.

The Playfair Charts: Scotland ExIm Barchart

Soon after finishing the second Playfair chart, the one on Wheat Price and Wages, I searched the internet for additional charts made by him. I found a Bar chart circa 1786, which showed the Scottish export and import volumes with other countries. For me, the real thrill was to scroll by the list of the name of places long consigned to history books - Jersey Is, Greenland, Prussia, Denmark and Norway (together) and Flanders.  First, the original Playfair Barchart from Wikipedia,  Then, my version of it in Excel.  A couple of parting words:  Excel 2007 no longer support dots and lines as fillers for charts. Hence, the ribbed import chart is given a different color, Gold.  Normally, I'd use data point labels to construct the chart legends and other declarations given at the bottom of the chart. However, given Excel 2007' inability to automatically re-size labels to fit texts, I was forced to use text-boxes instead. 

The Playfair Charts: Wheat Price and Wages

After successfully recreating the Playfair trade-balance time-series chart , I took up the second chart shown in Jorge's post which is fancifully titled, "Chart showing at one view the price of the quarter of wheat and Wages of Labour by the week from The year 1565 to 1821." I left out the top arches. Comparatively, this was the easier chart. Staying true to Jorge' rules, I didn't use any shape or clipart objects in this chart. The big oval shaped object in the middle of the chart, which contains the title is actually a marker for a data point. The original Playfair Wheat price and Wages chart from Wikipedia, and underneath, is my version in Excel.