Quick 3D Container Chart in Excel

Поділитися
Вставка
  • Опубліковано 2 січ 2023
  • #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...

КОМЕНТАРІ • 90

  • @muhammadhashim6152
    @muhammadhashim6152 6 годин тому

    Excellent sir I like ur all videos thx sir

  • @marcosbrooksallen7868
    @marcosbrooksallen7868 4 місяці тому +1

    Thank you so much PK. Your Contributions to the Excel Community are Much Appreciated! Thanks a Lot!

  • @haggaimandona6176
    @haggaimandona6176 2 місяці тому

    PK, you are from another world. Thank you immensely for the great impact you have in the Excel Community.

  • @nsanch0181
    @nsanch0181 Рік тому +1

    PK thank you! I'm making these beautiful charts because of things you showed me on this channel. I love it. Thank you.

  • @ntwisibiha7577
    @ntwisibiha7577 Рік тому +2

    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 Місяць тому +1

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

  • @evabara9805
    @evabara9805 Рік тому +1

    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🎇

  • @sanjibpradhan2211
    @sanjibpradhan2211 Місяць тому +1

    Mind Blowing Tricks. Many Thanks.

  • @hitachikonami4339
    @hitachikonami4339 Рік тому +1

    Vous êtes toujours le meilleur au niveau du monde. Bon chance mon frère 😀😀

  • @mtotowamungu8259
    @mtotowamungu8259 Рік тому +1

    Many Thanks!
    Wish you a happy new year.

  • @Mendelyeev
    @Mendelyeev Рік тому +1

    Amazing PK! As always!!!!!!

  • @Deepak_Kumar_277
    @Deepak_Kumar_277 Рік тому +1

    Thank you sir for sharing you knowledge with us and help us to improve our excel skills. Thank you so much.

  • @anchalsingh8522
    @anchalsingh8522 2 місяці тому +1

    This was super helpful! Thank you so much

  • @cesarosorio571
    @cesarosorio571 Рік тому +3

    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  Рік тому +1

      I will try to add this in next version of this video

  • @sairam355
    @sairam355 5 місяців тому

    Excellent explanation, thank you so much for your time and patience.

  • @monicajoshi4936
    @monicajoshi4936 11 місяців тому +1

    Sooperb !! Excellent job

  • @Khalid_iyad
    @Khalid_iyad Рік тому +1

    A big thanks, you' re amazing

  • @romlef526
    @romlef526 Рік тому +2

    Hello, happy new year
    excellent exercise, fast and clean
    thanks a lot

  • @mustaphaidris
    @mustaphaidris Рік тому +1

    Thanks for the knowledge boss.

  • @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

  • @miguelprietosanchez5883
    @miguelprietosanchez5883 Рік тому +1

    Excellent my friend congratulation from Venezuela you are better

  • @imranaliti
    @imranaliti 8 місяців тому +1

    Excellent work dear. You are amazing.

  • @thilageswarancthilages619
    @thilageswarancthilages619 5 місяців тому

    Super sir🔥🔥🔥🔥🔥🔥

  • @aforvestephen354
    @aforvestephen354 6 місяців тому +1

    Thank you so much, Sir

  • @fauzansaifullah3447
    @fauzansaifullah3447 Рік тому +1

    thank you pk

  • @DataVisulizations
    @DataVisulizations Рік тому +1

    Excellent work PK

  • @viptech3491
    @viptech3491 19 днів тому +2

    Beautiful

  • @shyjumathew07
    @shyjumathew07 10 місяців тому +1

    Excellent

  • @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!

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

  • @weaagp
    @weaagp Рік тому +1

    Wow

  • @ermiasabdu4210
    @ermiasabdu4210 Рік тому +1

    Thanks pk

  • @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?

  • @Jamalhappy
    @Jamalhappy Рік тому +1

    Zabardast

  • @rashdan
    @rashdan 9 місяців тому

    Very good you oowseeem

  • @kakaciakoihouse4669
    @kakaciakoihouse4669 3 місяці тому +1

    very very very good

  • @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 7 місяців тому

    Nice work!
    What if the percentage is above 100%?

  • @uptoten4367
    @uptoten4367 9 місяців тому +1

    You're Amazing 😍. It will be amazing to meet you in person.

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 Рік тому

    Very nice sir

  • @sass1330
    @sass1330 День тому

    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 Рік тому +1

    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  Рік тому +1

      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 8 місяців тому

    Is this available in 2007?

  • @user-et9pv9gs4m
    @user-et9pv9gs4m 9 днів тому

    بارك الله فيك اخي الكريم، مانوع لوفيس؟

  • @dareoluwakemi
    @dareoluwakemi Рік тому

    PK thanks
    But I'm still waiting for the requests I made

  • @soumiamoujane3695
    @soumiamoujane3695 8 місяців тому

    Randbetween formula won't work for me.

  • @kuldeeppal3826
    @kuldeeppal3826 2 місяці тому

    It's not working if level% exceeds 100%

  • @sunghoonkim666
    @sunghoonkim666 Рік тому +1

    AWESOME BEAUTIFUL PUSHED LIKE BUTTON

  • @M.Asif66
    @M.Asif66 8 місяців тому

    Very nice effort, Please show who to design FUNNEL Bar Chart in Excel, Please share you email.