I know this is 6 years old, and there might be an obvious answer to these questions...When the percentage changes, my graph does not have that sliding animation that yours does. And my text boxes are also not automatically glued to the chart, so they don't move with the chart. Can anyone help, thanks.
@am_9944
11 ай бұрын
hello how do i make a kpi properlly showing my target goal lets say i want to make a kpi for saving account so 10K being 100% and i invested 1K so my progress will show 10% i cant figure out how to make it work with numbers not only pure % , 1-% . thank you.
@ishitasheth6683
4 ай бұрын
What if I have absolute value and not percentages?
@ShishirKumarSankeesa
2 жыл бұрын
Thanks for excellent Dashboard sir. I am facing an issue when the percentage reaches 100% because the "No fill" Section would be 0% and the complete circle is showing up instead of half circle, as the section where transperancy is set as 85% is showing up as the full circle. Can we fix this issue please?
@jeanettesefers8180
6 ай бұрын
Best tutorial on creating half circle KPI. Thank you!!
@PKAnExcelExpert
6 ай бұрын
Most welcome
@davisjoe68
3 күн бұрын
ABSOLUTLEY the BEST!!!!!!!
@marcusheller1268
9 ай бұрын
Just fantastic! Thanks for your great job on this. you're very knowledgeable!!
@PKAnExcelExpert
9 ай бұрын
Thanks for your valuable feedback.
@chi4real123
2 жыл бұрын
Fantastic Job. Is it possible to put a target line on the half circle to indicate the plan %?
@PKAnExcelExpert
2 жыл бұрын
Please watch the below video to put the target line: kzitem.info/news/bejne/2a6H2pqOiHihio4
@excelangola2727
2 жыл бұрын
Just what I needed... Thanks from Angola Dear Sir
@PKAnExcelExpert
2 жыл бұрын
Most welcome
@elianahohl8855
3 жыл бұрын
Wow this is just great, thank you very much!!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@sanusi8359
2 жыл бұрын
How can you be so kind? Thank you so so much for this!
@PKAnExcelExpert
2 жыл бұрын
Welcome
@yeechinng8330
9 ай бұрын
Thanks for the useful tutorial. 😊
@PKAnExcelExpert
9 ай бұрын
You're welcome 😊
@zerobars3
10 ай бұрын
very good tutorial thank you
@PKAnExcelExpert
10 ай бұрын
Most welcome🙏
@MatiasWins
3 жыл бұрын
Thank you from Argentina!
@PKAnExcelExpert
3 жыл бұрын
Most welcome
@imranbhatti8580
3 жыл бұрын
Hello PK. Simply the best. Keep it up.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@prasadmn8355
Жыл бұрын
hi sir if there is an decimal value how can we create could u please teach me
@hamishrobertson6997
4 жыл бұрын
can you do condintioning format with the text? E.g below 40% and its red?
@moshoneywilliam4253
4 жыл бұрын
it's simple and easy to follow, thanks! you are amazing!
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@levelupexcelskill
4 жыл бұрын
Hi Sir, Many thanks for making such kind of videos , could you please suggest me how we can apply conditional formatting in these chart
@nader6450
4 жыл бұрын
Hi What if the percentage is more than 100%, What should I do to keep it in like the half-circle? Thx
@tsegrrl
5 жыл бұрын
This was super helpful! thanks for sharing this
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@harisabid2055
5 ай бұрын
best tutorial ❤
@PKAnExcelExpert
5 ай бұрын
Thanks
@harisabid2055
5 ай бұрын
Sir can we connect these charts with slicers to make them fully automated
@michaelleroux338
4 жыл бұрын
Great video, thanks. Will this work on Google Sheets?
@emilianogabriele4878
3 жыл бұрын
Grazie! From Italy
@PKAnExcelExpert
3 жыл бұрын
Grazie per la visione
@Alfa_yt_offcial_
Жыл бұрын
Present 🙄press Enter
@ahmedelkshawy
4 жыл бұрын
Great Video Sir , I Can't Thanks you Enough
@physcohomie187
4 жыл бұрын
How would you go about making a progress chart on a shape? Specifically a 'piece of pie' / 'slice' of a circle. Is that possible so as your % gets higher for of the slice fills with a solid color? Thanks
@youngistaann
5 жыл бұрын
Thanks PK! This was helpful!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@tsdhruva2298
6 жыл бұрын
thanks sir. can you please also share how we can prepare waterfall chart / bridge which is used for explaining the variance
@giorgosi.fovakis8810
3 жыл бұрын
Great!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@keharsingh2396
5 жыл бұрын
Oswm sir
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@bryankasper8567
3 жыл бұрын
thank you for this. the solution was right under my nose. thanks for the help!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@sunil1376
5 жыл бұрын
This is great. Was looking for this. Can you also please show how to add a needle to the gauge chart?
@isuruwickramasinghe8259
3 жыл бұрын
PK the MAN
@stevehuynh7712
6 жыл бұрын
Thanks a lot PK. It is useful for me :)
@juanignaciolucianolandero9948
6 жыл бұрын
Denle su buen Like al hombre, no se nada de ingles pero sus videos estan bien explicados
@yuliakaurova2937
5 жыл бұрын
Hi! Thanks a lot! It was very helpful. Could you please let me know how I can move chart created in Excell to Power Point?
@alim5878
5 жыл бұрын
I tried to do it directly in ppt but could not
@congtran1073
5 жыл бұрын
thanks for sharing
@yp4577
6 жыл бұрын
That is clever. Thank you for the instruction. Which version of excel is this?
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching and sharing your valuable feedback. I am using excel 2013 however it will work in Excel 2010 also.
@gauravgupta4983
6 жыл бұрын
Sir I want to class pls suggest me you provide or not
@PKAnExcelExpert
6 жыл бұрын
Hi Gaurav, As of now I am not providing classes, but in will be starting online classes for excel, vba and power bi very soon.
@vijaykumargude761
6 жыл бұрын
Excellent one sir, Very thankful to you for sharing excellent dash boards. Have one doubt, can we create double Half KPI chart using using pivot table. Please let me know...
@PKAnExcelExpert
6 жыл бұрын
Thanks Vijay for your valuable feedback. We can create is by using pivot table also. Need to some calculated fields.
@vijaykumargude761
6 жыл бұрын
@@PKAnExcelExpert Can You make a video of the subject, or please give a call on my number 9100050806. As I searched for your number in your all and couldn't found. Hence, the request. Hope you understand sir.
@PKAnExcelExpert
6 жыл бұрын
Hi Vijay, I will definitely try to make such video very soon.
Пікірлер: 72