Skip to navigation

PCPro-Computing in the Real World Printed from www.pcpro.co.uk

Register to receive our regular email newsletter at http://www.pcpro.co.uk/registration.

The newsletter contains links to our latest PC news, product reviews, features and how-to guides, plus special offers and competitions.

// Home / Blogs

Posted on September 19th, 2008 by Tim Danton

A plea: abandon Excel 2003 graphs

I’m writing this from the Budapest World Congress Centre, at Acer’s grandiose and beautifully presented Global Press Conference 2008. It’s a chance for the company to set out its strategy to over 200 journalists, to essentially show off.

So it’s perhaps surprising that it’s still using what I wholly believe to be the world’s worst graphing tool: Excel 2003.

The original version in lovely Excel 2003

Above is one of the slides they’ve just shown us, and as you can see it’s all good news for Acer. 

But it looks rubbish. Now I’m not claiming to be an Excel genius or indeed a presentation expert, but this is what I knocked up in Excel 2007 based on its far superior new chart templates.

The more professional Excel 2007 version

This may seem a minor point – it is a minor point – but any company that uses Excel 2003 to produce its graphs needs to think about what those shoddy-looking images do to their company image too.

Tags: , , ,

Posted in: Random

Permalink | Trackback

Follow any responses to this entry through the RSS 2.0 feed.

13 Responses to “ A plea: abandon Excel 2003 graphs ”

  1. CodeMonkey Says:
    September 19th, 2008 at 10:49 am

    Excel 2003 is so deeply ingrained in the day-to-day activities of one company I know that it simply couldn’t function without it. They are absolutely terrified of upgrading to 2007!

     
  2. MJ Says:
    September 19th, 2008 at 10:50 am

    Not too sure what the difference is. Apart from yours not showing ‘%’ in the left axis and therefore having less information. Are you really saying that removing some boxes is a reason to change your office suite?

     
  3. Jobby Says:
    September 19th, 2008 at 11:35 am

    I hadn’t noticed the boxes were gone until MJ pointed it out! Truly those Excel 2003 graphs are primitive

     
  4. David Wright Says:
    September 19th, 2008 at 12:22 pm

    Didn’t you know? Less is more!

    With the attention span of the average hack these days, the extra % signs and boxes mean that they have lost interest before they have got to the actual data :-D

     
  5. stasi47 Says:
    September 19th, 2008 at 1:37 pm

    All I see is, Excel2007 graphs would be better readable when faxed.

     
  6. richard Says:
    September 19th, 2008 at 3:05 pm

    Personally I have uninstalled Excel 2007 and and gone back to 2003 because of the terrible graphs in 2007. I use graphs for scientific purposes, not presentations, and its far far harder to many things I want (eg customise them to multiple data sets) in 2007. MS has gone down the road of making it easier for a casual user to make something and harder for a real user to make what he needs.

     
  7. josh Says:
    September 19th, 2008 at 7:04 pm

    So what, the graphs aren’t pretty? That’s hardly a basis to say that excel 2007 graphs are any better. What about using flash or countless other great presentation tools? I suppose pcpro will be singing the praises of powerpoint 2007.

    Pull your finger out pcpro and get back to writing decent articles

     
  8. Tim Danton Says:
    September 22nd, 2008 at 10:44 am

    @josh Matt Sparkes has written about alternative tools in his post, which you’ll find just above this one. “…get back to writing decent articles.” As I said right at the end, this was only a quick point, and I was reacting to it (quickly) during a presentation. This is the PC Pro blog, not the PC Pro In Depth section..

     
  9. c6ten Says:
    September 22nd, 2008 at 11:59 am

    I’m not happy with any of the common chart tools on Windows. You should not be able to look at an Excel chart and say “Yes, that’s an Excel chart”, but you can. I asked around and the decent output you see in magazines like the Economist seem to have been created with a QuarkXPress plugin, and it costs $$$$. Of course on a Mac you have Numbers, but this is an unsolved problem from my point of view: presentation quality charts that don’t cost an arm and a leg.

    btw the guy above who said he didn’t like Excel. This may be because he wanted to draw graphs. Charts are for presentation only, graphs are best done with a scientific tool like Matlab etc.

     
  10. MoJoker Says:
    September 23rd, 2008 at 9:27 am

    Umm, I’m sure with a tiny bit of effort, you could make the Excel 2003 chart look just like the Excel 2007 chart. Just need to right-click and change the colour, scale and shapes etc. Less than 20secs – Looks more like they didn’t think making it look pretty was that important!!

     
  11. Strangely Perfect Says:
    September 25th, 2008 at 5:52 pm

    The only difference is washed out colours and transparent box borders in the 2007 example.
    These can all be set either manually or in code in 2003.

    I always follow the maxim I learnt years ago that a chart or graph (whatever you want to call it), isn’t complete until the axes are clearly labelled and scaled. Otherwise, it’s rubbish and just shows lines wiggling about, that is, it’s seeking to deceive.

    Also, I only use the wizard as a start. If Tim Danton is so time-pressed he should get a clerk to do it for him. So like Josh; PCPro, write some decent articles.

     
  12. Lindsay Rooms Says:
    September 26th, 2008 at 7:51 am

    An Excel Chart is as good as its creator’s imagination and adherence to good practise. Sad of Acer not to demonstrate this.

    You can adjust an Excel graph ad infinitum to show a picture that truly represents an understandable trend in a pattern of numbers. 2007 has the advantage of its 3D graphics – BUT at the expense of speed.

    In Excel 2003 I could programme in VBA x =x+1 (or similar) and loop it to produce a graph ‘firing’ ‘bullets’ or ‘missiles’ and the graph would refresh as fast as the on-board processor allows – fast. In running in 2007, on the same graph, the moving point crawls across the graph ruining one of my best exercises.

     
  13. Tim Danton Says:
    September 26th, 2008 at 8:51 am

    @Lindsay Thanks for that point. I wish you’d been the one who created all the Excel 2003 graphs I’ve seen over the years!

     

Leave a Reply

Spam Protection by WP-SpamFree

* required fields

* Will not be published

SEARCH
SIGN UP

Your email:

Your password:

remember me

advertisement


Hitwise Top 10 Website 2010