Reassigning Chart Data Seried

[jim may]

I had previously assigned into the Data Series Box of my chart (xl2007):

='CurrYear-View'!$C$6:$K$22

Since then I created a dynamic Range Name -- MyCurrYr with RefersTo:
=Offset($C$6,0,0,17, Sumproduct(--($C$8:$K$8<>"")))

When I try and replace the Data Series (box)
='CurrYear-View'!$C$6:$K$22
with
=MyCurrYr - I get error message saying "check the formula.....etc..

If I enter it (in the box) as just MyCurrYr (without the "=" I'm able to
OK out without an error. I have SAVED the Workbook immediately afterwards. But each time I go back an view the Data Series Box - it still reads the original

='CurrYear-View'!$C$6:$K$22

It is NOT Sticking to the wall !!! LOL Any Comments of assistance?

Jim

 

[Marcelo Branco]

Hi Jim,

Tough issue...

Is the formula to set the dynamic-range working ok?

In other words, if you type in the Name Box MyCurrYr the proper range is being selected?

M.

 

[jim may]

Yes, The Formula is working - testing in the spreadsheet as =Sum(MyCurrYr) and also visually it checks out when going to the Name Manager selecting MyCurrYr and clicking at the end of the RefersTo formula line - the "marching-ants" surrond the cells displaying values.
Thanks,
Jim