Chart on any page in workbook

I wish to use a macro to generate a chart from any sheet in a workbook using data on another sheet in the same workbook. The key questions seem to be a) how to define the data range in a form which is accessible from any sheet and b) the syntax to reference the defined range. My attempt has thus far failed:

Please Login or Register  to view this content.

I hope that there is a solution that I am missing. Thanks in advance for reading this Post and for any help that is offered.

Thanks humdingaling for the suggestion, I like the technique and will use it in the future. I had to use a kind of brute force method to resolve my requirement.

Any suggestions for improvement gratefully accepted.

Thanks again humdingaling, another good idea for the future. In this current case the counts being copied can in fact be changed by user entries made on the "plot" sheet. Remember I was originally attempting to generate the chart on any worksheet by accessing the data on the "Graph" sheet. I only "fell back" on the Activate approach when I wasn't able figure out "remote" access to the cells on the "Graph" worksheet. It isn't as elegant as I would like, but it works.

Thanks again for all your help.