Quick 3D Container Chart in Excel

  Рет қаралды 90,019

PK: An Excel Expert

PK: An Excel Expert

Жыл бұрын

#3DChart #ExcelChart
Hello Friends,
In this video, you will learn how to create a beautiful 3D container chart in Microsoft Excel. We have used a 3D Stacked column chart to create this chart. You can use this chart to show the KPI metrics like - Service Level, Quality score, Gross Margin, etc.
We have created 2 versions here
1: Cylinder version:
2: Box version
Download the practice file from the below link:
www.pk-anexcelexpert.com/quic...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

Пікірлер: 93
@haggaimandona6176
@haggaimandona6176 3 ай бұрын
PK, you are from another world. Thank you immensely for the great impact you have in the Excel Community.
@marcosbrooksallen7868
@marcosbrooksallen7868 5 ай бұрын
Thank you so much PK. Your Contributions to the Excel Community are Much Appreciated! Thanks a Lot!
@PKAnExcelExpert
@PKAnExcelExpert 5 ай бұрын
Most welcome
@nsanch0181
@nsanch0181 Жыл бұрын
PK thank you! I'm making these beautiful charts because of things you showed me on this channel. I love it. Thank you.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Glad you like them!
@aalapvora6853
@aalapvora6853 4 күн бұрын
Excellent video 🎉
@PKAnExcelExpert
@PKAnExcelExpert 4 күн бұрын
Thanks
@kathiamagdeleine4415
@kathiamagdeleine4415 2 ай бұрын
PK you are the best at these graphs!!!! I love creativity and have been following you to learn of new graph styles to design. Thank you so very much!!!
@PKAnExcelExpert
@PKAnExcelExpert 2 ай бұрын
Most welcome
@ntwisibiha7577
@ntwisibiha7577 Жыл бұрын
Thanks. You are a life saver. After several weeks of trying different videos I just succeeded with your videos. 👌
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
So glad to hear that my video helped you succeed! Your feedback truly means a lot. Keep learning and stay tuned for more! Thanks for your support.
@evabara9805
@evabara9805 Жыл бұрын
Thank you PK. Wish you a very Happy New Year 2023. Really appreciate what you do, all the knowledge you share, It is invaluable beyond words.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback. Happy New Year🎇
@Deepak_Kumar_277
@Deepak_Kumar_277 Жыл бұрын
Thank you sir for sharing you knowledge with us and help us to improve our excel skills. Thank you so much.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@hitachikonami4339
@hitachikonami4339 Жыл бұрын
Vous êtes toujours le meilleur au niveau du monde. Bon chance mon frère 😀😀
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Merci pour vos précieux commentaires
@mtotowamungu8259
@mtotowamungu8259 Жыл бұрын
Many Thanks! Wish you a happy new year.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Same to you🙏
@sairam355
@sairam355 6 ай бұрын
Excellent explanation, thank you so much for your time and patience.
@PKAnExcelExpert
@PKAnExcelExpert 6 ай бұрын
Most welcome
@sanjibpradhan2211
@sanjibpradhan2211 2 ай бұрын
Mind Blowing Tricks. Many Thanks.
@PKAnExcelExpert
@PKAnExcelExpert 2 ай бұрын
Most welcome
@Mendelyeev
@Mendelyeev Жыл бұрын
Amazing PK! As always!!!!!!
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@cesarosorio571
@cesarosorio571 Жыл бұрын
Wow really amazing!!! Thank you very much for the excellent video and for sharing your knowledge of excel and graphic design. If it's not too much trouble, I'd love to know how to make a similar graph, but using absolute numbers instead of percentages.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
I will try to add this in next version of this video
@romlef526
@romlef526 Жыл бұрын
Hello, happy new year excellent exercise, fast and clean thanks a lot
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Happy new year!
@Khalid_iyad
@Khalid_iyad Жыл бұрын
A big thanks, you' re amazing
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
You're welcome!
@anchalsingh8522
@anchalsingh8522 3 ай бұрын
This was super helpful! Thank you so much
@PKAnExcelExpert
@PKAnExcelExpert 3 ай бұрын
Glad it was helpful!
@monicajoshi4936
@monicajoshi4936 Жыл бұрын
Sooperb !! Excellent job
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks🙏
@mustaphaidris
@mustaphaidris Жыл бұрын
Thanks for the knowledge boss.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome
@miguelprietosanchez5883
@miguelprietosanchez5883 Жыл бұрын
Excellent my friend congratulation from Venezuela you are better
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Wow, thank you
@imranaliti
@imranaliti 9 ай бұрын
Excellent work dear. You are amazing.
@PKAnExcelExpert
@PKAnExcelExpert 9 ай бұрын
Thanks
@YogeshSharma-ui7xx
@YogeshSharma-ui7xx 8 ай бұрын
Wow. Also please share time saving tips making such chart because of more time taking we ended up with simple charts
@VisuLytics
@VisuLytics Жыл бұрын
Excellent work PK
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thank you so much 😀
@fauzansaifullah3447
@fauzansaifullah3447 Жыл бұрын
thank you pk
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome🙏
@thilageswarancthilages619
@thilageswarancthilages619 6 ай бұрын
Super sir🔥🔥🔥🔥🔥🔥
@muhammadhashim6152
@muhammadhashim6152 Ай бұрын
Excellent sir I like ur all videos thx sir
@PKAnExcelExpert
@PKAnExcelExpert Ай бұрын
So nice of you
@harlebelah
@harlebelah Жыл бұрын
Thanks for sharing this! I am quite excited to present this at work. I am using the charts to show what's left in the budgeted hours as a percentage. There is a chance however that an activity may go over the budget - hence will result in negative percentage usage - may I kindly ask for your suggestion what is the best way to present this? Thank you!
@anilbhusal3277
@anilbhusal3277 Жыл бұрын
Having same problem
@aforvestephen354
@aforvestephen354 7 ай бұрын
Thank you so much, Sir
@PKAnExcelExpert
@PKAnExcelExpert 7 ай бұрын
Most welcome
@shyjumathew07
@shyjumathew07 11 ай бұрын
Excellent
@PKAnExcelExpert
@PKAnExcelExpert 11 ай бұрын
Thanks🙏
@kimyenchu
@kimyenchu Жыл бұрын
Hello, do you know to auto enter a value in a cell in an excel table so it is not blank? Eg. I have excel table with Comments column. Some cells will have comments and others won't. Instead of blank, I would like to put dashes when I add a new row, so they are not blank. Atm, I leave them blank as I do not use them in pivot table, but I read Excel tables should not have blank cells.
@viptech3491
@viptech3491 Ай бұрын
Beautiful
@PKAnExcelExpert
@PKAnExcelExpert Ай бұрын
Thanks
@maverick19_
@maverick19_ 4 ай бұрын
Thank you, how do you save this chart as an excel template if one wants to use it again?
@68111
@68111 Жыл бұрын
Wao ...very nice 👌 but sir Hindi me samjhayenge to bahut achha samajh aayega sabhi ko
@ermiasabdu4210
@ermiasabdu4210 Жыл бұрын
Thanks pk
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome🙏
@weaagp
@weaagp Жыл бұрын
Wow
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks
@Jamalhappy
@Jamalhappy Жыл бұрын
Zabardast
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks🙏
@uptoten4367
@uptoten4367 10 ай бұрын
You're Amazing 😍. It will be amazing to meet you in person.
@PKAnExcelExpert
@PKAnExcelExpert 10 ай бұрын
Thanks
@kakaciakoihouse4669
@kakaciakoihouse4669 4 ай бұрын
very very very good
@PKAnExcelExpert
@PKAnExcelExpert 4 ай бұрын
Thanks
@rashdan
@rashdan 10 ай бұрын
Very good you oowseeem
@johnsundayabidemi8670
@johnsundayabidemi8670 Жыл бұрын
Pk thank you for all your videos BUT PLEASE PROVIDE EMAIL OR ANY OTHER MEANS TO COMMUNICATE WITH YOU IF THERE IS ERROR WHEN WE ARE TRYING TO DO WHAT YOU TEACH US
@Horn_of_Afrika
@Horn_of_Afrika 8 ай бұрын
Nice work! What if the percentage is above 100%?
@amarkate6172
@amarkate6172 Жыл бұрын
I have also made a similar one. would like to share it with you but here not have the option of an attachment
@sass1330
@sass1330 Ай бұрын
Can thid be connected to a slicer?
@pandharinathjoshi6565
@pandharinathjoshi6565 Жыл бұрын
Very nice sir
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks a lot. Happy New Year🎇
@pandharinathjoshi6565
@pandharinathjoshi6565 Жыл бұрын
Thanku sir, Wish you Happy New year sir
@baselr3908
@baselr3908 Жыл бұрын
Thank you, you are great. I have done all what you did. but my problem is my data are numbers not percentage, how I can solve this issue
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your feedback! For handling numerical data instead of percentages, I'll create a separate video to address this. Stay tuned!
@baselr3908
@baselr3908 Жыл бұрын
@@PKAnExcelExpert I hope to get feedback soon ❤️
@pandharinathjoshi6565
@pandharinathjoshi6565 Жыл бұрын
Sir, pls make 1 video for Kanban chart pivot tables sir Bcoz you have not done this sir
@johnx2686
@johnx2686 9 ай бұрын
Is this available in 2007?
@user-et9pv9gs4m
@user-et9pv9gs4m Ай бұрын
بارك الله فيك اخي الكريم، مانوع لوفيس؟
@PKAnExcelExpert
@PKAnExcelExpert Ай бұрын
Thanks
@sunghoonkim666
@sunghoonkim666 Жыл бұрын
AWESOME BEAUTIFUL PUSHED LIKE BUTTON
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks
@soumiamoujane3695
@soumiamoujane3695 9 ай бұрын
Randbetween formula won't work for me.
@dareoluwakemi
@dareoluwakemi Жыл бұрын
PK thanks But I'm still waiting for the requests I made
@kuldeeppal3826
@kuldeeppal3826 3 ай бұрын
It's not working if level% exceeds 100%
@PKAnExcelExpert
@PKAnExcelExpert 3 ай бұрын
It will work till 100% only
@M.Asif66
@M.Asif66 9 ай бұрын
Very nice effort, Please show who to design FUNNEL Bar Chart in Excel, Please share you email.
Quick Male/Female Ratio and Waffle Chart in Excel
13:37
PK: An Excel Expert
Рет қаралды 15 М.
How to WOW Your Boss: 3D Progress Circle in Excel 🚀
6:26
PK: An Excel Expert
Рет қаралды 15 М.
Llegó al techo 😱
00:37
Juan De Dios Pantoja
Рет қаралды 60 МЛН
IQ Level: 10000
00:10
Younes Zarou
Рет қаралды 12 МЛН
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 396 М.
2D Bar Chart in Excel
15:03
Tech Solutions
Рет қаралды 2,2 М.
Doughnut Pie Chart in Excel - Infographic
19:11
Haider Niaz
Рет қаралды 263 М.
Info-graphics: 3D Glass Chart in Excel
10:15
PK: An Excel Expert
Рет қаралды 232 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 285 М.
Info-graphics: 3D Gauge Chart in Excel
15:41
PK: An Excel Expert
Рет қаралды 52 М.
Build 5 ADVANCED Excel Charts from Scratch
14:14
Kenji Explains
Рет қаралды 210 М.
How to Create an Interactive Excel Dashboard in Just 12 Minutes
12:01
iDATA Analytics Hub
Рет қаралды 632 М.