Dynamic X Axis

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

The values for my X-Axis category lables are

=View2Pivot!$N:$N

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.