Half Circle KPI info graphic chart

Подписаться 272 тыс.

Просмотров 112 тыс.

50% 1

Hello Friends,
In this video you will learn how to create Half Circle KPI Info-graphics chart in Excel.
Please download this excel file from below given link:
drive.google.com/open?id=1OG_...
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
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ 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/...
Laptop: amzn.to/2PlFFFz

Опубликовано:

21 фев 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@jeanettesefers8180 5 месяцев назад

Best tutorial on creating half circle KPI. Thank you!!

@PKAnExcelExpert 5 месяцев назад

Most welcome

@ahmedelkshawy 4 года назад

Great Video Sir , I Can't Thanks you Enough

@moshoneywilliam4253 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@stevehuynh7712 6 лет назад

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

@marcusheller1268 7 месяцев назад

Just fantastic! Thanks for your great job on this. you're very knowledgeable!!

@PKAnExcelExpert 7 месяцев назад

Thanks for your valuable feedback.

@bryankasper8567 2 года назад

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

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@juanignaciolucianolandero9948 6 лет назад

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

@tsegrrl 5 лет назад

This was super helpful! thanks for sharing this

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@excelangola2727 2 года назад

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

@PKAnExcelExpert 2 года назад

Most welcome

@MatiasWins 3 года назад

Thank you from Argentina!

@PKAnExcelExpert 3 года назад

Most welcome

@youngistaann 5 лет назад

Thanks PK! This was helpful!

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@Almirjorge1 6 лет назад

Obrigado por compartilhar

@elianahohl8855 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@rubenregalado6615 6 лет назад

EXELENTE VIDEO AMIGO, saludos desde el salvador

@PKAnExcelExpert 6 лет назад

Gracias por valiosos comentarios

@yeechinng8330 8 месяцев назад

Thanks for the useful tutorial. 😊

@PKAnExcelExpert 8 месяцев назад

You're welcome 😊

@sanusi8359 2 года назад

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

@PKAnExcelExpert 2 года назад

Welcome

@sunil1376 5 лет назад

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

@congtran1073 5 лет назад

thanks for sharing

@imranbhatti8580 2 года назад

Hello PK. Simply the best. Keep it up.

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@emilianogabriele4878 3 года назад

Grazie! From Italy

@PKAnExcelExpert 3 года назад

Grazie per la visione

@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

@zerobars3 8 месяцев назад

very good tutorial thank you

@PKAnExcelExpert 8 месяцев назад

Most welcome🙏

@giorgosi.fovakis8810 3 года назад

Great!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@isuruwickramasinghe8259 3 года назад

PK the MAN

@tsdhruva2298 6 лет назад

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

@joshuafancher3111 6 лет назад

Thank You

@PKAnExcelExpert 6 лет назад

Thanks for watching

@harisabid2055 3 месяца назад

best tutorial ❤

@PKAnExcelExpert 3 месяца назад

Thanks

@harisabid2055 3 месяца назад

Sir can we connect these charts with slicers to make them fully automated

@physcohomie187 3 года назад

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

@michaelleroux338 3 года назад

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

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

@keharsingh2396 5 лет назад

Oswm sir

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@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?

@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

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

@chi4real123 Год назад

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

@PKAnExcelExpert Год назад

Please watch the below video to put the target line: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xxQtfXOFpWY.html

@nader6450 4 года назад

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

@hamishrobertson6997 3 года назад

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

@prasadmn8355 11 месяцев назад

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

@ishitasheth6683 2 месяца назад

What if I have absolute value and not percentages?

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

@am_9944 9 месяцев назад

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.

@williamkent2446 2 месяца назад

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.