99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Create An Improvised Bar Chart In Excel
Tue 4th January 2011
It had been three months since the boss had installed CCTV around the premises and while studying the footage he noticed that staff had sometimes been rude to customers. He decided to sift through the whole three-month archive to see how prevalent this rudeness was and he was extremely disappointed at the results. He assured the staff that the CCTV had been installed for security purposes and not as a snooping device, but added that the firm's reputation must not be tarnished.
At his instruction the staff shuffled up and gathered around the computer screen. On it they saw an Excel chart with all their names in column A and the number of times they had been rude to customers in column B. The staff craned their necks in an attempt to make sense of the figures but it was all a jumble to them. What could the boss do to make the data more understandable?
He could sort the data to make a 'league table', but the ones at the back would still not be able to see the figures.
He could convert the data into a chart - if he knew how.
Or he could do this:
(If you would like to try this for yourself put the label Name in column A and No: in column B. Then type eight names into A and eight random numbers, say between 10 and 30 with some highs and lows, into B. Finally drag column C out to about the 25.00 mark and you are ready to go.)
In C2 type the following simple formula: =REPT("I",B2) and press Enter. You will see that, whatever figure is in B2, that's how many times the capital I appears in C2. Now select C2 again and click on the small dark square at the bottom right of the cell. Drag this down until you are level with the last name on the list (C9) and release. You now have what resembles a bar chart on which the worst offenders and the comparative angels can clearly be seen.
To break this formula down 'REPT' simply means repeat and the latter I is chosen only because it makes the finished result look like a marked measure such as you would see on the edge of a ruler - you could insert any letter in there. B2 is obviously the cell that the repeat refers to.
Now I know that there are more practical ways of showing data than this. But it is never a bad thing to have a few extra tricks up your sleeve and this particular one is at least functional. It also serves as a good demonstration of how the functions of an application can be ingeniously adapted to meet an unexpected need.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Excellent trainer, very patient.
Andrew clearly knew his subject matter and his enthusiasm was infectious and the pace was well guaged for all attendees.
PowerPoint Intermediate Advanced
The course was really great and all the tips I've picked up with be very helpful in the office.
The one thing that could be improved is the speed of the computers - simple things like PowerPoint and Excel at times took a little while to load!
I am booked on to my Intermediate Excel course next week at the same venue and I'm really looking forward to it!