skiingrudder
New Member
- Joined
- Jul 18, 2010
- Messages
- 2
I have created a chart on a worksheet with links to named ranges scoped to that worksheet. When I copy the sheet to a new sheet, the formulas for the series are changed to static formulas.
This is a formula from the chart on the original sheet: =SERIES(Original!$A$2,Original!XaxisLabels,Original!mydata,1) where XaxisLabels and mydata are named ranges.
After the sheet is copied, this is the formula from the copied sheet: =SERIES('Original (2)'!$A$2,'Original (2)'!$B$1:$C$1,'Original (2)'!$B$2:$C$2,1)
Any idea why the new formulas do not contain named ranges?
This is a formula from the chart on the original sheet: =SERIES(Original!$A$2,Original!XaxisLabels,Original!mydata,1) where XaxisLabels and mydata are named ranges.
After the sheet is copied, this is the formula from the copied sheet: =SERIES('Original (2)'!$A$2,'Original (2)'!$B$1:$C$1,'Original (2)'!$B$2:$C$2,1)
Any idea why the new formulas do not contain named ranges?
