Тёмный

Info-graphics: 3D Glass Chart in Excel 

PK: An Excel Expert
Подписаться 276 тыс.
Просмотров 234 тыс.
50% 1

Опубликовано:

 

27 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 203   
@MsAmyTee
@MsAmyTee 4 года назад
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.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@pedromartinez1165
@pedromartinez1165 3 года назад
Your videos are like chocolate, sweet and can't get enough of it. Awesome job - thank you !
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@siddharthanandy3798
@siddharthanandy3798 Год назад
Brilliant works and generous to share with everyone! Thank you.
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome🙏
@paulocezardesouzasouza2044
@paulocezardesouzasouza2044 4 года назад
I am from Brazil. Cuiabá. I enjoyed that, vey much. Fantastic. Thanks
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@pandharinathjoshi6565
@pandharinathjoshi6565 3 года назад
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 👍👍👍👍👍💐💐💐
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
So nice of you
@andrytianarabezanahary1083
@andrytianarabezanahary1083 4 года назад
helpful. Thanks for your teaching. You really deserve your EXPERT title...
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@othmanashara9382
@othmanashara9382 2 года назад
you are a creative in this field. thank you
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks for your valuable feedback🙏
@StefanoLandi
@StefanoLandi 3 года назад
Amazing 3D effect and simply done, thank-you!
@soumiaould5723
@soumiaould5723 3 года назад
I am so grateful to you, for you shared so very knowledge of yours with us.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@asifmahmoodliaquat5866
@asifmahmoodliaquat5866 2 года назад
very well demonstrated. thanks for sharing
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Most welcome
@noorm516
@noorm516 3 года назад
Amazing. Thank you very much for the explanation. I have been able to do it and it looks wonderful
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@michaeldegregorio5472
@michaeldegregorio5472 3 года назад
Awesome ideas. Your a true excel artist!
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@Chef-1707
@Chef-1707 3 года назад
That is genius and we learn sooooo much from you. Appreciate your generosity of sharing your knowledge with us.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
My pleasure!
@sangeeth201
@sangeeth201 2 года назад
Thank you Bro myself learn new think today once again thank you so much
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
My pleasure
@enginyildiz6524
@enginyildiz6524 5 лет назад
Muhteşemdi. Teşekkür ederiz. Türkiye’den takipçiniz.
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Değerli geribildirim için teşekkürler
@isaiasfranciscodasilva644
@isaiasfranciscodasilva644 4 года назад
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.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@dedeoliveira82
@dedeoliveira82 5 лет назад
hello @PK! I'm from Brasil. very good. great idea. Thank you
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@ajay000003
@ajay000003 3 года назад
Thanks a lot for sharing this video.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for watching
@BoxerDogs
@BoxerDogs 4 года назад
Wow. This is amazing. Very very nice.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@wasay456
@wasay456 4 месяца назад
how to make the battery tops stay the same depth?
@senanayakebuddhike8276
@senanayakebuddhike8276 13 дней назад
Can create this chart Horizontally ?
@imranhaider8248
@imranhaider8248 2 года назад
Great work
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thank you so much 😀
@elakkiyaful
@elakkiyaful 3 года назад
Sir; yours videos are outstanding
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@mornestander8851
@mornestander8851 Год назад
I use Excel 2013, however at 7Min time frame when the bars change Colour then mine does not change Colour at all.
@diegoenriquez8995
@diegoenriquez8995 5 лет назад
You are amaizing i am from mexico and i sing your chanel
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback.
@hannielizdeluna8933
@hannielizdeluna8933 3 года назад
the best :) thank youuu
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@hiteshdamania2744
@hiteshdamania2744 4 года назад
very Awesome Pk
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@olaupea7665
@olaupea7665 Год назад
Excelente trabajo saludos
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Muchas gracias
@Conradfvs
@Conradfvs 3 года назад
Really fantastic , thank you 🙏.
@sanjitshah4408
@sanjitshah4408 Год назад
Thanks alot guruji
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Most welcome🙏
@nguyenTran-ju7lp
@nguyenTran-ju7lp 3 года назад
Wowowow Wowowow amazing
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@ravichauhan3933
@ravichauhan3933 Год назад
tusi Great ho bro
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks a lot
@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.
@SaqibKhan-hq9wp
@SaqibKhan-hq9wp 5 лет назад
great ...very beautiful charts sir ...
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@aswinidutt7199
@aswinidutt7199 5 лет назад
Excellent work.
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@ashokgautam7438
@ashokgautam7438 5 лет назад
Awesome, nicely explained
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@xOneLove27x
@xOneLove27x 4 года назад
Thank you... so easy to follow
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@Go4Truth
@Go4Truth 5 лет назад
good nice and attractive chart
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@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.
@pandharinathjoshi6565
@pandharinathjoshi6565 2 года назад
Superb design, make it some different shape designs sir…🙏🙏🙏💐💐💐
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Ok thank you
@attaali275
@attaali275 Год назад
Brilliant
@PKAnExcelExpert
@PKAnExcelExpert Год назад
Thanks🙏
@maheshreddy-hj6xr
@maheshreddy-hj6xr 4 года назад
Very nice bro ...but can u say how to change the bar into glass plzzz
@andywahyu8683
@andywahyu8683 4 года назад
Excellent
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@moghira1
@moghira1 4 года назад
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
@pisanu6699
@pisanu6699 4 года назад
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.
@temitayofalola2807
@temitayofalola2807 2 года назад
Lovely
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks
@edisoncalixtosilva4610
@edisoncalixtosilva4610 5 лет назад
Just amazing... Thank You so much....
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@vantuong240
@vantuong240 4 года назад
hi, how do you change the bars in graphic by the glass bar?
@VigneshS-gv4eq
@VigneshS-gv4eq 4 года назад
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 года назад
Thanks for your valuable feedback. I will take care of this in upcoming videos.
@carolmonteiro7790
@carolmonteiro7790 5 лет назад
Excellent!
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@knightseeds2402
@knightseeds2402 4 года назад
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 года назад
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.
@ndakazajeannapoleon6486
@ndakazajeannapoleon6486 5 лет назад
Thank you it is really awesome
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@khabatalikarim7146
@khabatalikarim7146 5 лет назад
Thanks!! That is amazing!
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@ifbreports2860
@ifbreports2860 3 года назад
can in create the same chart through Pivot
@abcontrast2340
@abcontrast2340 3 года назад
I watched this 5x.. fought through the frustration of my low training and lower skillsets. THEN I saw your brilliance! Thanks!
@discoverystudio3998
@discoverystudio3998 4 года назад
Thank you so much 🇵🇰
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Welcome!
@harrietgomez9769
@harrietgomez9769 2 года назад
Can this be done in Google Sheets?
@SureshHellsfire
@SureshHellsfire 5 лет назад
WoW 😲.. Thanks a lot
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@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.
@AjayKumar-hq6sm
@AjayKumar-hq6sm 5 лет назад
U are great 😍😍
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@hammaadouani8773
@hammaadouani8773 4 года назад
haw transfer the orange color to the transparent one (6:49)
@StanOwden
@StanOwden 4 года назад
I guess with the Format painter
@dharmendrayadav-bw2gp
@dharmendrayadav-bw2gp 5 лет назад
Nice video.
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@mdroman3017
@mdroman3017 4 года назад
Thank you boss
@MohAboAbdo
@MohAboAbdo 5 лет назад
Thanks.
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for watching
@CyberSERT
@CyberSERT 5 лет назад
WOW!
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable Feedback.
@mohanbahuguna
@mohanbahuguna 4 года назад
nice vid
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@VivekKumar-gn5wv
@VivekKumar-gn5wv 5 лет назад
Sir gadi lete time kese kist dete hai
@sharadaprashansahoo5506
@sharadaprashansahoo5506 5 лет назад
how to use this chart to take value instead of Percentage
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
You need to define your maximum value to use this trick
@sharadaprashansahoo5506
@sharadaprashansahoo5506 5 лет назад
Thank u sir, please upload a video with attractive chart to compare month wise which consist four to five category in each month
@haho767
@haho767 5 лет назад
Thanks for your valuable training. so you can not replay this comment by "Thanks for your valuable feedback" ;)
@lanphamphuong4210
@lanphamphuong4210 2 года назад
peak
@manishchauhan-sn3bm
@manishchauhan-sn3bm 4 года назад
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
@carearayam
@carearayam 5 лет назад
Hi, how do you change the bars in graphic by the glass bar?
@sundayp1268
@sundayp1268 5 лет назад
Thanks.
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for watching
@jhj8530
@jhj8530 3 года назад
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 RU-vid 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.
@kaaminikannoujia5730
@kaaminikannoujia5730 Год назад
If we want to change colour after create how to do
@rickcampbell6987
@rickcampbell6987 5 лет назад
Glas I found this! Will give an extra "something" to Excel bar charts I produce herein the lab.
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@thanhdongctm6
@thanhdongctm6 3 года назад
Awsome thanks for the tutorial, one again, thanks you so much
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@Finance_And_English
@Finance_And_English 3 года назад
Hello Sir..!!! I have one question???... related to charts....Can u make Instagram Activity Chart in Excel... Please reply Sir ....I'm waiting for yr reply...
@zzizzimizzi6028
@zzizzimizzi6028 3 года назад
respected I follow your work in excel and I am very interested in your work in excel especially 3d chart ... actually i play lotto 6/45 and i tried to do in excel collect all the numbers from 1990 until today, how much one number has dropped to date how many times has it been drawn to date, i would ask you if it is not a problem to show me how to do it , thanks in advance, when the beetle won the lottery I will pay you gallons of beer, thanks in advance
@HendrikBez
@HendrikBez 3 года назад
Thank you, but how do you use it for normal number info like this 12345.78787878 and if you have -12.9%
@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.
@rcverdejo
@rcverdejo 2 года назад
I just started to subscribe yesterday. How can use the same chart but I want to show volume
@vsdteams9241
@vsdteams9241 4 года назад
thanks from From, very easy, and usefull
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@patrickdevries8643
@patrickdevries8643 2 года назад
How can i change the procent formule to a financial formule to make these glass charts to a months value
@jbkregs2766
@jbkregs2766 4 года назад
Can you have 3 different colors based on percentages? Such as 0-25% red, 26-50% yellow, 51-100% green?
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Yes we can use conditional formatting. I will definitely try to make such video very soon.
@jbkregs2766
@jbkregs2766 4 года назад
PK: An Excel Expert Thank you so much. That would be so very helpful!
@Deepakyadav-ji7ps
@Deepakyadav-ji7ps 4 года назад
Gfhfhyuhgttteri ma h
@nsanch0181
@nsanch0181 3 года назад
Beautiful chart. Thank you PK.
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@onniagustya3782
@onniagustya3782 3 года назад
How to make one cylinder chart with condition formating from one data with different value fill in?
@SimpleB2k4
@SimpleB2k4 5 лет назад
Thanks PK. Great tutorial
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback. Please share it with your friends.
@nahodahassan6938
@nahodahassan6938 4 года назад
I have 2007 Office not useful for me...what type of office you recommend?
@Oliwer21
@Oliwer21 4 года назад
You know how to make excel fitting analysis for football bet?
@pixrun5388
@pixrun5388 4 года назад
Awesome But process is long
@hemantjoshi5034
@hemantjoshi5034 5 лет назад
Thanks a ton ! This is very helpful !!
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback
@PettakaTechnologies
@PettakaTechnologies 5 лет назад
Nice explanation
@isamali6962
@isamali6962 2 года назад
Amazing 🤩🤩🤩
@PKAnExcelExpert
@PKAnExcelExpert 2 года назад
Thanks🙏
@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
@vikasd7834
@vikasd7834 3 года назад
NICE
@PKAnExcelExpert
@PKAnExcelExpert 3 года назад
Thanks for your valuable feedback
@JWMV1
@JWMV1 4 года назад
You are the best!!
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks
@jmyt5763
@jmyt5763 4 года назад
Nice , It is clear , easy , to the point
@عبيدمصلحالعصيمي
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.
@muthuraja6589
@muthuraja6589 5 лет назад
Excellent sir...👌👌👌👌
@PKAnExcelExpert
@PKAnExcelExpert 5 лет назад
Thanks for your valuable feedback.
Далее
Офицер, я всё объясню
01:00
Просмотров 3 млн
How to create a beautiful 3D Infographic in Excel
16:22
Beautiful 3D Visualization in Excel
19:13
Просмотров 96 тыс.
Quick 3D Container Chart in Excel
15:12
Просмотров 98 тыс.
Info-graphics: 3D Gauge Chart in Excel
15:41
Просмотров 54 тыс.
Info-graphics: Flag Chart in Excel
7:36
Просмотров 9 тыс.
Progress Circle Chart in Excel as NEVER seen before!
10:31
Info-graphics: Group of Circle Charts in Excel
15:55
Просмотров 128 тыс.
Stunning Battery Chart in Excel
14:23
Просмотров 44 тыс.
Офицер, я всё объясню
01:00
Просмотров 3 млн