Drill Down in Excel Pivot Charts - No VBA!

Excel Pivot Charts have handy drill down buttons that allow your user to change the level of detail shown in the chart.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

[nikosbakas]

thanks to you, small daily improvements add up to huge long term benefits! well done and keep it up!

[udaracperera]

Thanks for the new video. small things which I miss all the time and spend a lot of time when I need it

[IvanCortinas_ES]

Cool! Widely used in PivotTables and very little used in PivotCharts. Thanks for the the explanation Mynda.

very useful, didn't see/notice this option. thanks for showing it Minda.

[aks]

How to make the title for each drill down chart change according to each drill down or up..

[jimfitch]

Thanks, Mynda. I have always turned off all buttons out of habit. Never considered the drilling feature. I need to be more thoughtful about that. Nice tip at the end about the training requirement. :-)

[zuhairalmutawa]

Very useful keep up the good work, Thank you.

[munrooak]

Brilliant again! Always learn something new, can't wait for the next installment :)

[EduardKorkia]

You are brilliant! Thank you very mutch!

[johnborg]

Thanks Myndy. That was of great help. : ) : )

[darrylmorgan]

Hi Mynda!Some Really Interesting Tips..Thank You :)

[wayneedmondson]

Hi Mynda.. great stuff.. lots of good tips in this video. I've always just hidden all Field Buttons as a matter of routine when designing a Pivot Chart. Thanks for showing me what I've been missing. FYI, the Excel file download data does not match the data in the video. Not a problem.. just mentioning. Thanks again for all the good fun and learning at MyOnlineTraingHub. Thumbs up!!

[marybellandry]

Hi Mynda! Is there a way to disable the pivot chart from being highlighted or is it just making the file "read only"...I want viewers to drill up/down but without having to click out of the pivot chart to make the chart from being selected/moved. Thanks!

[TEKNISHA]

Great video again as usual. I love the way you are always on point...

Btw I am also passionate about excel and do have my own YouTube channel where I do try to make some videos that hopefully will help people..

Cheers

[lgent]

Which course in www.myonlinetraininghub.com I should take for trick like this one?
I have difficulty for presenting P&L pivottable to waterfall chart and can be drill down like this.

is there any way, i can turn the text on the Y Axis by 90 Degrees (anti clock / clock wise) ? on the Y Axis.
here, Particularly i am want to turn the "Category " by 90 Degrees in the clockwise direction. (so that we can read it better)

[exploring_thailand]

I'm attempting to create a similar chart. The dates and names of the axis items are displaying inside the table, on top of the bars, instead of underneath the table as in your example. It makes it impossible to read.

[arindambhattacharya]

This is just for “values”. Where is drill down at row level?

[ishaq]

How about make quick / tips video for Tiktok. This will help a lot for who using tiktok more than YouTube.