Okay, I'm getting really frustrated on what should be an easy thing.
The values for my X-Axis category lables areThe problem is I only want the values from N2 to the last occupied cell in the column. However, when I try to put in a dynamic range formula, Excel tells me the "OFFSET" function isn't valid. How do I get around this? Any help is greatly appreciated.
Please Login or Register to view this content.
Last edited by jomili; 07-01-2011 at 12:09 PM.
do not enter your dynamic formula in the charts data select dialog.
Use ribbon Formula > Name manger to define the formula.
http://peltiertech.com/Excel/Charts/Dynamics.html
So the field won't tolerate the formula, so you create a Named Range and use that in place of the formula? Okay, I don't understand the logic behind that, but it's easy enough to do. Thanks for pointing me in the right direction.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks