Info-graphics: 3D Glass Chart in Excel

Поделиться
HTML-код
  • Опубликовано: 14 июл 2024
  • #ExcelInfoGraphics #KPIChart
    Hello Friends,
    In this video you will learn how to create a beautiful 3D Glass Chart in Microsoft Excel.
    Please download this Excel file below given link
    www.pk-anexcelexpert.com/3d-g...
    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
    ************ Suggested Books ********
    VBA: amzn.to/2TMMikX
    Excel Dashboard: amzn.to/2WZi2Fj
    Power Query: amzn.to/2Ibd7xR
    Power Pivot and Power BI: amzn.to/2DCg8BB
    Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
    ************ My Stuff ***************
    Mic : amzn.to/2TLnF88
    Video Editor: screencast-o-matic.com/refer/...

Комментарии • 202

  • @abcontrast2340
    @abcontrast2340 3 года назад +3

    I watched this 5x.. fought through the frustration of my low training and lower skillsets. THEN I saw your brilliance! Thanks!

  • @jhj8530
    @jhj8530 3 года назад +2

    Hello PK, my name is João and I live in a small town in Brasil, the name of the town is Itu and it's about 100km from São Paulo. In my work I make Excel charts and l just did your 3D Glass chart step by step watching your RUclips video. I would like to thank you, because this kind of charts make my work better and get some recognition from my supervisors. Thank you again my friend, you are amazing.

  • @MsAmyTee
    @MsAmyTee 4 года назад +5

    I've watch multiple videos from you, you are seriously an EXCEL CHART GOD! Thank you so much for your videos. Super educational and thoroughly have enjoyed .learning how to create these amazing charts you have.

  • @StefanoLandi
    @StefanoLandi 2 года назад +1

    Amazing 3D effect and simply done, thank-you!

  • @paulocezardesouzasouza2044
    @paulocezardesouzasouza2044 4 года назад +1

    I am from Brazil. Cuiabá. I enjoyed that, vey much. Fantastic. Thanks

  • @pedromartinez1165
    @pedromartinez1165 2 года назад +2

    Your videos are like chocolate, sweet and can't get enough of it.
    Awesome job - thank you !

  • @varher76
    @varher76 5 лет назад

    MUCHAS GRACIAS. SALUDOS DESDE ECUADOR -AMERICA

  • @enginyildiz6524
    @enginyildiz6524 5 лет назад +1

    Muhteşemdi. Teşekkür ederiz.
    Türkiye’den takipçiniz.

  • @siddharthanandy3798
    @siddharthanandy3798 Год назад +1

    Brilliant works and generous to share with everyone! Thank you.

  • @andrytianarabezanahary1083
    @andrytianarabezanahary1083 3 года назад +1

    helpful. Thanks for your teaching. You really deserve your EXPERT title...

  • @judicaelb6212
    @judicaelb6212 4 года назад +1

    Merci pour les vidéos très complètes ! :-)

  • @soumiaould5723
    @soumiaould5723 3 года назад +1

    I am so grateful to you, for you shared so very knowledge of yours with us.

  • @nsanch0181
    @nsanch0181 3 года назад +1

    Beautiful chart. Thank you PK.

  • @SimpleB2k4
    @SimpleB2k4 5 лет назад +2

    Thanks PK. Great tutorial

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 лет назад

      Thanks for your valuable feedback. Please share it with your friends.

  • @hemantjoshi5034
    @hemantjoshi5034 5 лет назад +2

    Thanks a ton ! This is very helpful !!

  • @humbertochavarria7589
    @humbertochavarria7589 3 года назад

    Great tutorial. Well explained

  • @jmyt5763
    @jmyt5763 4 года назад

    Nice , It is clear , easy , to the point

  • @Conradfvs
    @Conradfvs 2 года назад

    Really fantastic , thank you 🙏.

  • @dedeoliveira82
    @dedeoliveira82 5 лет назад +2

    hello @PK! I'm from Brasil.
    very good. great idea. Thank you

  • @othmanashara9382
    @othmanashara9382 2 года назад +1

    you are a creative in this field. thank you

  • @noorm516
    @noorm516 2 года назад +2

    Amazing. Thank you very much for the explanation. I have been able to do it and it looks wonderful

  • @rickcampbell6987
    @rickcampbell6987 5 лет назад +2

    Glas I found this! Will give an extra "something" to Excel bar charts I produce herein the lab.

  • @michaeldegregorio5472
    @michaeldegregorio5472 2 года назад +1

    Awesome ideas. Your a true excel artist!

  • @isaiasfranciscodasilva644
    @isaiasfranciscodasilva644 4 года назад +2

    Congratulations, one more class show, continue like this my friend and thank you very much for being in your thoughts with people who are interested and learn.
    Sorry for the English translation by mister Google.

  • @edisoncalixtosilva4610
    @edisoncalixtosilva4610 4 года назад +1

    Just amazing... Thank You so much....

  • @asifmahmoodliaquat5866
    @asifmahmoodliaquat5866 2 года назад +1

    very well demonstrated. thanks for sharing

  • @khabatalikarim7146
    @khabatalikarim7146 4 года назад +1

    Thanks!! That is amazing!

  • @xOneLove27x
    @xOneLove27x 4 года назад +1

    Thank you... so easy to follow

  • @moresopho7723
    @moresopho7723 5 лет назад +1

    This is gold!

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 лет назад

      Thanks for your appreciation. Request you to please share this with your friends and colleagues.

  • @ajay000003
    @ajay000003 3 года назад +1

    Thanks a lot for sharing this video.

  • @BoxerDogs
    @BoxerDogs 4 года назад +1

    Wow. This is amazing. Very very nice.

  • @ajitpal3016
    @ajitpal3016 5 лет назад

    Excellent chart sir

  • @ashokgautam7438
    @ashokgautam7438 5 лет назад +1

    Awesome, nicely explained

  • @thanhdongctm6
    @thanhdongctm6 2 года назад +1

    Awsome thanks for the tutorial, one again, thanks you so much

  • @carolmonteiro7790
    @carolmonteiro7790 4 года назад +1

    Excellent!

  • @JWMV1
    @JWMV1 4 года назад +1

    You are the best!!

  • @vsdteams9241
    @vsdteams9241 4 года назад +1

    thanks from From, very easy, and usefull

  • @ravichauhan3933
    @ravichauhan3933 Год назад +1

    tusi Great ho bro

  • @aswinidutt7199
    @aswinidutt7199 5 лет назад +1

    Excellent work.

  • @olaupea7665
    @olaupea7665 Год назад +1

    Excelente trabajo saludos

  • @ndakazajeannapoleon6486
    @ndakazajeannapoleon6486 4 года назад +1

    Thank you it is really awesome

  • @SureshHellsfire
    @SureshHellsfire 5 лет назад +1

    WoW 😲.. Thanks a lot

  • @CyberSERT
    @CyberSERT 5 лет назад +1

    WOW!

  • @SaqibKhan-hq9wp
    @SaqibKhan-hq9wp 5 лет назад +1

    great ...very beautiful charts sir ...

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 года назад +1

    No word to Thanks for you good knowledge ... make different chart designs also sir. Its very nice to see your videos and most like full your explanation is too high sir 👍👍👍👍👍💐💐💐

  • @Chef-1707
    @Chef-1707 3 года назад +2

    That is genius and we learn sooooo much from you. Appreciate your generosity of sharing your knowledge with us.

  • @sangeeth201
    @sangeeth201 2 года назад +1

    Thank you Bro myself learn new think today once again thank you so much

  • @thinkexcel9976
    @thinkexcel9976 5 лет назад +1

    Great Video!!

  • @nguyenTran-ju7lp
    @nguyenTran-ju7lp 3 года назад +1

    Wowowow Wowowow amazing

  • @Go4Truth
    @Go4Truth 5 лет назад +1

    good nice and attractive chart

  • @info2satish
    @info2satish 5 лет назад +1

    Amazing PK!!

  • @fhatuwanimakungo24
    @fhatuwanimakungo24 5 лет назад +1

    thanks Very helpful

  • @muthuraja6589
    @muthuraja6589 5 лет назад +1

    Excellent sir...👌👌👌👌

  • @angadsingh9318
    @angadsingh9318 5 лет назад +1

    You are awesome sir👌👌👌👌🙏🙏🙏

  • @elakkiyaful
    @elakkiyaful 3 года назад

    Sir; yours videos are outstanding

  • @4511raj
    @4511raj 5 лет назад +1

    You are next level bro

  • @PettakaTechnologies
    @PettakaTechnologies 4 года назад

    Nice explanation

  • @diegoenriquez8995
    @diegoenriquez8995 5 лет назад +1

    You are amaizing i am from mexico and i sing your chanel

  • @mdroman3017
    @mdroman3017 4 года назад

    Thank you boss

  • @hannielizdeluna8933
    @hannielizdeluna8933 3 года назад +1

    the best :) thank youuu

  • @user-hw7ci5ed7x
    @user-hw7ci5ed7x 5 лет назад +1

    Very thanks my freind komar
    Iuseful more in my job for design kpis

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 лет назад

      Thanks for your valuable feedback. Please share this with your friends and team members.

  • @attaali275
    @attaali275 Год назад +1

    Brilliant

  • @sanjitshah4408
    @sanjitshah4408 10 месяцев назад +1

    Thanks alot guruji

  • @imranhaider8248
    @imranhaider8248 2 года назад +1

    Great work

  • @andywahyu8683
    @andywahyu8683 4 года назад +1

    Excellent

  • @AjayKumar-hq6sm
    @AjayKumar-hq6sm 5 лет назад +1

    U are great 😍😍

  • @discoverystudio3998
    @discoverystudio3998 4 года назад +1

    Thank you so much 🇵🇰

  • @jhonydathis2767
    @jhonydathis2767 2 года назад

    brilliant work

  • @MohAboAbdo
    @MohAboAbdo 5 лет назад +1

    Thanks.

  • @manishchauhan-sn3bm
    @manishchauhan-sn3bm 4 года назад +3

    Really helpful, Thanks for sharing the video, is it possible to have one colour but that would change with the percentage
    dark red if the percentage is very low, ligh red if the percentage is mid, light green for less dark green for target acheived

  • @khaledaboelhamd
    @khaledaboelhamd 4 года назад +1

    Thank you

  • @mimonoor9157
    @mimonoor9157 4 года назад +1

    Exellent 👏🏻

  • @isamali6962
    @isamali6962 2 года назад +1

    Amazing 🤩🤩🤩

  • @hiteshdamania2744
    @hiteshdamania2744 3 года назад +1

    very Awesome Pk

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp 5 лет назад +1

    Nice video.

  • @temitayofalola2807
    @temitayofalola2807 Год назад

    Lovely

  • @vikasd7834
    @vikasd7834 3 года назад +1

    NICE

  • @mohanbahuguna
    @mohanbahuguna 4 года назад +1

    nice vid

  • @abtay3093
    @abtay3093 4 года назад +1

    it's So so good, a good work, thank you very much :)

  • @gerardlunow567
    @gerardlunow567 4 года назад

    Hi, I heard you say after you group the three items to copy and then select the column and paste. I do not have the paste option? Other than that great video. Never mind, got it.

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 Год назад

    Superb design, make it some different shape designs sir…🙏🙏🙏💐💐💐

  • @loupiat2173
    @loupiat2173 4 года назад

    Thanks for the tutorial.I have a question: When the value in the cell is under 10% the colored level disappears in the bottlle.What can I do ?

    • @seanshannon4619
      @seanshannon4619 Год назад

      When you create the "glass structure" that you copy and paste onto the bars, you need to size them so that the top and bottom cap height are 5% the size of the middle part's height. For example, I set the height for the top and bottom cap to 0.1, and the middle to 2.0, before grouping then copying/pasting. Works perfectly.

  • @bennybostoen4292
    @bennybostoen4292 5 лет назад

    nice work, everything works fine. but how do you convert % into numbers. i want to use it to count the male and female but in numbers. anyways thank you very much!

  • @moghira1
    @moghira1 4 года назад +1

    very nice !!!BUT I wonder Why you haven't replied to the question: how do you change the bars in graphic by the glass bar?

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад

      Thanks for your valuable feedback. I will definitely try to make such video very soon

  • @germanjauregui2944
    @germanjauregui2944 4 года назад

    Hi, I have a question. Who do you do to change the orange bars into the glass tube ? I can´t do it .....! thank you.

  • @vantuong240
    @vantuong240 4 года назад

    hi, how do you change the bars in graphic by the glass bar?

  • @knightseeds2402
    @knightseeds2402 4 года назад +1

    Thanks for the video. Is it possible to have an uploaded image be what changes level instead of a glass? An example would be a storage bin picture and the data change the level on it instead of a preset image.

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад +1

      It's a great idea. I will definitely try to make such video

    • @knightseeds2402
      @knightseeds2402 4 года назад

      @@PKAnExcelExpert Thanks. If you ever do please let me know. Videos are looking good.

  • @bovmengleang81
    @bovmengleang81 2 года назад

    Thank you for your good video. But I was wondering that it does not show if it is 5% of service level.

  • @haho767
    @haho767 5 лет назад

    Thanks for your valuable training.
    so you can not replay this comment by "Thanks for your valuable feedback" ;)

  • @maheshreddy-hj6xr
    @maheshreddy-hj6xr 3 года назад

    Very nice bro ...but can u say how to change the bar into glass plzzz

  • @nahodahassan6938
    @nahodahassan6938 4 года назад

    I have 2007 Office not useful for me...what type of office you recommend?

  • @VigneshS-gv4eq
    @VigneshS-gv4eq 4 года назад +1

    Awesome bro! Thank you so much. However I am having a small suggestion. While doing something Please explain why are you doing that so that we will get some idea. for example in this case you have used transparency as 50%,75%,100%,100%,75%&50%. Later I Understood why you have used this exact digits but make sure please explain so that everyone will understand why you taken exact digit to that particular.

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад +1

      Thanks for your valuable feedback. I will take care of this in upcoming videos.

  • @pramodbhatt6906
    @pramodbhatt6906 3 года назад

    Hi i have a question if data in values instead of percentage in this case how we can create the graph like this

  • @Oliwer21
    @Oliwer21 4 года назад

    You know how to make excel fitting analysis for football bet?

  • @carearayam
    @carearayam 5 лет назад +1

    Hi, how do you change the bars in graphic by the glass bar?

  • @pisanu6699
    @pisanu6699 3 года назад

    Thanks for the video. Could you please tell me what you are saying from the time 6:45 to 6:50?
    I can't understand it (my English is not good). Thanks.

  • @onniagustya3782
    @onniagustya3782 3 года назад

    How to make one cylinder chart with condition formating from one data with different value fill in?

  • @wasay456
    @wasay456 Месяц назад

    how to make the battery tops stay the same depth?

  • @rcverdejo
    @rcverdejo 2 года назад

    I just started to subscribe yesterday. How can use the same chart but I want to show volume

  • @mornestander8851
    @mornestander8851 Год назад

    I use Excel 2013, however at 7Min time frame when the bars change Colour then mine does not change Colour at all.