Home

We can't drill down here / Pivot Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-286707%22%20slang%3D%22en-US%22%3EWe%20can't%20drill%20down%20here%20%2F%20Pivot%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20developed%20a%20dash%20board%20with%207%20PivotCharts%20(pie%20and%20column%20charts).%26nbsp%3B%20I%20would%20like%20users%20to%20be%20able%20to%20double%26nbsp%3Bclick%20a%20chart%20element%20and%20see%20the%20details%20for%20the%20underlying%20value%20field%20in%20the%20associated%20PivotTable.%26nbsp%3B%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-286707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-567912%22%20slang%3D%22en-US%22%3ERe%3A%20We%20can't%20drill%20down%20here%20%2F%20Pivot%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-567912%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20facing%20the%20same%20problem%20for%20Excel%20Online.%20I%20have%20checked%20and%20found%20out%20there%20is%20no%20drill%20down%20function%20in%20Excel%20Online%20by%20double-checking%20the%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20alternative%20way%20to%20solve%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Glen Christopher
Occasional Visitor

I have developed a dash board with 7 PivotCharts (pie and column charts).  I would like users to be able to double click a chart element and see the details for the underlying value field in the associated PivotTable.  Is this possible?

1 Reply

I am facing the same problem for Excel Online. I have checked and found out there is no drill down function in Excel Online by double-checking the data. 

 

Is there any alternative way to solve this problem?

Related Conversations