This workbook contains a very
simple database of employees for a fictitious company. Using
a few formula and a modified XY scatter chart you can make
images appear when there corresponding name is selected from the
list. The example contains no macro code.
I have
previously solved this type of problem using named pictures and
macro code to either
A) move the pictures into or out of view
from a location way off screen or even another worksheet.
B) change the z-order of a picture
Details of setup and usage are stored within the
download.