RYG Dial Gauge meter In Excel (Without Macros)

Рет қаралды 70,178

6 жыл бұрын

Hello Friends,
In this video you will learn how to create a RYG (Red, Yellow and Green) Gauge meter in Excel without using of any macro.
Please download this excel file from below given link:
www.pk-anexcelexpert.com/ryg-...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkan-excel-expert-9748...
Pinterest:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert

Пікірлер: 52

@moresopho7723 5 жыл бұрын

Your channel deserves many more subscribers.

@RJG-Studios 6 жыл бұрын

Thank you for this video, this is a nice one, also stable on Mac OS X and no VBA. For the record, I don’t use your sheets, the best way of learning is to build it by your self 😉

@rupertwagemakers2970 6 жыл бұрын

Thank you very much PK from The Netherlands!

@csabaczaban3916 6 жыл бұрын

I’m really grateful for this video, I’ve found it especially useful and applicable in my profession. I’m a psychologist and I’ve used this way of visualization to show how many points a certain person get on a personality trait scale. Thank you!

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback

@karimmaxi8305 6 жыл бұрын

Two words my good friend.... EPIC and SIMPLE Many thanks

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback

@Chef-1707 6 жыл бұрын

another fabulous video and masterclass .Many thanks

@PKAnExcelExpert 6 жыл бұрын

Thanks

@jayantiviswanath9785 5 жыл бұрын

Very nice video. Helped me to build one ! Thank you !

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@thabietgabier9025 Жыл бұрын

Thank you for the video. Taught me alot today.

@PKAnExcelExpert Жыл бұрын

Glad to hear it!

@9997999702 4 жыл бұрын

Thank You, Very Helpful!!

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@JTRotter 5 жыл бұрын

just what i needed cheers mate !

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@bricc322 6 жыл бұрын

Piece of art!

@PKAnExcelExpert 6 жыл бұрын

Thanks Celia for your valuable feedback

@chandrakr83 3 жыл бұрын

nice tips, thank you

@hemedsalim5985 3 жыл бұрын

Thank you very much, it's so useful.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@rajranjan6040 5 жыл бұрын

Excellent Job dear PK

@PKAnExcelExpert 5 жыл бұрын

Thanks Raj for your valuable feedback

@0317patrick 6 жыл бұрын

Thanks that's a real help sir

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback

@rudolphkotze7951 Жыл бұрын

Brilliant, thank you.

@PKAnExcelExpert Жыл бұрын

You're very welcome!

@ammarkhan7709 Жыл бұрын

Great job 👏🏼

@PKAnExcelExpert Жыл бұрын

Thank you!! 😁

@mohamedkhattab3423 6 жыл бұрын

you are awesome

@PKAnExcelExpert 6 жыл бұрын

Thanks for watching and sharing your valuable feedback

@hamdee1412 6 жыл бұрын

I came here for coppers and I found golds! Thank you sir, your work is splendid

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback. Audience like you always encourage me to do something innovative in Excel. Please share this with your friends and colleagues whoever is looking for excel and vba tutorials.

@hamdee1412 6 жыл бұрын

+PK: An Excel Expert Will do sir!

@PKAnExcelExpert 6 жыл бұрын

Thank you for your support to my channel

@kmanoj392 7 ай бұрын

Nice

@PKAnExcelExpert 7 ай бұрын

Thanks

@bassmahegazy9053 6 жыл бұрын

Hi PK, Good job, your charts are quite innovative & explanation is super simple, keep up the good work. One idea for you. Can you help in creating a gauge chart that ends with the red zone for a lagging indicator, eg. In Incidents tracking in Safety measures the Target is to maintain a 0 records of Loss Time Incidents LTI so the gauge should start with 0 LTI (green zone) and if it moved it is towards the yellow, amber then red which is the Target that should not be exceeded which is the maximum rate that the organization sets. Basically, the gauge chart you create but in an opposite manner.

@PKAnExcelExpert 6 жыл бұрын

Thanks for watching and sharing your valuable feedback. I will definitely try to make such video very soon. Thanks for nice idea.

@liquiduser 2 жыл бұрын

Thank you. How do I these extra shapes in PowerPoint and still have them connected to excel? For clarification, I prefer to have the chart embedded in PowerPoint so I can only make the update inside the embedded excel file as opposed to the external excel file.

@manojnandagawali2729 6 жыл бұрын

Sir, please provide us speedometer using combo box or data validation

@yaseenmuhammad5624 2 жыл бұрын

Is there any logical method we easily make outer circle perfect in graph? very difficult to arrange but if some technical method or idea that will be perfect.