RandomWa1k
New Member
- Joined
- Mar 25, 2009
- Messages
- 10
Hey,
I'm making some charts with dynamic ranges using Series() and named ranges with offset().
While my named range for dates is working fine, the Series function isn't taking the named range with the y values. I checked the named range and its selecting the proper area. The problem is, when I enter the 'book1.xlsx'!Y_VALUE into the series function and hit 'enter,' nothing happens. I don't get an error, but I also can't lock in the formula and move on.
Any ideas here?
Thanks
I'm making some charts with dynamic ranges using Series() and named ranges with offset().
While my named range for dates is working fine, the Series function isn't taking the named range with the y values. I checked the named range and its selecting the proper area. The problem is, when I enter the 'book1.xlsx'!Y_VALUE into the series function and hit 'enter,' nothing happens. I don't get an error, but I also can't lock in the formula and move on.
Any ideas here?
Thanks