How to create teeny tiny barcharts in Excel #MRX

Prepare to be astounded. This great little chart is perfect for those situations where you normally share an excel sheet instead of creating a ppt or word file.

First, go and download a font called Bargraph. Be sure to install it before you open up Excel.

Now follow these few steps.

  1. Lay out your series of numbers in separate columns as you normally would. Monthly sales data, weekly counts, whatever it may be.
  2. Copy the concatenate equation that you see in the image below to turn the 12 separate numbers into 1 single number in column N.
  3. Change the font of column N to bargraph, as you can see in the font choice menu.
  4. Done!

bar graph font excel

You may find that the numbers you want to use aren’t single digits as is required to create this chart. All you need to do is transform your numbers into single digits. It may be as simple as dividing each number by 600 as I have done below. You could also try using log or other traditional functions. Be sure to round to zero decimal places or truncate the number so that there are no decimal places. Remember, you can only use the numbers between 0 and 9.  And…. you’re done!bar graph font excel

About these ads

2 responses

  1. Here is a thought. Why not just use Sparklines found under the insert tab.

    Then you don’t even need to sign-up for for FontStruct, download font, etc etc.. Nor do you have to do the trick to get to single digits

    1. That’s definitely the best way to go if you’ve got a new version of Excel.

Agree? Disagree? Share your thoughts!

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Buy The Listen Lady Book

Annie Pettit Buy Book listen lady amazon kindle ibookstore
Now in the iBookstore!

Learn about social media the quick and easy way. Buy your copy on Amazon.com the iBookstore or smashwords.

Enter your email address to subscribe to this blog.

Join 8,882 other followers

LoveStats on Twitter

All Top

Featured in Alltop
Follow

Get every new post delivered to your Inbox.

Join 8,882 other followers

%d bloggers like this: