Linking picture of chart to a summary worksheet

Hello all,

I'm trying to show a dynamic picture of a scatter plot chart on a summary page worksheet without actually moving or copying the original chart itself. Just trying to reference the image of the whole chart. I've seen this done before in another WB using a the example formula ='Sheet1'!A1:d4 ,but I'm speculating that certain settings must be enabled for this to work because just replicating the formula itself gives me an value error and dismissed the apostrophes from the formula.

Any suggestions would be appreciated.

Thanks!

Originally Posted by CK76

One way is to use Camera tool.

Go into Options->Customize Ribbon->All Commands->Camera and add to ribbon.
Attachment 595910
Or alternately add it to your quick access tool bar.

Edit: Here's link to more detailed explanation.
https://trumpexcel.com/excel-camera-tool/

This worked perfectly. Thank you for the link!

You are welcome and thanks for the rep