Reference in charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to reference a active worksheet in a chart but I keep getting
error messages. On the series tab of step 2 of the chart making process, I
would like to substitute the current worksheet instead of the permanent one
already in there.

Instead of ='Testing_Macro'!$A$1:$A$20

I want Testing_Macro replaced with a reference to an active sheet name. Any
ideas?
 
Hi,

Something more like this.

="'" & activesheet.name & "'!$A$1:$A$20"

If the chart sheet is the activesheet this will fail.

Cheers
Andy
 
Back
Top