Basic in cell histogram

Basic in cell histogram

Generic formula 

=REPT(barchar,value/100)

Related formulas 

Pad a number with zeros

Explanation

To create a simple in-cell histogram, you can use a formula based on the REPT function. This can be handy when you have straightforward data, and want to avoid the complexity of a separate chart.

=REPT(CHAR(110),C11/100)

How this formula works

The REPT function simply repeats values. For example, this formula outputs 10 asterisks:

=REPT("*",10) // outputs **********

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.

CHAR(110) // square in Wingdings

To calculate the "number of times" for REPT, we scale values in column C by piding each value by 100. 

C11/100 // scale values down

This has the effect of outputting one full square per 100 dollars of sales. Increase or decrease the pisor 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.

Basic in cell histogram

Generic formula 

=REPT(barchar,value/100)

Related formulas 

Pad a number with zeros

Explanation

To create a simple in-cell histogram, you can use a formula based on the REPT function. This can be handy when you have straightforward data, and want to avoid the complexity of a separate chart.

=REPT(CHAR(110),C11/100)

How this formula works

The REPT function simply repeats values. For example, this formula outputs 10 asterisks:

=REPT("*",10) // outputs **********

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.

CHAR(110) // square in Wingdings

To calculate the "number of times" for REPT, we scale values in column C by piding each value by 100. 

C11/100 // scale values down

This has the effect of outputting one full square per 100 dollars of sales. Increase or decrease the pisor 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.