Info-graphics: 3D Glass Chart in Excel

[@abcontrast2340]

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

[@jhj8530]

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 KZbin 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]

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]

Thanks for your valuable feedback

[@pedromartinez1165]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@siddharthanandy3798]

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

[@PKAnExcelExpert]

Most welcome🙏

[@asifmahmoodliaquat5866]

very well demonstrated. thanks for sharing

[@PKAnExcelExpert]

Most welcome

[@othmanashara9382]

you are a creative in this field. thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@paulocezardesouzasouza2044]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@andrytianarabezanahary1083]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sangeeth201]

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

[@PKAnExcelExpert]

My pleasure

[@pandharinathjoshi6565]

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]

So nice of you

[@StefanoLandi]

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

[@Chef-1707]

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

[@PKAnExcelExpert]

My pleasure!

[@soumiaould5723]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@michaeldegregorio5472]

Awesome ideas. Your a true excel artist!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@noorm516]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nsanch0181]

Beautiful chart. Thank you PK.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ajay000003]

Thanks a lot for sharing this video.

[@PKAnExcelExpert]

Thanks for watching

[@manishchauhan-sn3bm]

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

[@jmyt5763]

Nice , It is clear , easy , to the point

[@imranhaider8248]

Great work

[@PKAnExcelExpert]

Thank you so much 😀

[@thanhdongctm6]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@enginyildiz6524]

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

[@PKAnExcelExpert]

Değerli geribildirim için teşekkürler

[@isaiasfranciscodasilva644]

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]

Thanks for your valuable feedback

[@bovmengleang81]

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

[@dedeoliveira82]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rickcampbell6987]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@BoxerDogs]

Wow. This is amazing. Very very nice.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@humbertochavarria7589]

Great tutorial. Well explained

[@nguyenTran-ju7lp]

Wowowow Wowowow amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@elakkiyaful]

Sir; yours videos are outstanding

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@senanayakebuddhike8276]

Can create this chart Horizontally ?

[@SimpleB2k4]

Thanks PK. Great tutorial

[@PKAnExcelExpert]

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

[@mornestander8851]

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

[@varher76]

MUCHAS GRACIAS. SALUDOS DESDE ECUADOR -AMERICA

[@olaupea7665]

Excelente trabajo saludos

[@PKAnExcelExpert]

Muchas gracias

[@wasay456]

how to make the battery tops stay the same depth?

[@SaqibKhan-hq9wp]

great ...very beautiful charts sir ...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vsdteams9241]

thanks from From, very easy, and usefull

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aswinidutt7199]

Excellent work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@isamali6962]

Amazing 🤩🤩🤩

[@PKAnExcelExpert]

Thanks🙏

[@judicaelb6212]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rcverdejo]

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

[@JWMV1]

You are the best!!

[@PKAnExcelExpert]

Thanks

[@hemantjoshi5034]

Thanks a ton ! This is very helpful !!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashokgautam7438]

Awesome, nicely explained

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ravichauhan3933]

tusi Great ho bro

[@PKAnExcelExpert]

Thanks a lot

[@temitayofalola2807]

Lovely

[@PKAnExcelExpert]

Thanks

[@hiteshdamania2744]

very Awesome Pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@diegoenriquez8995]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@Conradfvs]

Really fantastic , thank you 🙏.

[@attaali275]

Brilliant

[@PKAnExcelExpert]

Thanks🙏

[@sanjitshah4408]

Thanks alot guruji

[@PKAnExcelExpert]

Most welcome🙏

[@xOneLove27x]

Thank you... so easy to follow

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muthuraja6589]

Excellent sir...👌👌👌👌

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@kaaminikannoujia5730]

If we want to change colour after create how to do

[@Go4Truth]

good nice and attractive chart

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nahodahassan6938]

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

[@VigneshS-gv4eq]

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]

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

[@pandharinathjoshi6565]

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

[@PKAnExcelExpert]

Ok thank you

[@hannielizdeluna8933]

the best :) thank youuu

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@edisoncalixtosilva4610]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jhonydathis2767]

brilliant work

[@PKAnExcelExpert]

Thanks

[@maheshreddy-hj6xr]

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

[@andywahyu8683]

Excellent

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gerardlunow567]

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.

[@moghira1]

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]

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

[@patrickdevries8643]

How can i change the procent formule to a financial formule to make these glass charts to a months value

[@4511raj]

You are next level bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@angadsingh9318]

You are awesome sir👌👌👌👌🙏🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pisanu6699]

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.

[@harrietgomez9769]

Can this be done in Google Sheets?

[@onniagustya3782]

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

[@ajitpal3016]

Excellent chart sir

[@germanjauregui2944]

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.

[@Oliwer21]

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

[@ifbreports2860]

can in create the same chart through Pivot

[@pramodbhatt6906]

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

[@mimonoor9157]

Exellent 👏🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mimonoor9157]

Very useful thank you

[@PettakaTechnologies]

Nice explanation

[@carolmonteiro7790]

Excellent!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@thinkexcel9976]

Great Video!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@عبيدمصلحالعصيمي]

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

[@PKAnExcelExpert]

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

[@SureshHellsfire]

WoW 😲.. Thanks a lot

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ndakazajeannapoleon6486]

Thank you it is really awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Finance_And_English]

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

[@fhatuwanimakungo24]

thanks Very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vikasd7834]

NICE

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@moresopho7723]

This is gold!

[@PKAnExcelExpert]

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

[@khabatalikarim7146]

Thanks!! That is amazing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bennybostoen4292]

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!

[@vantuong240]

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

[@info2satish]

Amazing PK!!

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@knightseeds2402]

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]

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

[@knightseeds2402]

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

[@dharmendrayadav-bw2gp]

Nice video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Centrus668]

Thank you, but how do you use it for normal number info like this 12345.78787878 and if you have -12.9%

[@discoverystudio3998]

Thank you so much 🇵🇰

[@PKAnExcelExpert]

Welcome!

[@AjayKumar-hq6sm]

U are great 😍😍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jbkregs2766]

Can you have 3 different colors based on percentages? Such as 0-25% red, 26-50% yellow, 51-100% green?

[@PKAnExcelExpert]

Yes we can use conditional formatting. I will definitely try to make such video very soon.

[@jbkregs2766]

PK: An Excel Expert Thank you so much. That would be so very helpful!

[@Deepakyadav-ji7ps]

Gfhfhyuhgttteri ma h

[@loupiat2173]

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]

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.