Multiple Drill down chart in Excel

[@miguelprietosanchez5883]

Congratulation Friends youre the Better from Venezuela go on. Thankyou for the magic of the chart

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nx_studio]

This is one of if not the most thorough explanation of anything related to excel I've ever seen. Keep up the good work, thank you!

[@PKAnExcelExpert]

Most welcome

[@MisterJGomez]

Best tutorial ever! Thank you so much

[@PKAnExcelExpert]

Most welcome

[@atta101md]

Man you are a genius!! Thank you so much for sharing your knowledge

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lukev730]

Wonderful PK Clear explanation Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@johnpeterson8161]

Super amazing. I don't know Excel can do like this before.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bricc322]

Dear Priyendra, it is a delight to watch the smart processes you put in place. Thank you so much for all that you teach.

[@PKAnExcelExpert]

Thanks Celia, For your valuable feedback and your support to my channel. Please share this with your friends and colleagues whoever is looking for excel and vba tutorials. Thanks once again for watching

[@عبدالقادرعبدالقادر-ف7ج]

Great 👍 job dear , I love you ❤️😘💕

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@عبدالقادرعبدالقادر-ف7ج]

Now I followed, I want to learn more like this type of knowledge from your channel

[@aravindabrahmma5220]

First time I'm commenting for a video, impressed a lot and I like your uploads . Simply superb👍👍👍

[@PKAnExcelExpert]

Thanks Aravinda, for your valuable feedback.

[@nouser1230]

This video is trurly a masterpiece. I've even made a drilldown stack bar.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iskobhidekho2302]

Great... Thank you so much for this video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@2010svk]

Excellent sir👌👌👌

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tienngotk]

Thank you for your work. Look forward to watching more videos from you.

[@PKAnExcelExpert]

Thanks for watching

[@SimplyInfo9]

Simply Excellent...👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KNLP23]

Oh dearie me, this is so wonderful, thang you brother!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@suhailnbd]

Wow excellent PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iskobhidekho2302]

Great sir very helpful video its Amazing

[@PKAnExcelExpert]

So nice of you

[@zakyrizal8291]

Wow... Hebat. Saya suka... 👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alexrosen8762]

Extremely useful. Big thanks!

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@КонстантинИванов-ы9ь]

Это невероятно !!!! Спасибо)

[@harishpaldhir5915]

A very cool and good way to explain dynamic charts sir ji😁😁😁😁😁

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@AnandMishrahapy2helpu]

Wow amazing ......... Superb ..............

[@anilyerraguntla3358]

Awesome Bro. I work in planning & analysis team. It is really useful and many thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shibujoseph8498]

First class sir , awesome..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@info2dilip]

Awesome tips! You are a champ!

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@hskalsi832]

Dear PK, your ideas and your explanation is excellent. I have been benefitted a lot . I want to ask you one thing. How to use slicer when there are two or more date fields in the data table. Suppose a target date and a compliance date. Please throw some light on this too.

[@prakashchandra5239]

Really you are an expert.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@mandaracharekar]

Amazing videos... thank you

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@RavinderKumar-gl8cy]

Thank you for such a wonderful information. Please tell, if sales consists multiple columns, like sale, discount, some other column. As it allows only one column

[@snehasinghal2325]

Simply Amazing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@excelknowledge367]

excellent dear

[@PKAnExcelExpert]

Thank you! Cheers!

[@TheJaebeomPark]

Amazing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@imrandaud478]

Beautiful

[@PKAnExcelExpert]

Thanks🙏

[@robrapp]

Great tutorial. It's only problem is the 12 commercial breaks in the 15 minute video. Excessive.

[@aria4280]

Thanks for the awesome tutorial 🙏 ! Question, instead of creating a chart, how can I create a table instead? How do I modify the “sales” formula column under pivot tab to a range in creating my table instead of chart?

[@SyedMuzammilMahasanShahi]

Great work. Thanks

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@SyedMuzammilMahasanShahi]

PK: An Excel Expert u r welcome

[@behroozfarsi998]

Thank you very much for the trouble you took

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@tanababa]

Dear Priyendra, just beautiful. I have a different scenario and would appreciate your guidance/tip: I have 4 different pivot tables which I need to present as pivot charts. 1) I can show only 1 chart at a time. The numbers of rows and columns change according to slicers (this is why I cannot apply the way you show in this video). Thank you, Tamir

[@ashishgoyal4166]

Sir, my manager wants me to add quality chart also along with productivity chart. Please if you can also show that example in this same chart type. And aap kabhi formula explain nahi karte kyon? Please do that also jaise is video me aapne formula bilkul bhi explain nahi kiya hai. Aur sir aaj kal BPO industry me sirf productivity and quality ki baat hoti hai please apne videos ko usi hisaab se banaya karen. I am a big fan of your teachings

[@lazaeb]

Dear Priyendra, Thanks for your awesome knowledge. I just want to know what if i have more than 1 data. can you please share the excel

[@kamalelyaakoubi7020]

Waw top top

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shadow_gaming_sk]

excellent trick

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@mukursharma9535]

Its really amazing....but I didn't found the google drive url in below comments

[@Bhaveshwari21]

Hi excellent video, but I am facing issue while making graph and link between... can u pls guideme

[@ansumanmohanty4761]

Can we make different types of drilled down chart for a data set? For example: with your data set year wise chart will pie, then when click on one year bar chart should populate for quarter, then line chart for month like this.

[@Siva-DigitalEnglishEducation]

Dear priyendra, I used to follow ur videos. This is really good scenario, and thanks for that. I have a small doubt, what if we have different data other than year, month, quarter and date. Can we use same formula according to the data.

[@PKAnExcelExpert]

Hi Siva, Thanks for your valuable feedback. You can use any hierarchical data. This was just an example with year, qrt, month and week

[@Khunryijduy]

Popcom 🎉❤🎉 silençe you 🎉❤❤❤❤❤❤❤❤🎉

[@enesdemir2297]

Hello pryedra i like your videos thank you for videos.i want to ask a question. How can i do a graphic in userform using vba

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback. I will create the videos for graphs on user form very soon.

[@ashishgoyal4166]

पी के सर आप फॉर्मूले को भी एक्सप्लेन किया किजेजये। बहुत मुश्किल फार्मूला है इसमें

[@ManiKumar-xn9qm]

Hello this is a great tutorial and very helpful. When I can creating the same pivot on date / week with sales (last pivot in the example) it's giving me trouble, it's automatically grouping by Year, Quarter and Month and even after removing them row section of the pivot still data is not coming as date format it's coming in Month format, can anyone help me with this? WHy is it happening?

[@benjaminforsey4488]

I am getting the same problem, @PK can you help for this?

[@RavinderKumar-gl8cy]

Sir, how the same can be done in power BI

[@PKAnExcelExpert]

Yes, we can do

[@RavinderKumar-gl8cy]

@@PKAnExcelExpert Please Sir, share how it can be done.

[@RavinderKumar-gl8cy]

Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population. If I select any state from slicer , then in the table, respective district list should appear and there population. Thanks in advance.

[@muhammadarish7031]

Sir apne 4 slicer per kam kiya hai is se zada ho tu kese kam karenge

[@PKAnExcelExpert]

You can use the same method or you should use Power pivot. Please watch below given video: kzbin.info/www/bejne/hIvXZ2iirbZjrJI

[@phooirongvei8]

how to download this practical excel file

[@PKAnExcelExpert]

Download link has been given in videos description box or visit our website www.pk-anexcelexpert.com

[@jonnahnalangan3952]

How to show this in percentage?

[@thomasavinash72]

Followed step by step ( even column number same) But my "first column" formula not working it is returning 9 only No change is happening Pls help

[@arunajambunathan8431]

I tried doing this pivot. My month slicer is sorted. Its not in order but sorted A to Z

[@saurabhverma6646]

hello everyone

[@ashishgoyal4166]

Sir, In this video you have used a formula which i did not understand....First Column Last Row XVALUE Production Chart Title Can you please help me to understand.....Secondly, please create an another video about what are the basics of chart like x value, y value, Chart Area etc......plzzzzzzzzzz

[@mohamedelarapi5347]

Sir why the first coulm coming noumer 13

[@arindambhattacharya7848]

This is a drill down of the timelines only..where is the drill down for row label data?

[@vipulshankar1031]

I can not get pivot table

[@ManiKumar-xn9qm]

Its coming like this: Week (All) Years Quarters Date Sales1 2015 125486 2016 146819 2017 145633

[@sharmacreatives255]

Dear sir... how to contact you sir pls help me