You can use REPT to repeat any character(s) you like. In this example, we use the CHAR function to output a character with a code of 110. This character, when formatted with the Wingdings font, will output a solid square. To calculate the “number of times” for REPT, we scale values in column C by dividing each value by 100. This has the effect of outputting one full square per 100 dollars of sales. Increase or decrease the divisor to suit the data and available space.

Conditional formatting option

You can also use the “data bars” feature in conditional formatting to display an in cell bar.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.