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

ความคิดเห็น • 84

  • @haggaimandona6176
    @haggaimandona6176 หลายเดือนก่อน

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

  • @marcosbrooksallen7868
    @marcosbrooksallen7868 3 หลายเดือนก่อน +1

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

  • @kathiamagdeleine4415
    @kathiamagdeleine4415 8 วันที่ผ่านมา +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!!!

  • @sanjibpradhan2211
    @sanjibpradhan2211 16 วันที่ผ่านมา +1

    Mind Blowing Tricks. Many Thanks.

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

  • @anchalsingh8522
    @anchalsingh8522 หลายเดือนก่อน +1

    This was super helpful! Thank you so much

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

  • @Mendelyeev
    @Mendelyeev ปีที่แล้ว +1

    Amazing PK! As always!!!!!!

  • @mtotowamungu8259
    @mtotowamungu8259 ปีที่แล้ว +1

    Many Thanks!
    Wish you a happy new year.

  • @monicajoshi4936
    @monicajoshi4936 10 หลายเดือนก่อน +1

    Sooperb !! Excellent job

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

  • @hitachikonami4339
    @hitachikonami4339 ปีที่แล้ว +1

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

  • @romlef526
    @romlef526 ปีที่แล้ว +2

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

  • @Khalid_iyad
    @Khalid_iyad 11 หลายเดือนก่อน +1

    A big thanks, you' re amazing

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  ปีที่แล้ว +1

      Thanks for your valuable feedback🙏

  • @mustaphaidris
    @mustaphaidris ปีที่แล้ว +1

    Thanks for the knowledge boss.

  • @sairam355
    @sairam355 4 หลายเดือนก่อน

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

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

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

  • @68111
    @68111 ปีที่แล้ว

    Wao ...very nice 👌 but sir Hindi me samjhayenge to bahut achha samajh aayega sabhi ko

  • @YogeshSharma-ui7xx
    @YogeshSharma-ui7xx 6 หลายเดือนก่อน

    Wow. Also please share time saving tips making such chart because of more time taking we ended up with simple charts

  • @imranaliti
    @imranaliti 7 หลายเดือนก่อน +1

    Excellent work dear. You are amazing.

  • @miguelprietosanchez5883
    @miguelprietosanchez5883 ปีที่แล้ว +1

    Excellent my friend congratulation from Venezuela you are better

  • @maverick19_
    @maverick19_ 2 หลายเดือนก่อน

    Thank you, how do you save this chart as an excel template if one wants to use it again?

  • @DataVisulizations
    @DataVisulizations ปีที่แล้ว +1

    Excellent work PK

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

  • @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 9 หลายเดือนก่อน

      Having same problem

  • @thilageswarancthilages619
    @thilageswarancthilages619 3 หลายเดือนก่อน

    Super sir🔥🔥🔥🔥🔥🔥

  • @aforvestephen354
    @aforvestephen354 5 หลายเดือนก่อน +1

    Thank you so much, Sir

  • @fauzansaifullah3447
    @fauzansaifullah3447 ปีที่แล้ว +1

    thank you pk

  • @Horn_of_Afrika
    @Horn_of_Afrika 6 หลายเดือนก่อน

    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

  • @kakaciakoihouse4669
    @kakaciakoihouse4669 2 หลายเดือนก่อน +1

    very very very good

  • @shyjumathew07
    @shyjumathew07 9 หลายเดือนก่อน +1

    Excellent

  • @weaagp
    @weaagp ปีที่แล้ว +1

    Wow

  • @rashdan
    @rashdan 8 หลายเดือนก่อน

    Very good you oowseeem

  • @uptoten4367
    @uptoten4367 8 หลายเดือนก่อน +1

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

  • @ermiasabdu4210
    @ermiasabdu4210 ปีที่แล้ว +1

    Thanks pk

  • @Jamalhappy
    @Jamalhappy ปีที่แล้ว +1

    Zabardast

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 ปีที่แล้ว

    Sir, pls make 1 video for
    Kanban chart pivot tables sir
    Bcoz you have not done this sir

  • @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 ปีที่แล้ว

    Very nice sir

  • @johnx2686
    @johnx2686 7 หลายเดือนก่อน

    Is this available in 2007?

  • @soumiamoujane3695
    @soumiamoujane3695 7 หลายเดือนก่อน

    Randbetween formula won't work for me.

  • @dareoluwakemi
    @dareoluwakemi ปีที่แล้ว

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

  • @kuldeeppal3826
    @kuldeeppal3826 หลายเดือนก่อน

    It's not working if level% exceeds 100%

    • @PKAnExcelExpert
      @PKAnExcelExpert  หลายเดือนก่อน

      It will work till 100% only

  • @sunghoonkim666
    @sunghoonkim666 ปีที่แล้ว +1

    AWESOME BEAUTIFUL PUSHED LIKE BUTTON

  • @M.Asif66
    @M.Asif66 6 หลายเดือนก่อน

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