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:


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


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


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)


REPT Function Chart



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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

INDEX Function Introduction The INDEX function in Excel returns a cell´s values from within a table/array.It works like a map, so you have to select a range (table/array) and tell it to return you the coordinates (Row & Column numbers).So if you want to return values from a Price List or large d...
How To Use INDEX-MATCH Formula The VLOOKUP formula searches for a value in the first column of an array and returns a value to the right of that array.How about if you wanted to return a value to the left hand side of that array?Well, this is where the INDEX-MATCH formula comes in and gives you a helpi...
Calculate Elapsed Time in Excel When you have two points in time and you want to calculate the amount of time elapsed, then you will need to use Excel´s TEXT functionSometimes data gets dumped into Excel with the following date & time format:24/01/2015  19:48:00.Using the TEXT function and enter...
Create a Random List with Excel’s RAND Formu... What does it do?Gives you a random number between 0 and 1Formula breakdown:=RAND()What it means:=RAND(Will automatically choose a random number between 0 and 1)Excel is able to do a lot of things that most users are unaware of!  One thing that amazes m...