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


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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Named Ranges with Vlookup Formula What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLOOKUP...
Create a Waterfall Chart With Excel 2016 Waterfall Charts are one of the many new Charts available only in Excel 2016. They are very popular in the current corporate environment as they graphically show the positive and negative movements within your Monthly Net Profit or Cash Flow. When I was working at General E...
Calculate Elapsed Time in Excel   What does it do? Converts a formula to text and lets you specify the display formatting by using special format strings Formula breakdown: =TEXT(value1 - value2, format text) What it means: =TEXT(formula, a text string enclosed in quotation marks) ...
Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data. The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...