When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.

The RPT function uses the vertical bar character | as the first argument: text and references the value cell for the second argument: number_times

So it enters the vertical bar character by the amount of times of the value cell, looking something like this:

||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Here is how it is done in just a few steps:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter the REPT function in a column next to your values

=REPT(text,number_times)

STEP 2: Enter the vertical bar keyboard character in the first argument =REPT(“|”)

bzc3W

STEP 3: Reference the value cell for the second argument =REPT(“|”a1)

STEP 4: Highlight the formula column and insert the Stencil font from the Home menu and choose a font color

STEP 5: If your value cells are high, the bar will go out of your screen.  To fix this, you need to enter a divisor in the second argument of your formula which will reduce the length eg =REPT(“|”,a1/5)

2015-11-26_19-57-58

REPT Function Chart

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin