Linked Picture to Chart

T

Terry Miller

I can not link a picture of a cell to a chart. I tried
the shift-paste method but the shift-paste-link is greyed
out.

I tried the = sign on the highlighted picture in the chart
but it just gives me a text book in the chart.

I have conditional formating on the cell and that
'color' changes with my data. Any help is appreciated.

USAF
 
D

Debra Dalgleish

You could use a Worksheet_Change event to delete the old picture, and
paste a new one into the chart, when a different value is entered in the
cell.
 
T

Terry Miller

Thanks Debra. but I don't know how to do that. I have
found instructions on-line that says it can be done, what
gives?
 
Top