I would like to set up a PivotTable with data from a named range. I.e. a dynamic chart.

I know this may seem silly since it is a PivotTable but I have my reasons. Trust me.

So when I use the PivotTable & Chart wizard when it asks in step 2 where is the data that you want to use? Range: how can I say =pivotdata a variable I made using Ctrl+F3 and offsets and all sorts of fun stuff. It currently gives me the error "reference is not valid"

Thanks!
~RUTH~