Quick 3D Container Chart in Excel

  Рет қаралды 84,589

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...

Пікірлер: 89
@marcosbrooksallen7868
@marcosbrooksallen7868 4 ай бұрын
Thank you so much PK. Your Contributions to the Excel Community are Much Appreciated! Thanks a Lot!
@PKAnExcelExpert
@PKAnExcelExpert 4 ай бұрын
Most welcome
@haggaimandona6176
@haggaimandona6176 2 ай бұрын
PK, you are from another world. Thank you immensely for the great impact you have in the Excel Community.
@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!
@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.
@kathiamagdeleine4415
@kathiamagdeleine4415 Ай бұрын
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 Ай бұрын
Most welcome
@sanjibpradhan2211
@sanjibpradhan2211 Ай бұрын
Mind Blowing Tricks. Many Thanks.
@PKAnExcelExpert
@PKAnExcelExpert Ай бұрын
Most welcome
@mtotowamungu8259
@mtotowamungu8259 Жыл бұрын
Many Thanks! Wish you a happy new year.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Same to you🙏
@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
@anchalsingh8522
@anchalsingh8522 2 ай бұрын
This was super helpful! Thank you so much
@PKAnExcelExpert
@PKAnExcelExpert 2 ай бұрын
Glad it was helpful!
@sairam355
@sairam355 5 ай бұрын
Excellent explanation, thank you so much for your time and patience.
@PKAnExcelExpert
@PKAnExcelExpert 5 ай бұрын
Most welcome
@Khalid_iyad
@Khalid_iyad Жыл бұрын
A big thanks, you' re amazing
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
You're welcome!
@romlef526
@romlef526 Жыл бұрын
Hello, happy new year excellent exercise, fast and clean thanks a lot
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Happy new year!
@Mendelyeev
@Mendelyeev Жыл бұрын
Amazing PK! As always!!!!!!
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@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
@monicajoshi4936
@monicajoshi4936 11 ай бұрын
Sooperb !! Excellent job
@PKAnExcelExpert
@PKAnExcelExpert 11 ай бұрын
Thanks🙏
@imranaliti
@imranaliti 8 ай бұрын
Excellent work dear. You are amazing.
@PKAnExcelExpert
@PKAnExcelExpert 8 ай бұрын
Thanks
@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
@YogeshSharma-ui7xx
@YogeshSharma-ui7xx 7 ай бұрын
Wow. Also please share time saving tips making such chart because of more time taking we ended up with simple charts
@aforvestephen354
@aforvestephen354 6 ай бұрын
Thank you so much, Sir
@PKAnExcelExpert
@PKAnExcelExpert 6 ай бұрын
Most welcome
@fauzansaifullah3447
@fauzansaifullah3447 Жыл бұрын
thank you pk
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome🙏
@DataVisulizations
@DataVisulizations Жыл бұрын
Excellent work PK
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thank you so much 😀
@thilageswarancthilages619
@thilageswarancthilages619 5 ай бұрын
Super sir🔥🔥🔥🔥🔥🔥
@viptech3491
@viptech3491 18 күн бұрын
Beautiful
@PKAnExcelExpert
@PKAnExcelExpert 18 күн бұрын
Thanks
@shyjumathew07
@shyjumathew07 10 ай бұрын
Excellent
@PKAnExcelExpert
@PKAnExcelExpert 10 ай бұрын
Thanks🙏
@ermiasabdu4210
@ermiasabdu4210 Жыл бұрын
Thanks pk
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome🙏
@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 11 ай бұрын
Having same problem
@weaagp
@weaagp Жыл бұрын
Wow
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks
@68111
@68111 Жыл бұрын
Wao ...very nice 👌 but sir Hindi me samjhayenge to bahut achha samajh aayega sabhi ko
@maverick19_
@maverick19_ 3 ай бұрын
Thank you, how do you save this chart as an excel template if one wants to use it again?
@kakaciakoihouse4669
@kakaciakoihouse4669 3 ай бұрын
very very very good
@PKAnExcelExpert
@PKAnExcelExpert 3 ай бұрын
Thanks
@rashdan
@rashdan 9 ай бұрын
Very good you oowseeem
@Jamalhappy
@Jamalhappy Жыл бұрын
Zabardast
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks🙏
@Horn_of_Afrika
@Horn_of_Afrika 7 ай бұрын
Nice work! What if the percentage is above 100%?
@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.
@uptoten4367
@uptoten4367 9 ай бұрын
You're Amazing 😍. It will be amazing to meet you in person.
@PKAnExcelExpert
@PKAnExcelExpert 9 ай бұрын
Thanks
@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
@pandharinathjoshi6565
@pandharinathjoshi6565 Жыл бұрын
Very nice sir
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks a lot. Happy New Year🎇
@pandharinathjoshi6565
@pandharinathjoshi6565 Жыл бұрын
Thanku sir, Wish you Happy New year sir
@sass1330
@sass1330 4 сағат бұрын
Can thid be connected to a slicer?
@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
@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
@sunghoonkim666
@sunghoonkim666 Жыл бұрын
AWESOME BEAUTIFUL PUSHED LIKE BUTTON
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks
@johnx2686
@johnx2686 8 ай бұрын
Is this available in 2007?
@user-et9pv9gs4m
@user-et9pv9gs4m 8 күн бұрын
بارك الله فيك اخي الكريم، مانوع لوفيس؟
@PKAnExcelExpert
@PKAnExcelExpert 7 күн бұрын
Thanks
@soumiamoujane3695
@soumiamoujane3695 8 ай бұрын
Randbetween formula won't work for me.
@dareoluwakemi
@dareoluwakemi Жыл бұрын
PK thanks But I'm still waiting for the requests I made
@kuldeeppal3826
@kuldeeppal3826 2 ай бұрын
It's not working if level% exceeds 100%
@PKAnExcelExpert
@PKAnExcelExpert 2 ай бұрын
It will work till 100% only
@M.Asif66
@M.Asif66 7 ай бұрын
Very nice effort, Please show who to design FUNNEL Bar Chart in Excel, Please share you email.
Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
11:58
PK: An Excel Expert
Рет қаралды 20 М.
Info-graphics: Group of Circle Charts in Excel
15:55
PK: An Excel Expert
Рет қаралды 124 М.
БОЛЬШОЙ ПЕТУШОК #shorts
00:21
Паша Осадчий
Рет қаралды 8 МЛН
Always be more smart #shorts
00:32
Jin and Hattie
Рет қаралды 45 МЛН
Info-graphics: 3D Glass Chart in Excel
10:15
PK: An Excel Expert
Рет қаралды 232 М.
Build 5 ADVANCED Excel Charts from Scratch
14:14
Kenji Explains
Рет қаралды 203 М.
Interactive 2D Bar Chart in Excel
12:09
Tech Solutions
Рет қаралды 729
Doughnut Pie Chart in Excel - Infographic
19:11
Haider Niaz
Рет қаралды 255 М.
100+ Linux Things you Need to Know
12:23
Fireship
Рет қаралды 143 М.
Info-graphics: 3D Gauge Chart in Excel
15:41
PK: An Excel Expert
Рет қаралды 51 М.
Quick Male/Female Ratio and Waffle Chart in Excel
13:37
PK: An Excel Expert
Рет қаралды 14 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 269 М.