Andrew Gelman didn’t care for the ugly spiderweb chart in the Economist article The battle of Smoot-Hawley about the Smoot-Hawley Act. This was a flawed protectionist measure enacted in 1930, which led to decreased international trade and furthered the Great Depression. Andrew states that even a simple time series would be an improvement. As step one in my elaboration on his comment, I’ve recreated the Economist chart of world trade below.
The exercise above shows the best and worst of Excel: it is flexible enough to produce almost any visualization you want (albeit sometimes with substantial effort), but it does not provide guidance on which visualizations are effective, and the default options often lead to poor choices. The poor choice in this case was not due to Excel’s defaults, because this chart is not even possible with a built-in radar chart. Fortunately it requires substantial effort as mentioned above, so we aren’t likely to see many of these charts.
Well, this is an eye-catching chart. It seems to show an inward spiral, but the overall trend is really not very clear. It also looks distorted, too tall and not wide enough, but I examined axis settings several times, then even physically measured the lengths of the January-July and April-October spokes, and everything lined up. This optical illusion was caused by plotting the data in a radar chart: April and October were the two largest numbers in 1929, stretching the curve vertically. The first step to improving this chart is to cut it between December and January, and unroll it. This makes it possible to see month-to-month variation in the values (for example the dips in February 1929 and February 1931 and the spikes in October 1929 and October 1930), and use of year labels eliminates the need for the legend. The new chart takes up less space than the spiral chart. The colors are not even necessary, so this line chart could be published in black and white without any loss in fidelity.
We can see from this new chart that trade was uniform through 1929, but in 1930 (the year of the Smoot-Hawley Act) and in 1931 international trade went into a steady decline.
If we were interested in comparing the month-by-month values for different years, for example to assess seasonal behavior in trade, this would be an effective view. To assess longer-term trends, however, a continuous timeline approach is best. A timeline allows us to use labels to denote events in time, such as the stock market crash of 1929 and the passage of the Smoot-Hawley Act the following year.
In the chart below, we can easily see the downward trend which started around the time of the stock market crash of October 1929. The trend was well underway even before the Smoot-Hawley Act was enacted in June 1930, because many international trade partners had instituted preemptive retaliatory tariffs of their own. By the middle of 1932, the volume of international trade had effectively plateaued at one-third of its high of 1929.
The colors aren’t needed in this chart; the monochromatic version below is equally effective. In fact, it removes the artificial separation between years which is so striking in the chart above.