Hi Chandoo!
Thanks so much for your response. I appreciate your work-around and it's been working well.
I also managed to create a working dynamic range that grabs all the top-level (collapsed) data as the pivot table changes dimensions (using "offset" and "counta").
The remaining piece...
Hi and thank you in advance,
First post. I'm an average Excel user. I'm on Excel:Mac 2011 which still has no pivot charts (as far as I've heard). I've successfully created a regular chart based off the data in a pivot table (which summarizes information in a backend table). Everything works...