jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
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
='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
