Comments on: The Ebb and Flow of Movies: Box Office Receipts 1986 – 2007 (NY Times)

By: ‘One of the worst graphics the New York Times have published - ever!’ (Alberto Cairo via Visual Journalism) « Kelso’s Corner

Wed, 17 Mar 2010 11:01:14 +0000

[...] supplements and posters they like to admire and reexamine. This might have been raised by the 2008 box office graphic from the NY Times, implementing a steamgraph, but the general question applies to all infographic [...]

By: dekkerbj

dekkerbj — Mon, 17 Mar 2008 22:04:58 +0000

Wow! Guess “R” made the difference in these graphs. When I have a year or two to spare, I’ll get to the bottom of it.

By: kelsonv

kelsonv — Mon, 17 Mar 2008 15:57:36 +0000

Digging more, Amanda Cox at the NY Times used R, a statistical program that has a very steep learning curve to filter the data and create the graphic. Get in over your head here: http://www.r-project.org/

By: dekkerbj

dekkerbj — Mon, 17 Mar 2008 15:49:13 +0000

Hi there,

Been looking at a lot of “wavegraphs”, “lastgraphs” and “themerivers” lately, I was intrigued and tried al your ideas – thanks very much for your mail by the way. With Betterhandles I was able to pull out the handles the same amount and rotate them all to horizontal, which is what i found in all the LastFM graphs. This works great!
In all those graphs created from LastFM data (lots of pdfs on the internet!), the data is presented symmetrical – not the case in the NY-times graphic – but easy to recreate in Excel with a formula and an extra column of data to fill the bottom part (to be thrown away).
I don’t think the movie-graph is made up of two seamed-up graphs, since you can’t see a middle-line. Seems to be just random, or at least not serving a goal to help legibility.
Thank you very much for your ideas on this and the great blog – keep up the great work.

By: kelsonv

kelsonv — Fri, 07 Mar 2008 00:04:16 +0000

Or if you have CS3, there is a handy option for converting points to curves. Just select the anchor points with the hollow arrow selection tool and then there are extra settings in the control panel for changing the points to curve (and back to hard angle).

By: kelsonv

kelsonv — Thu, 06 Mar 2008 23:38:49 +0000

Two solutions to smoothing out the sharply angled stacked area chart imported from Excel are:

A free script:
http://illustrator.hilfdirselbst.ch/dokuwiki/en/skripte/javascript/smooth_points

A pay plug-in:
http://www.nineblock.com/products.html#betterhandles_prod

By: kelsonv

kelsonv — Thu, 06 Mar 2008 23:26:16 +0000

The interactive version (http://www.nytimes.com/interactive/2008/02/23/movies/20080223_REVENUE_GRAPHIC.html) has a search ability that makes finding films easy.

If I were to create a similar graphic, I’d start in Excel and create two filled and stacked bar charts. For each chart I’d take half the films selected (some box office hits, some duds to even things out). These are time series where much of the time axis has 0 data values until the opening of the film. Then a big opening weekend and finally trailing off with a long tail till ending its box office run and then 0 values past that date. The data was weekly and there are 52 weeks in a year so 1040 total entries for each film. Open both charts into Illustrator. Now flip one so it formed the “bottom” half of this graphic. In the print version that would be the “left” and “right” halves. Join the two up along the common seam. Run a script or plugin to pull out the anchor points on each vertex for the bar chart fills, this gives it that nice curvy look. Then use the warp tool in Illustrator to give it the sine-wave effect by running it manually along the seam. Then fine tune the final result till it looks nice. Does that help?

By: dekkerbj

dekkerbj — Thu, 06 Mar 2008 23:02:35 +0000

…curious as to the few ideas how this was created? I like it for originality and of course information, although it is dificult to actually find a movie that you’re interested in (if it wasn’t huge). Also arbitrary which movies are up and down, it seems relevant but isn’t (right?). Still, viewers will definetely spend some time on this, it’s great fun.