Expanding/Collapsing Pivot Chart to detailed view

[srm057]

Hi folks,

Is there any way I can expand/collapse Pivot chart like we do with pivot table button in Excel 2010.

Let me explain. I have 2 column Cities and Neighborhood.
In the pivot chart, it is showing me the the count of neighborhoods in each city. i want users to click on any specific city to see the expanded view with all neighborhoods in that city.


Is there any way??

regards