Dynamic X Axis

[jomili]

Okay, I'm getting really frustrated on what should be an easy thing.

The values for my X-Axis category lables are

Please Login or Register  to view this content.

The 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.

[Andy Pope]

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

[jomili]

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.