Trying to figure out character in a chart

[Stephen_IV]

I got this file from a book by Michael Alexander & John Walkenbach (Excel Dashboards and Reports) but for the life of me I cannot figure out what the character in O1 is could someone please help me. Thanks in advance Stephen



http://www.filedropper.com/jwalkexample

 

[VoG]

It reports as CHAR 63 (which is normally a question mark).

You can get that symbol (or something very similar) by entering g then changing the font to Marlett.

 

[Stephen_IV]

Vog,

That's what I got. strange though marlett does not work exactly like it. If I take the character and put it into the formula

=REPT("█",C2/MAX($C$2:$C$22)*10)

It works perfectly strange how he got this character and I can not figure it out?

 

[planetpj]

Try | with the Britannic Bold font see if that will do what you want.

=REPT("|",C2/MAX($C$2:$C$22)*10)