Half Circle KPI info graphic chart

Half Circle KPI info graphic chart

PK: An Excel Expert

6 лет назад

111,386 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@zerobars3
@zerobars3 - 22.11.2023 16:38

very good tutorial thank you

Ответить
@andrewmochalov861
@andrewmochalov861 - 24.10.2023 14:16

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.

Ответить
@prasadmn8355
@prasadmn8355 - 27.08.2023 08:33

hi sir if there is an decimal value how can we create could u please teach me

Ответить
@SLHYPEROfficialYT
@SLHYPEROfficialYT - 14.12.2022 06:05

Present 🙄press Enter

Ответить
@chi4real123
@chi4real123 - 31.08.2022 15:47

Fantastic Job. Is it possible to put a target line on the half circle to indicate the plan %?

Ответить
@excelangola2727
@excelangola2727 - 27.07.2022 19:07

Just what I needed... Thanks from Angola Dear Sir

Ответить
@sanusi8359
@sanusi8359 - 10.04.2022 15:05

How can you be so kind? Thank you so so much for this!

Ответить
@ShishirKumarSankeesa
@ShishirKumarSankeesa - 02.03.2022 08:41

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?

Ответить
@bryankasper8567
@bryankasper8567 - 15.09.2021 17:31

thank you for this. the solution was right under my nose. thanks for the help!

Ответить
@imranbhatti8580
@imranbhatti8580 - 30.08.2021 21:24

Hello PK. Simply the best. Keep it up.

Ответить
@elianahohl8855
@elianahohl8855 - 01.07.2021 16:56

Wow this is just great, thank you very much!!!

Ответить
@MatiasWins
@MatiasWins - 18.05.2021 13:23

Thank you from Argentina!

Ответить
@isuruwickramasinghe8259
@isuruwickramasinghe8259 - 12.02.2021 19:31

PK the MAN

Ответить
@emilianogabriele4878
@emilianogabriele4878 - 17.12.2020 17:30

Grazie! From Italy

Ответить
@giorgosi.fovakis8810
@giorgosi.fovakis8810 - 11.12.2020 10:23

Great!

Ответить
@michaelleroux338
@michaelleroux338 - 16.10.2020 03:34

Great video, thanks. Will this work on Google Sheets?

Ответить
@physcohomie187
@physcohomie187 - 14.10.2020 01:03

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

Ответить
@hamishrobertson6997
@hamishrobertson6997 - 07.10.2020 02:57

can you do condintioning format with the text? E.g below 40% and its red?

Ответить
@nader6450
@nader6450 - 29.07.2020 21:15

Hi
What if the percentage is more than 100%, What should I do to keep it in like the half-circle?
Thx

Ответить
@ahmedelkshawy
@ahmedelkshawy - 13.04.2020 22:13

Great Video Sir , I Can't Thanks you Enough

Ответить
@moshoneywilliam4253
@moshoneywilliam4253 - 13.04.2020 10:32

it's simple and easy to follow, thanks! you are amazing!

Ответить
@levelupexcelskill
@levelupexcelskill - 07.01.2020 12:59

Hi Sir,


Many thanks for making such kind of videos , could you please suggest me how we can apply conditional formatting in these chart

Ответить
@sunil1376
@sunil1376 - 27.07.2019 08:42

This is great. Was looking for this. Can you also please show how to add a needle to the gauge chart?

Ответить
@youngistaann
@youngistaann - 24.06.2019 10:02

Thanks PK! This was helpful!

Ответить
@yuliakaurova2937
@yuliakaurova2937 - 12.04.2019 22:24

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?

Ответить
@tsegrrl
@tsegrrl - 18.12.2018 02:08

This was super helpful! thanks for sharing this

Ответить
@congtran1073
@congtran1073 - 03.12.2018 18:10

thanks for sharing

Ответить
@keharsingh2396
@keharsingh2396 - 22.11.2018 19:20

Oswm sir

Ответить
@vijaykumargude761
@vijaykumargude761 - 31.08.2018 20:53

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

Ответить
@juanignaciolucianolandero9948
@juanignaciolucianolandero9948 - 13.07.2018 00:25

Denle su buen Like al hombre, no se nada de ingles pero sus videos estan bien explicados

Ответить
@joshuafancher3111
@joshuafancher3111 - 12.05.2018 05:44

Thank You

Ответить
@gauravgupta4983
@gauravgupta4983 - 27.02.2018 11:12

Sir I want to class pls suggest me you provide or not

Ответить
@tsdhruva2298
@tsdhruva2298 - 24.02.2018 21:02

thanks sir. can you please also share how we can prepare waterfall chart / bridge which is used for explaining the variance

Ответить
@yp4577
@yp4577 - 24.02.2018 18:16

That is clever. Thank you for the instruction. Which version of excel is this?

Ответить
@rubenregalado6615
@rubenregalado6615 - 24.02.2018 01:42

EXELENTE VIDEO AMIGO, saludos desde el salvador

Ответить
@Almirjorge1
@Almirjorge1 - 23.02.2018 13:53

Obrigado por compartilhar

Ответить
@stevehuynh7712
@stevehuynh7712 - 23.02.2018 07:10

Thanks a lot PK. It is useful for me :)

Ответить