Pivot chart: we can't drill down here

[excelsql987]

Hi
I am trying to hover over the chart to drill down to details but each time I get the message:we can't drill down here?
Anybody knows why and how to fix this ?
thanks

[Richard Buttrey]

It would be easier to comment if we could see the file, but off the top of my head I guess you're double clicking in the rows or columns area of the PT.

If by 'drill down' you mean extract the underlying details for the field you're clicking then it needs to be in the 'Values' area of the PT Field List

[excelsql987]

I know how to drill down details in a pivot table but my problem is with Pivot chart.
There are very little comments or solution for Pivot CHARTS

[Richard Buttrey]

Still not quite sure what you mean by 'drill down'. I know what I mean but terminology often means slightly different things to different people.

Does this Microsoft article help

https://www.microsoft.com/en-us/micr...d-pivotcharts/

[excelsql987]

I read the article and familiar with quick explorer but I think I need to find a vba code to resolve that (not sure how)
so far I found this article https://www.dropbox.com/s/c4x44jj6sv...ldown.pdf?dl=0
but it is still not working.