Creating a dynamic inset image on a chart

I need to find a way of creating an inset image on a scatter chart which changes as a result of one of the data points being selected in Excel 2007.

The images will be a .jpg in a defined folder. As the number of data points on the chart is large, it is not really practical to store the images in the workbook itself as there is a different image for each data point.

Ideally, I'm looking for a suitable image control, which I can position in the chart in a blank area, and change the linkage to its source file by VBA driven by the Chart_Select event. Any other mechanism which gave the same 'user experience' would also be OK.

I've tried copy/paste type approaches but these crash Excel completely with no hint as to what it doesn't like.

Any ideas?

Two ways to do this.

xl2007 specific, you can set the marker to use an external file source.

Please Login or Register  to view this content.

xl2007 and previous version, using copy+paste
You need to add a rectangle shape to the worksheet in order to load the image into.

Please Login or Register  to view this content.

In both cases I tested on a Line chart with single series containing 8 data points.
You will need to modify the location/name of the image files.

Andy

Excellent solution(s). Many thanks.

Regards

Martin