Does Excel allow you to assign a value to a picture and vice versa?

I want to create a database that can create a visual report. The database
would be a table with specific percentages. However, when I need to generate
a report, those percentages need to be translated into pictures.

An example: A worker completes one task and not the other. The database
records a 1 to show the task is completed or 0 to show the task has not been
completed. When I need to print the worker's evaluation report, I want the
printout to show a happy face if the task was completed and an unhappy face
if it wasn't completed.

Suggestions?

Much appreciated!

What you can do is to put two picture on top of each other and bring the one
you want to the front. I did it yesterday for somebody. I used a
worksheet_change function. Based on a value in a pacrticular cell I moved
one of 3 pictures to the front. I used

ActiveSheet.Shapes("Picture 1").ShapeRange.ZOrder msoBringToFront

"Big D" wrote:

> Does Excel allow you to assign a value to a picture and vice versa?
>
> I want to create a database that can create a visual report. The database
> would be a table with specific percentages. However, when I need to generate
> a report, those percentages need to be translated into pictures.
>
> An example: A worker completes one task and not the other. The database
> records a 1 to show the task is completed or 0 to show the task has not been
> completed. When I need to print the worker's evaluation report, I want the
> printout to show a happy face if the task was completed and an unhappy face
> if it wasn't completed.
>
> Suggestions?
>
> Much appreciated!

Let A1:A10 hold the 1s and 0's
In A11 use =IF(SUM(A1:A10)>=7,CHAR(74),IF(SUM(A1:A10)>=5,CHAR(75),CHAR(76)))
Format the cell with Wingding font to get happy face, neutral face, frowning
face.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Big D" <Big (E-Mail Removed)> wrote in message
news:27EA2B43-41FC-4FC6-BB74-(E-Mail Removed)...
> Does Excel allow you to assign a value to a picture and vice versa?
>
> I want to create a database that can create a visual report. The database
> would be a table with specific percentages. However, when I need to
> generate
> a report, those percentages need to be translated into pictures.
>
> An example: A worker completes one task and not the other. The database
> records a 1 to show the task is completed or 0 to show the task has not
> been
> completed. When I need to print the worker's evaluation report, I want
> the
> printout to show a happy face if the task was completed and an unhappy
> face
> if it wasn't completed.
>
> Suggestions?
>
> Much appreciated!

Use this idea to assign to a worksheet_change event and use if to toggle.

ActiveSheet.Shapes("picture 1").Visible = True


--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Big D" <Big (E-Mail Removed)> wrote in message
news:27EA2B43-41FC-4FC6-BB74-(E-Mail Removed)...
> Does Excel allow you to assign a value to a picture and vice versa?
>
> I want to create a database that can create a visual report. The database
> would be a table with specific percentages. However, when I need to
> generate
> a report, those percentages need to be translated into pictures.
>
> An example: A worker completes one task and not the other. The database
> records a 1 to show the task is completed or 0 to show the task has not
> been
> completed. When I need to print the worker's evaluation report, I want
> the
> printout to show a happy face if the task was completed and an unhappy
> face
> if it wasn't completed.
>
> Suggestions?
>
> Much appreciated!