AJP Excel Information

Picture viewer

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.

Alternative links