View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NG NG is offline
external usenet poster
 
Posts: 18
Default inserting an autoshape into a chart

Hello everyone,

I have a smiley that changes color (yellow, green, red) based on a
percentage, I made that work with some help.

What i need is to insert that smiley face into a chart and have it change
colors when the new data is inserted into the next cell. I want to locate the
smiley on the upper right hand cornern of the chart.

I tried copy and paste, but it only pastes the current face and no color
change happens. I tried inserting it as a link but I cannot. How do i do
this???????

Thanks