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!
Bookmarks