Using “Playbill” font & Excel formula for incell charts

Using “Playbill” font & Excel formula for incell charts

With REPT formula and symbol (“|”), we can make in-cell charts. And to look them just like a chart, use the playbill font. We can change the theme color as well to make it more prominent/attractive.

For example, our data is in range D3:D7. Use the below formula. Here we are repeating the symbol and the number of times is the cell value divided by the maximum number of the list/range and multiplied by hundred. It’s easy & simple, just try it.

=REPT("|",D3/MAX($D$3:$D$7)*100)