Pivot Chart behaviour

[Target]

apologies if this has been asked/answered before, I did a search but I'm not sure if I'm asking the question correctly

I have a really simple pivot chart I'm doing up for my boss, the trick part is that he wants drill down capability. I've worked out a solution to that, but I want to be able to include some pivot table functionality in the chart, specifically the expand/collapse function

Row Labels are Customer|contract, and the initial view should be at customer level (ie collapsed). I would like to be able to click (?) on the customer to expand to contract level for that customer but I don't quite know how to go about it (or if its even possible).

I could leave the pivot exposed, but that kind of defeats the purpose

Any suggestions?

TIA

Target

 

[Chihiro]

Usually, just adding Customer to Row Label and then adding contract below Customer in Row Label will give grouping of contract by Customer.

It may be that you have +/- buttons turned off.

See attached simple example.

Edit: Woops, forgot to save after adding chart. And yes, to below it's native behaviour.

 

[Target]

actually, now that I take my code out, it looks like that's the native behaviour of the chart... hrmmmmm

 

[Target]

why is it the answer always comes to you after you asked the forum...

answer (for me) was to manipulate the underlying pivot table rather than try and do it all on with the chart. Added a button the expand/collapse the pivot, and some code to filter the source data according to the chart element being clicked on...