RYG Dial Gauge meter In Excel (Without Macros)

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

PK: An Excel Expert

PK: An Excel Expert

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
@rupertwagemakers2970
@rupertwagemakers2970 6 жыл бұрын
Thank you very much PK from The Netherlands!
@RJG-Studios
@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 😉
@csabaczaban3916
@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
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@moresopho7723
@moresopho7723 5 жыл бұрын
Your channel deserves many more subscribers.
@Chef-1707
@Chef-1707 6 жыл бұрын
another fabulous video and masterclass .Many thanks
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks
@karimmaxi8305
@karimmaxi8305 6 жыл бұрын
Two words my good friend.... EPIC and SIMPLE Many thanks
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@jayantiviswanath9785
@jayantiviswanath9785 5 жыл бұрын
Very nice video. Helped me to build one ! Thank you !
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@thabietgabier9025
@thabietgabier9025 Жыл бұрын
Thank you for the video. Taught me alot today.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Glad to hear it!
@JTRotter
@JTRotter 5 жыл бұрын
just what i needed cheers mate !
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@9997999702
@9997999702 4 жыл бұрын
Thank You, Very Helpful!!
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@chandrakr83
@chandrakr83 3 жыл бұрын
nice tips, thank you
@bricc322
@bricc322 6 жыл бұрын
Piece of art!
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks Celia for your valuable feedback
@hemedsalim5985
@hemedsalim5985 3 жыл бұрын
Thank you very much, it's so useful.
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@0317patrick
@0317patrick 6 жыл бұрын
Thanks that's a real help sir
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@rajranjan6040
@rajranjan6040 5 жыл бұрын
Excellent Job dear PK
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks Raj for your valuable feedback
@rudolphkotze7951
@rudolphkotze7951 Жыл бұрын
Brilliant, thank you.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
You're very welcome!
@mohamedkhattab3423
@mohamedkhattab3423 6 жыл бұрын
you are awesome
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@ammarkhan7709
@ammarkhan7709 Жыл бұрын
Great job 👏🏼
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thank you!! 😁
@hamdee1412
@hamdee1412 6 жыл бұрын
I came here for coppers and I found golds! Thank you sir, your work is splendid
@PKAnExcelExpert
@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
@hamdee1412 6 жыл бұрын
+PK: An Excel Expert Will do sir!
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thank you for your support to my channel
@bassmahegazy9053
@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
@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
@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.
@kmanoj392
@kmanoj392 7 ай бұрын
Nice
@PKAnExcelExpert
@PKAnExcelExpert 7 ай бұрын
Thanks
@manojnandagawali2729
@manojnandagawali2729 6 жыл бұрын
Sir, please provide us speedometer using combo box or data validation
@yaseenmuhammad5624
@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.
@salkarmanoj
@salkarmanoj 3 жыл бұрын
How to create a speedometer graph for productivity in per hour
@Anophor
@Anophor 5 жыл бұрын
Hello, first link can not open. Could you control it please?
@MyGamePerformanceSchoolSport
@MyGamePerformanceSchoolSport 6 жыл бұрын
Hi, I would like to commission you to develop a system in excel. Have you got an email address I can send over the details
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Hi Dave, Please connect with me on Facebook, Twitter and telegram. Details have been given in videos discretion box. Thanks for watching.
@srikantgaigaria7694
@srikantgaigaria7694 6 жыл бұрын
Hi Sir how to download the excel file
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Hi Srikant, Excel download link has been given in videos discretion box. Please download this excel file from there.
@jeffreyrichardson
@jeffreyrichardson 5 жыл бұрын
computerized shit a little tat for the tit buddy is this it
Progress Circle chart in Excel 2010
14:15
PK: An Excel Expert
Рет қаралды 53 М.
Stunning Battery Chart in Excel
14:23
PK: An Excel Expert
Рет қаралды 44 М.
Secret Experiment Toothpaste Pt.4 😱 #shorts
00:35
Mr DegrEE
Рет қаралды 39 МЛН
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Savage Vlogs
Рет қаралды 12 МЛН
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 39 МЛН
Our New And Improved Gauge (Speedometer) Chart In Excel!
11:12
Excel Campus - Jon
Рет қаралды 20 М.
Ultimate Speedometer in Excel: Part 1
15:58
PK: An Excel Expert
Рет қаралды 349 М.
Excel Speedometer Charts - How to build them and why YOU SHOULDN'T!
10:25
MyOnlineTrainingHub
Рет қаралды 51 М.
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Leila Gharani
Рет қаралды 432 М.
Infographics: Filling Circle Chart in Excel
12:30
PK: An Excel Expert
Рет қаралды 55 М.
How to Create a Gauge Chart in Excel
15:00
ExcelDemy
Рет қаралды 2,4 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 137 М.
3D Doughnut Chart for KPI Metrics
13:30
PK: An Excel Expert
Рет қаралды 71 М.