Pivot graph

%3CLINGO-SUB%20id%3D%22lingo-sub-2468757%22%20slang%3D%22en-US%22%3EPivot%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2468757%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20Pivot%20Tables%20you%20can%20easily%20click%20through%20the%20data%20to%20see%20the%20details%20of%20that%20specific%20data.%20By%20clicking%20on%20the%20%22Enable%20show%20details%22%20function%20you%20can%20turn%20this%20on%20and%20off.%20But%20is%20this%20possible%20for%20Pivot%20Charts%20as%20well%3F%20What%20I%20want%20is%20that%20I%20can%20click%20on%20a%20bar%20and%20get%20the%20details%20in%20another%20sheet%2C%20like%20this%20is%20the%20case%20with%20a%20Pivot%20Table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20I%20would%20click%20on%20week%2011%20in%20the%20picture%20below%20I%20want%20to%20see%20where%20the%2060%20is%20coming%20from%20and%20what%20the%20details%20are.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20someone%20here%20can%20help%20me%20solving%20this%20problem.%20Is%20this%20possible%20for%20a%20Pivot%20Chart%20as%20well%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vraag%20excel.PNG%22%20style%3D%22width%3A%20795px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290462i27237CA5EC773F05%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Vraag%20excel.PNG%22%20alt%3D%22Vraag%20excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2468757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Dear all, 

 

With Pivot Tables you can easily click through the data to see the details of that specific data. By clicking on the "Enable show details" function you can turn this on and off. But is this possible for Pivot Charts as well? What I want is that I can click on a bar and get the details in another sheet, like this is the case with a Pivot Table. 

 

For example, if I would click on week 11 in the picture below I want to see where the 60 is coming from and what the details are. 

 

I was wondering if someone here can help me solving this problem. Is this possible for a Pivot Chart as well?

 

Thank you in advance!

Vraag excel.PNG

0 Replies