Microsoft Excel – Create star charts

In this tutorial we will be creating a star chart using an Excel spreadsheet, to do this we will be using Excels built in REPT function. This function will repeat text by a given number of times. In this example the text to be repeated will be a star icon.

To do this type =REPT(“⭐”,A1) and then press Enter.

The above will repeat the star icon based on the number found within cell A1.

And in case you are wondering the star icon can be replaced by practically anything else.

Leave a Reply