Excel Trick – Instant bar charts anywhere

Excel instant chartsMicrosoft Excel’s charts are powerful, but boy are they a pain to use, especially if you just want quick, simple bars alongside your data. Well, no more: The blog at Juice Analytics has some very cool tips for making instant bar charts from your data. All it takes is the REPT() function, which will repeat any bit of text as many times as you want, and the | symbol. It certainly doesn’t sound earth-shattering, but the results are impressive. The blog post goes on to show how you can use conditional formatting to color-code the bars according the value, and in a follow-up post there’s even more impressive trickery. If you find yourself using Excel a lot, don’t miss these tips.

source [Lifehacker]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: