As everybody knows, excel has very good chart options to create excellent charts. But here we are not at all touching any of the Excel Chart option. I can create a simple bar chart by using REPT formula. This is one of the trick you can use while creating dashboards.

Here,

Text is the text you want to repeat

Number_times is a positive number specifying the number of times to repeat text

In simple terms, REPT repeats text a given number of times. We use REPT to fill a cell with a number of instances of a text string.

For Example, If we want to repeat alphabet 'S' as 10 times in a cell, then we have to use REPT formula as =REPT("S",10)

Then the result will be SSSSSSSSSS

Then, use the below formula in C2.

Then, it results as below.

Since this chart we creating by using REPT formula, let me start to explain REPT formula as first part.

All About REPT Formula?

Syntex of the REPT formula

**=REPT**(

**text**,

**number_times**

**)**

Here,

Text is the text you want to repeat

Number_times is a positive number specifying the number of times to repeat text

In simple terms, REPT repeats text a given number of times. We use REPT to fill a cell with a number of instances of a text string.

For Example, If we want to repeat alphabet 'S' as 10 times in a cell, then we have to use REPT formula as =REPT("S",10)

Then the result will be SSSSSSSSSS

How to create Chart with REPT function?

The below is the data which I am going to use to create a chart.

Name | Marks |
---|---|

Saran | 75 |

Harsha | 21 |

Vishnu | 64 |

Maruthi | 42 |

Bhyrav | 90 |

Raja | 12 |

Then, use the below formula in C2.

=REPT("I",B2)

Copy and Paste the same formula till the data ends ie., C7 cell.

Name | Marks | |
---|---|---|

Saran | 75 | =REPT("I",F6) |

Harsha | 21 | =REPT("I",F7) |

Vishnu | 64 | =REPT("I",F8) |

Maruthi | 42 | =REPT("I",F9) |

Bhyrav | 90 | =REPT("I",F10) |

Raja | 12 | =REPT("I",F11) |

Then, it results as below.

Name | Marks | |
---|---|---|

Saran | 75 | IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII |

Harsha | 21 | IIIIIIIIIIIIIIIIIIIII |

Vishnu | 64 | IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII |

Maruthi | 42 | IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII |

Bhyrav | 90 | IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII |

Raja | 12 | IIIIIIIIIIII |

The above result is nothing but the simple chart. Isn't it?

In fact, the above chart bars are horizontal. If you want to create chart with vertical bars.. then, use Format option in Excel.

Great little tip Saran!

ReplyDeleteThanks Rick !!

Delete