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.
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.
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: excel, excel 2003, excel 2007, image
Posted in: Random
Follow any responses to this entry through the RSS 2.0 feed.
13 Responses to “ A plea: abandon Excel 2003 graphs ”
Leave a Reply
Authors
- Barry Collins
- Chris Brennan
- Christine Horton
- Darien Graham-Smith
- Dave Stevenson
- Davey Winder
- David Bayon
- David Fearon
- Ewen Rankin
- Ian Devlin
- Jon Honeyball
- Jonathan Bray
- Kevin Partner
- Mike Jennings
- Nicole Kobie
- Sasha Muller
- Steve Cassidy
- Stewart Mitchell
- Stuart Turton
- Tim Danton
- Tom Arah
Categories
- About the bloggers
- Android App of the Week
- cloud computing
- Green
- Hardware
- How To
- iPhone App of the Week
- Just in
- Microsoft Office 2010
- Newsdesk
- Online business
- Random
- Rant
- Real World Computing
- Software
- View from the Labs
- Windows 7
- Windows 8
Archives
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
advertisement




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!
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?
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
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
September 19th, 2008 at 1:37 pm
All I see is, Excel2007 graphs would be better readable when faxed.
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.
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
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..
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.
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!!
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.
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.
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!