Info-graphics: Group of Circle Charts in Excel

#KPICharts #ExcelInfograhics
Hello Friends,
In this video, you will learn how to create a beautiful Group of Circle Charts. In this Group of Circle Charts, we have displayed Market level and Over all service level. You can use it in your business dashboard or prestation.
Click here to download the practice file:
www.pk-anexcelexpert.com/grou...
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...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@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/...

[@ruginathomas3873]

Good Job Brother! You made my day

[@PKAnExcelExpert]

Glad to hear that!

[@hiteshpandey8370]

No crap in between. Pure skill in every step.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@josharroyo7920]

Lo usaré en mis reportes, gracias PK

[@OscarGarcia-rn7wy]

Excelente Gráfico, muchas gracias por compartir tus conocimientos, podrías subir algún ejemplo tipo radar.

[@Sss7277]

an amazing chart....thanks for creating such a good chart...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wojciechwisniewski2510]

Thank you for another brilliant movie

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yulinliu850]

Excellent! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tienngotk]

An amazing chart, thank you for your effort. Well done sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tienngotk]

@@PKAnExcelExpert i have learnt from you so much idea for my work. Keep going sir.

[@brighnquisitive6217]

Nicely done, as usual PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Great creativity sir👏👏👏 awesome one...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@FAlqahtani]

Wow!! You are the best

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lukev730]

Wow PK great chart
Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@upgradetechnicalskills3392]

Great job sir it's amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anbaabdellah8022]

Excellent PK 👍👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shoryaarora1464]

Awesome 👏🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@poderdeexcel7428]

Hi Pk, thank you very much for sharing your knowledge, a query, as it would be in the case that you would like the highest percentage to be placed in the center depending on how the data changes. For example if India is the highest value go in the center, if you then switch to Uk let it go to the center, etc. Thanks.

[@vikaspatil06]

Thanks for making videos

[@PKAnExcelExpert]

Thanks for watching

[@pgkannan]

Excellent PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@david4ever160]

GREAT JOB

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@durgesh91tomar]

Awesome.......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pattaraponsukaew3349]

alway amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ericiriarte2880]

Me encanta

[@user-hw7ci5ed7x]

Great thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sunilkumar-jl7uf]

very beautiful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anandsdasnanda2960]

Is it possible to make the colors change automatically as per percentage

[@xtroll4326]

Sir can you make a video on making bills on Excel including gst .

[@yuvarajkrishnamoorthy]

Great job.. one observation.. India chart's value and pie does not match.

[@PKAnExcelExpert]

Thanks for your valuable feedback. I think it is connected with UK data point by mistake

[@lakshyacomputerbayana]

Sir ye course Hindi language mei nhi hai kya

[@beniezung4611]

excellent. thank u

[@PKAnExcelExpert]

You're most welcome

[@jordividal7804]

Always enjoy your videos and tutorials PK.

[@PKAnExcelExpert]

Thanks

[@hassanelfakey4708]

thank you very much, it's amazing.

[@PKAnExcelExpert]

Most welcome🙏

[@AJ-oe7ez]

Awsome chart, explained with ease!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@karuppusamichandran6479]

Thanks Bro , Exactly this is wat i was looking for ... perfect.... sharing the knowledge is very powerful attitude.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@SanviPatil2019]

superb

[@PKAnExcelExpert]

Thanks

[@MadanKumar-uy4iu]

Zero hater 👏

[@CUBING116]

Iam a 11 years boy I do your 3D circle chart I like your channel

[@yasi4011]

🌱

[@pandharinathjoshi6565]

Sir i have seen this 10 times…🙏🙏

[@PKAnExcelExpert]

Thanks a lot

[@nitinnaykodi]

VDO blurred

[@neerajbelwal8752]

Your Practice files are not getting downloaded

[@danielkinyanjui170]

Can somebody help how I can subscribe twice......this tutorials is unresistable. Thanks bro

[@PKAnExcelExpert]

Thanks for your valuable support 👍

[@AmeeraHazmar]

Amazing bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dhananjaypinjan2643]

Great creativity and extraordinary efforts as always.. Well done PK 👌

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Sir., beautiful video sir... 🙏🙏🙏

[@PKAnExcelExpert]

So nice of you

[@victoriaabba8722]

not well explained for a beginner and very fast speaking. not helpful to me

[@thakuranujsingh4419]

Very beautiful 🙏..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rukshik]

Subscribed to your channel, your efforts are commendable

[@PKAnExcelExpert]

Thanks for your valuable feedback and subscription 👍

[@rukshik]

@@PKAnExcelExpert i tried searching a lot for some actual vs budget dashboard for expenses on your page, could not find it.. if you can hep me with the link here please..

[@taufiqsahabuddin5151]

When trying to input % into text box by typing "=" then click on the cell in the pivot table then enter, somehow it is not success (warning box appears)
I see your video, it will be similar "=$B$4" (for example). However when I try the same step, it is such "=get from the pivot xxxxxxxxx"
Please advice

[@nadeemjohn6126]

Excellent Effort. Sheer professionalism. Keep up the good work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@najaybsaidhadji3123]

How does the overall become 47%? Any one can guide me please! Thanks

[@TerrY9048]

Thanks for stunning chart , Great! to see it

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@midixon11]

Will you pls give a session on how to create the circles to auto populate into a 2nd sheet. Once date change on 1st sheet

[@rajeshsureshrajput]

Excellent!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KhalilAhmad74036]

Extraordinary effort. Well done Sir!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aydneroglu7908]

Wow.. This is Perfect. Can you send me this project pls? [e-mail]

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please download this excel file from the link given vedio's description box

[@kathimills7699]

Just noticed that the 2 smaller charts at 89% aren't filled the same, although I understand why I wanted to make sure no one got confused by an incorrect reference

[@kathimills7699]

I can spend days watching your wonderful videos, thank you so much and please keep them coming!

[@sinakeyhanian6034]

Amazing. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@martacasanova2329]

Great!!! Thank you so much, it was exactly what I was looking for.

[@PKAnExcelExpert]

Glad it was helpful!

[@sharvari.s.vichare]

Thank you so much.
Your video is helpful for us. Thanks for sharing your knowledge to excel

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ritwik513]

can a feature like if data is added further then a chart is made side by side and colors also changed, can it happen?

[@PKAnExcelExpert]

Thanks is not available in this chart. I will try to make another video on this topic

[@TGENC-ls8nz]

thank you veryyyyy much. this video perfect

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kumarkusalakumar9651]

Thanks for sharing excel tips and tools for graphing, so creative appreciate your effort

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@santoshkr.gautam1982]

Yah kaise dikhega ?

[@santoshkr.gautam1982]

chart jo insert karte hai uske baad chart element nahi dikhta hai.

[@MohanYGK]

🙏🙏🙏

[@PKAnExcelExpert]

Thanks

[@excel-k-sir]

👍

[@PKAnExcelExpert]

Thanks

[@alhassanabuelkhair]

Thanks
that is amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gokulkannan90]

thank you soo much, your video was very useful for me, tomorrow i'm going to apply this on my office work .

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nabilalquqa9019]

You are the best one my friend go ahead

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mymatemartin]

Great content but waaaaay too many ads. It's extremely annoying and detracts from the lesson.

[@sirajsiraj7088]

Thanks for your kind explanation!
Pls if you don't mind send me the vba code to my email. [e-mail]

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please download this excel file from the link given vedio's description box.

[@sirajsiraj7088]

PK: An Excel Expert
my dear it's showing some error msg like path not found
pls advice how to fix it

[@AashishVaghela]

Dear Priyendra,
Since you seem to be from the Call-Center/BPO Industry, here is a little Problem with VBA code, that I think I can discuss with you. As you must be aware that in a BPO environment, there are lot Performance measuring matrices. One such is NPS or Net Promoter Score. I am not sure if you are already aware of this or not, but I shall mention it here for everyone's enlightenment. This new measure of NPS is one step ahead of the conventional CSAT that we have as the customer's feedback from the Survey that was sent to them. Here's the detailed explanation of NPS.
' NPS is the Acronym for Net Promoter Score, a measuring unit of overall customer satisfaction and loyalty.
' It is calculated based on the quantum of surveys received to gauge the loyalty and retention of customers.
' The Customers giving positive response to a Feedback Survey are called Promoters.
' The Customers giving negative response to a Feedback Survey are called Detractors.
' The Customers giving balanced response to a Feedback Survey are called Passives & are ignored for calculations.
' NPS is calculated by Subtracting the Detractors from the Promoters, then dividing the outcome of that by the
' total number of Surveys with feedback (Count of Surveys) received back from the customers, multiplying that
' number by 100. The final outcome should be between +100 and -100. Depending upon the Agreed Service Level with
' the Client, the acceptable value could range anywhere between +20 to +40. A negative NPS would indicate very
' poor level of customer service and matching responses from the customers.
I tried searching Google for a VBA code for an Excel Function that can take the Promoters, Detractors and Total number of Surveys as an input and calculate the NPS value and return it to the CELL from which it was initiated.
Unfortunately, I couldn't find much except some large and confusing code on StackOverFlow site which somehow did not meet my requirements and expectations. I wanted to keep it real simple. Here's that Code that I have written myself, a couple of days ago, but getting a #VALUE error in the Cell where this function is called.
================================================================================
Public Function CalcNPS(Proms As Integer, Dets As Integer, Totals As Integer)
Dim Pr As Integer
Dim Dt As Integer
Dim Tot As Integer
Dim NPS As Single
' Assign Values to local variables from the parameters received while invoking the function
Pr = Proms
Dt = Dets
Tot = Totals
' This is the actual Math Calculation or actual Logic
NPS = (((Pr - Dt) / Tot) * 100)
MsgBox "NPS is " & NPS, vbInformation+vbOKOnly, "Calculated NPS is : "
Return ' Return the value of calculated NPS to the Cell
End Function
================================================================================
As mentioned above, this formula returns a "#VALUE" error in the Cell from where this formula is initiate.
For example, if Cells C4 is Promoters, C5 is Detractors, C6 is Passives and C7 is the Total of all these, then this function is called in the Cell C8, but it shows ERROR. However, as you can see, there is a MSGBOX function called inside this function, which actually displays the value in Decimal, like 27.3333333 or 41.666666667, etc.
My question is, if the function and calculation is simple enough, for which the MSGBOX even shows the calculated output, why does it return a #VALUE error in the Cell C8.
Kindly Help !! Thanks in advance !!

[@AashishVaghela]

Priyendra .... Some help on this would be really helpful. MSGBOX shows the calculated value of NPS, but the Cell from which this function is called, returns a #VALUE error. I believe it could be data type mismatch. Kindly review the code above and suggest modifications. Thanks in advance !!!

[@frankling.zevallosestrada5965]

Excelente grafico. Flicitaciones muy bien explicado.
Un saludo desde Perú.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@grahamparker7729]

That was great 👌🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MrSaqr98]

wonderful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@janerravelo9187]

Excelente... Gracias por sus aporte...

[@PKAnExcelExpert]

Thanks for your valuable feedback