Vincent Gable’s Blog

April 1, 2009

Microsoft Excel Does Not Excel at Graphing

Filed under: Design,Quotes,Usability | , , , ,
― Vincent Gable on April 1, 2009

I gripe about Excel a lot, as we’re more or less forced to use it for data analysis in the intro labs (students who have taken the intro engineering course supposedly are taught how to work with Excel, and it’s kind of difficult to buy a computer without it these days, so it eliminates the “I couldn’t do anything with the data” excuse for not doing lab reports). This is a constant source of irritation, as the default settings are carefully chosen so as to make it difficult for students to do a good job of data presentation.

Now, you might be saying “Well, of course Excel isn’t appropriate for scientific data analysis. It’s not really for scientists, though.” Which is true, but here’s the thing: the things I’ve complained about here aren’t good for anything. The color schemes and axis settings lead to illegible plots no matter what sort of data you’re working with. And I’m completely at a loss as to the purpose of the “Line” plot, or making it difficult to find uncertainties in fitted quantitites.

Professor Chad Orzel, Why Does Excel Suck So Much?

There’s no question in my mind that a lot of serious analysis is done in(spite) Excel. I’ve worked with some very smart programmers, with PhDs in experimental science, who have “numerics” in their job description, and used Excel to make quick graphs.

The best solution I can recommend is reading The Visual Display of Quantitative Information. It’s probably the best guide to honestly presenting data graphically.

Unfortunately I don’t have a good recommendation for a better software program. The excellent redrawings at the chartjunk blog were done in Adobe Illustrator (more info in this comment). But Illustrator costs $599, and is a complex drawing program. Honestly the sticker price, and ease of use, have kept me from trying it.

What do you use to draw graphs?

2 Comments »

  1. Hello,

    I’m the author of the Chartjunk blog. Hello ^_^

    I did use Illustrator for those redrawings, with some use of its fairly lame graphing tools as a guide, before redrawing with the plain drawing tools over the top. More recently I’ve been trying Apple’s Numbers for the guide, which operates a lot like Excel but with less ugly defaults, and then redrawing over the top using the wonderful Inkscape. Inkscape is Free/Open Source software, and is in many ways better than Illustrator.

    I find it astonishing that there’s no really good software for producing clear, beautiful graphs. In the labs at my uni (UTS) we’re using SPSS, which is powerful but mind-numbing, with a GUI that’s been gathering cruft since the 1980s and eye-blinkingly ugly output.

    I’d love to hear about other options, too.

    Cheers,

    Viveka.

    Comment by Viveka — April 6, 2009 @ 2:43 am

  2. Viveka,

    Thanks for the reply, I’ll have to give Inkscape and Numbers a try.

    I’m really looking forward to the next Chartjunk update, it’s always interesting and high quality :-)

    Comment by Vincent Gable — April 6, 2009 @ 3:48 pm

RSS feed for comments on this post.

Leave a comment

Powered by WordPress