Multiple Pivot Tables and Pivot Chart with very Simple Macro
ฝัง
- เผยแพร่เมื่อ 6 ก.พ. 2025
- Pivot Tables are very popular among Excel users! In this tutorial I show you how to create multiple Pivot Tables & Pivot Charts then switch between them by using a very simple Macro. You will then be using Excel in an impressive presentation style.
You can download the start file and follow along by clicking on the link:
www.amazon.ca/...
Remember, after creating macros you cannot save the Excel file in a .XLSX format, you need to save it as a Macro enabled Excel file with .XLSM format
I invite you to watch my new Tutorial on creating a Dynamic Calendar for Any Month in Any Year, just click here:
• Create a Dynamic Calen...
This work & automation is unbelievable!! hats off Nabil Sir. Love from India
Nabil Sir ... I couldn't believe my eyes that I could do it after watching your video step by step ... of course I made mistake and I cleared the macro and did once again ... thank you so much
Very nice. Explained in lucid way
Excellent tutorial my friend.Thank you so much
Nabil, thank you so much for the help but I would like to know how to make that macro but using a button in a another worksheet.
Excellent Tutorial Sir! Great Effort. Thank you very much.
Nice one
Thank you
Great efforts as usual. Thanks.
Thank you for the continuous encouragement
متشكر جدا
Very impressed by your high quality presentation. No stumbling over what to say, clear and concise steps and several excel tricks rolled together. You have a new subscriber for your efforts!
What a nice comment... Subscribe to my blogsite to receive a Free copy of my text book"Pivot Tables from Zero to Hero"
Very good tutorials every time! Thank you so much!
Thank you... Glad you liked it
Very good presentation
Thank You
Cool Video
Thank You Dr. Murad
You are welcome my friend
An excellent tutorial.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟 🌟
Thank you Salim
Great, Useful and helpful.
A wonderful..Empty cells cause a problem in the Pivot Table and appear in print that I want to cancel or not show
My smiley is not in color when I added the same to the QAT ... any specific reason !!!!
In mine it is showing subscription out of the range
mazing
Nabil , that’s amazing , could you please create food cost calculator , showing margin and cost % with a pie chart . That’s will be helpful.
Thanks Samy.
That's a good idea by the way which could lead us to much more topics. I kindly ask you to send me detailed raw data and requirements to think how I can build a project out of it. Check my company website for my contact information.
Officeinstructor appreciate the fast reply,i dont have any raw data in hands, but can be a simple example for food recipes, like tabouleh
With drop down list for kg, grams exc.
And to make it more attractive we will add reset button, tank you much and keep up the great lovely lessons .
Samy
Good morning Nabil sir I am big fan of you.But my concern is try to publish your excel videos at least one video for a week sir.I am very much anxiously waiting Nabil sir.
Thank You Venu Gopal for being a loyal fan... I will do my best to post more frequently... Stay Tuned.
Nabil Mourad
Hi thanks. Awesome
Thank you
Officeinstructor . Thanks. Looking for a simple way to drill down data in a dashboard worksheet based on 3 worksheets customers, invoices and payments. Kind of relationships in Excel
Very easy to do in Power Pivot
Great tutorial. I got so much out of it!
Do you have any idea why I get error's for my Macros if i use any kind of Pivot Table in them? I've followed every step you showed in this video but when running the macro I've just recorded I get error '424' or '5' and the Pivot Table doesn't look right.
How to creat buttons in sheet with this pivot table
I created that in other videos
uhhhgggg.. the video was great but you didn't show me how to record the pivot chart :( my recording does not work :(
Select any cell in the Pivot Table and hit Alt + F1
100000 likes
100,000,000 Thank You :)