98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Jazzing Up Excel With Graphics
Mon 22nd March 2010
Charts are the most common (or the only!) graphic we associate with Excel. This needn't be so. Think about how you want your data to be viewed. Your audience may be pushed for time and may not have the inclination to see a pattern that you see as 'obvious' in the data. Never presume that a user of your data knows as much as you do about it. It's your data, of course you know the trends and results it has yielded in the Spreadsheet - but you're going to have to spell it out for other people.
Think about how you could do this. Let's say that despite the economic crisis, the sales figures in your company have been going steadily up this last financial year. That's great news, and something you'd want to share in the raw data. A chart steadily increasing from January to December may not give your message - yes, sales are up - anyone can see that, but think about how you can show the trend. Using an upwards arrow drawing, perhaps with a speech bubble drawn next to it (saying something like "this month is an increase of 20% on the last year") gets more attention than just showing people a chart and asking them to draw their own conclusions.
There are other subtle tools at your graphics disposal. You can have shapes (or indeed, your charts) filled, coloured - with a gradient or without - and even effects, such as shadowed or mirrored text or WordArt. A caveat, though - less is usually more when it comes to business presentation. If it's (literally) all singing, all dancing - be aware who will finally be reading this data.
There may be advantages to using particular features - mirroring text may be ideal for printing out onto a clear projector film so that it appears face up to the audience, for example.
Remember though, to be businesslike is to be professional, and that means - don't overdo it. If your presentation starts looking like a Christmas tree or something your kids would make, then you've probably gone too far! The graphics you use should enhance what you are trying to say, not detract from it. If you really want to be creative, you can bring in other more interactive programs such as Powerpoint or even a webpage that your clients or colleagues can surf. Remember - less is more when it comes to graphics, but it's worth considering a little splash of them to add panache to your presenting.
Author is a freelance copywriter. For more information on microsoft excel 2003 vba courses, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-794-jazzing-up-excel-with-graphics.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsBNP Paribas Real Estate UK
Graduate Trainee Sheel Raithatha Excel Intermediate The whole group thought Jens was a fantastic trainer. He was very entertaining, enthusiastic and extremely helpful. I have learnt a lot that will be directly relevant to my current job now and relevant to my future. I will definitely want to do the Advanced course when I get a chance and if Jens is holding it! PGS
Marketing Coordinator Berenice Lawton Organisational Skills Very benefial course! I’ve learned good new techniques. Dennis is an excellent trainer, very proffesional, friendly and engaging. The Building Societies Assocation
Finance Manager Samantha Hulass Writing for Results Cannot suggest anything |
PUBLICATION GUIDELINES