Drill Down in Excel Pivot Charts - No VBA! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 5
Wayne
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!!
reply
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!!
reply
Amrish
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)
reply
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)
reply
Exploring
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.
reply
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.
reply
Jim
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. :-)
reply
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. :-)
reply
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.
reply
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.
reply
Add a review, comment
Other channel videos
