You can use the camera tool for this --
To add the camera tool to your toolbar:
Choose Tools>Customize
Select the Commands tab
Select the Tools category
In the list of commands, scroll down about 1/2 way, to find the
Camera tool
Drag it onto one of your existing toolbars
Close the customize dialog box
Select a range of cells
Click the Camera button
Select the chart sheet
Click on the chart to place the picture.