Data Range Bars Using REPT Formula

This post will cover how to create a simple graph for each record, using REPT function. The parameter are very simple to follow, you just need to specify Text ,and Number of Times you want to repeat the text. It is the simplest way of visually observing the  performance and status of person record.

Launch Excel 2010, open a datasheet on which you want to show the data bars from formula. For instance, we have included a datasheet, which contain fields; Name,  Marks, showing name and marks obtained by the students, as shown in the screenshot below.

To start out with, we will be adding a new row label adjacent to Marks, by the name of Graph. We will write formula on the first row of Graph.

graph Excel 2010: Data Range Bars Using REPT Formula

The syntax of the formula is;

=REPT(text, number_times)

In formula, REPT refers to repeat. The first parameter text refers to the string you want to show. Second parameter number_times refers to how many times the string will be repeated.

So we will fill parameters as;

=REPT(“X”, C2)

The X will be repeated as many times as specified in location C2 (80), as shown in the screen shot below.


Now apply the formula on the whole column by dragging the plus sign at the end of the cell to the end of the column.


As you can see in the screen shot below, we have make a simple data bar from formula, showing marks obtained by each student visually. Now from the Graph you can infer the overall position of any student.

graph co0mplete

You can also check out previously reviewed guides on Camera function in Excel & Using Payment Function In Excel 2010

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *