I have a relative reference macro that I would like to produce a chart. Is it possible to set the "sheet" to activesheet or something similar, so that the activechart will produce a chart for the sheet that is open and not the sheet used to record the macro initially?
