Copy across named ranges when copying a chart (excel 2010)

[Steve381]

I have the following issue with a named range within a chart when copying the tab. Using excel 2010.
NAMED RANGE
BAND ='TAB1'!$C$32:OFFSET('TAB1'!$C$32,0,COUNTA('TAB1'!$4:$4)-2)
Selects only the fields in row 32 of table (in tab 'TAB1') from C32 where there is an entry in row 4. The end result, when working, ensures that there are no blank columns at the end of my chart.
I then created a series in my chart using the named range:
Series name:
='TAB1'!$B$32 (‘returns the word ‘BAND’)
Series values:
='TAB1'!BAND
When I copy the tab, (now named TAB2) the named ranged does not copy across to the series values, despite the actual named range being created for TAB2. The series in the chart is as below:
Series name:
='TAB2'!$B$32
Series values:
='TAB2'!$C$32
Can anybody suggest a solution so that the named range is copied across rather than just referencing the cell the named range starts from? Please note I have multiple series which essentially make up a stacked bar chart, all using named ranges.

 

[palffy]

I'm having the same issue copying a named range located in a chart to another one. Although it's copied in name manager, the named range copies as a reference, ie $A$1, vs xrange. (I'm using Excel 2007).

Can anyone make any suggestions to make this work?