Happy Face Graph ... Is it possible?

[Ken]

Excel 2000 ... Is it possible to create a "HAPPY FACE"
Graph where the Face would incrementally turn from a "SAD"
Face to a "HAPPY" Face as Customer Satisfaction Score
changed (hopefully improved) from 0.00% to 100.00%???

Hopefully, this ? is not toooooo far out on the fringe ...

Thanks ... Kha

 

[Jazzer]

Hi,

One way to do this (without VBA or charts) is to use happy fac
characters, that can be found from Windigns font.

Use a function like this:

=IF(A1<0.33,"L",IF(A1<0.66,"K","J"))

In A1 you shuold have the customer satisfaction value. The limits fo
different "faces" are 33% and 66% in this example. Just change the fon
of the cell where the formula is to Windings.

- Asse

 

[Ken]

Asser (Hi) ... Excel 2000 ... Can't find "Happy Face" in
Wingding Fonts ... Perhaps I am doing something
incorrect ... Also, you bring up interesting point to
create changing "Happy Face" in a Cell ... That said ... I
would like to know how to create in a Cell as well as
create a Chart ... If this is possible? ... Thanks ... Kha

 

[Peo Sjoblom]

Format as wingdings, hold down alt key while typing 74 on the numpad or type
J and format as wingdings

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Ken]

Peo ... Got it ... Ltrs were CASE sensative ... I needed
to type "J" instead of "j" to get Smiley Face when
formatted "Wingdings" ... Thanks ...

Now ... is a "Happy Face" Chart possible? ... Thanks ...
Kha

 

[Debra Dalgleish]

You could use an event macro to change the face when a value is entered
on the worksheet.

There's a sample here:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Happy Face Gauge'