# How to Create In-Cell Bar Chart with REPT Function in Excel

In-cell charts are awesome.

And today, Iβll show you how to create an in-cell bar chart with REPT function.

But, do they really worth your time?

They are easy to create and simple to use.

Ahead, in this post, Iβll show a step by step process to create a decent bar chart with REPT function.

## But Do You Know About REPT Function?

### Syntax

`=REPT(text, number_times)`

## Steps to Create a Bar Chart With REPT Function

Here you have a mark sheet of students and you need to add a bar in the performance cell next to the marks column.

Here are the steps.

• Name both of the buttons βOnly Percentageβ & βBarsβ. And, link then to a cell. (I have linked then to cell A1)
• Now, come back to your data table and insert the following formula into the cell.
`=IF(A\$1=1,REPT(β|β,B3)&β β&TEXT(B3/100,β0%β),B3/100)`
• Make sure to change font style to βPlayBillβ.
• Now, drag the formula to the entire table and your bar chart is ready.

## Conclusion

By using this technique you can fire up your boring data.

If you compare both of the tables (with or without bars), youβll notice that by using bars you can present your data in an understandable way.

Now tell me one thing.

Do you like this tip?

Share your view with me in the comment section, Iβd love to hear from you. And, please donβt forget to share this tip with friends.

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ο¬nd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

### 12 thoughts

1. the bar has gone too large when i use 1000 instead of 100 in percentage ,is it can be fixed?

2. This is great Puneet! Keep publishing more.

Thanks

3. Thanks, Puneet; nice tip!

4. Hey When I am trying to assign cell A1 to the option button a message is displayed showing invalid reference. What to do!

5. Hi – in the formula you have (“|”)- Where is this on keyboard?
Thanks

• Above the enter key.

6. This is wonderful Puneet. Thanks a lot.
One input – you have mentioned “Make sure to change font style to PlayBillβ. This is fine with bars but it shrinks the percentages mentioned along with bars, making it difficult to read. Font “Britannic Bold” used in the Excel file is a better option removing this drawback. π

• Yes, you are absolutely right.