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

Match Two Lists With The MATCH Function I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2. Well I have! With the MATCH function you can verify if a cell´s item in List1 exists in List2. The function will return the r...
Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart. For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables. Well you c...
Two Way Lookup Using The SUM Intersect Function There are various lookup functions that bring back values from a range of data like the VLOOKUP, INDEX, INDEX-MATCH and OFFSET functions, just to name a few. There is another lookup formula that you can use that will return the intersection of two Named Ranges! This is done...
Create a Pareto Chart With Excel 2016   Pareto Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are the most common. A Pareto chart, also called a sorted histogram, is a column...