Thank you PK for that video. Those are beautiful charts! A lot of people on this channel are going to be impressing their co-workers with stunning charts and graphics learned from you. Thank you.
Thanks Satish for motivational words. Audience like you always encourage me to do something innovative in Excel. Please share it with your friends and colleagues. Thanks again for your valuable support to my channel.
Hallo PK, please if may ask, i am trying to do something like this to show the number of Non Conformance per Trains set of every month , but i am Failing to understand which value and formula to use( i can see yours that you use sales /Sales Conversion ) , and wanted to show the Actual Number not in percentage . How best can i do the calculation ?
I have generate the Pivot table ,how to convert the value in % directly in pivot table and how use same value in Transparent area by using Calculated field Formula Pls suggest for it eg Row label Sum of Value 1 23.92% 2 50.25% 3 19.28% 4 45.26%
Undoubtedly, this is a great chart / dashboard presentation. If given to a senior manager or director, they would go ecstatic over it. Your creations are simply great, Priyendra. However, in this chart, as well as another chart in this video --> ruclips.net/video/5ZQfJXmj4sw/видео.html I don't understand the concept of "TopCap" & "BottomCap" getting additional 5% each. Wouldn't that change the whole total of the figures. For example if QUALITY Score is say 83%, you would take 17% as the remaining Filler. that much is understandable, but adding the TopCap & BottomCap would be an additional 10% (5-5% each). So, aren't we creating the chart for a total of 110% or even more? Like in this chart, you have taken a 25% Label Filler, above the BottomCap just for labelling. While it looks good, but wouldn't it change the entire calculation? Aren't we creating a chart for 135% of the original values ? Eventhough this and the other cylindrical chart I mentioned in the URL above, look GREAT, but aren't they mathematically inaccurate ??
Thank you PK for that video. Those are beautiful charts! A lot of people on this channel are going to be impressing their co-workers with stunning charts and graphics learned from you. Thank you.
Thanks for your valuable feedback
Thnks PK excellent video..God bless you
Thanks for your valuable feedback🙏
Excellent video. I’m learning a lot from you.
Let me take a moment to tell the brilliance level you've shown to create this awesome dyno chart based on pivot table... killer trick PK!!
Thanks Satish for motivational words. Audience like you always encourage me to do something innovative in Excel. Please share it with your friends and colleagues.
Thanks again for your valuable support to my channel.
I WANT TO THANK YOU MY BROTHER FOR YOUR GOOD WORKS
This is really a big compliment. Thanks for your valuable support to my channel.
Learn a lot from your videos keep up the good work
Glad to hear it
You are a star... great job and you are a creative person.. keep it up..
Hi Sunil,
Thanks for your compliment. One request please share it in your friends circle on social media so that every one can make the most of it.
I was just building a chart similar to this so it was very helpful. great thanks
Excellent 👌
Thanks
Love you Bhai....... For teaching us stay blessed bro
Thanks Kumar for your appreciation. Please share it with your friends and colleagues.
You are a genius man, cheers!
Thanks for your valuable feedback
Great work, man. You have been awesome!
Thanks
Excelente ejemplo. Gracias.
Gracias
Buen trabajo amigo. Un abrazo
This guy is genius
Thanks Arun for your appreciation. Please share it with your friends and colleagues.
Thanks lot ❤️
You're welcome 😊
It's incredible.
Thanks for your valuable feedback
Very good! Thank you
Thanks for your valuable feedback
Nice job man. Thank you.
Thanks for your valuable feedback
Beatiful
Thanks🙏
Great bro....
Thanks Kumar. Please share it with your friends and colleagues.
Very nice
Thanks for your appreciation
Thanks a lot
Thanks for watching
Awesome.
Thanks for your valuable feedback
thank you
Thanks for your valuable comment.
do you have a webside were you can downloade all your projects ?
Please visit my website: WWW.PK-AnExcelExpert.Com
Thanks
Which Excel version are you using?
Hi Shushant,
I am using excel 2013.
Hallo PK, please if may ask, i am trying to do something like this to show the number of Non Conformance per Trains set of every month , but i am Failing to understand which value and formula to use( i can see yours that you use sales /Sales Conversion ) , and wanted to show the Actual Number not in percentage . How best can i do the calculation ?
👍👌👌👌
Thanks for your valuable feedback
Hello sir Please i want this file to open with userform , can you prepare us this ??
i 'll thak you a lot
Thanks
Sure,I will definitely try to make such video very soon.
if i need chart & Data to veiw, then what is the Procedure
Please download this excel file from the link given vedio's description box.
I have generate the Pivot table ,how to convert the value in % directly in pivot table and how use same value in Transparent area by using Calculated field Formula
Pls suggest for it
eg
Row label Sum of Value
1 23.92%
2 50.25%
3 19.28%
4 45.26%
which ms office version is this
I am using excel 2013
i have prepared the chart but some issues
Bhai aap Maharaaj ho
Thanks Sunil for your valuable comments.
Hello Sir,
I am safety manager, I want to create a body injury chart.
For example Hand injury 11,head injury 5,foot injury 3.eye injury 2
Undoubtedly, this is a great chart / dashboard presentation. If given to a senior manager or director, they would go ecstatic over it. Your creations are simply great, Priyendra.
However, in this chart, as well as another chart in this video --> ruclips.net/video/5ZQfJXmj4sw/видео.html
I don't understand the concept of "TopCap" & "BottomCap" getting additional 5% each. Wouldn't that change the whole total of the figures. For example if QUALITY Score is say 83%, you would take 17% as the remaining Filler. that much is understandable, but adding the TopCap & BottomCap would be an additional 10% (5-5% each). So, aren't we creating the chart for a total of 110% or even more? Like in this chart, you have taken a 25% Label Filler, above the BottomCap just for labelling. While it looks good, but wouldn't it change the entire calculation? Aren't we creating a chart for 135% of the original values ? Eventhough this and the other cylindrical chart I mentioned in the URL above, look GREAT, but aren't they mathematically inaccurate ??