Superb bro you done created awesome, i did for same for three speed meters
@kalyanbasak5344
6 жыл бұрын
PK I do not know how to appreciate your Excel skills. You are amazing. I can see flavours of BI tools in Excel. Only you made it possible.
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@marcosbrooksallen7868
6 жыл бұрын
Very Impressive Technique. I have follow up every step and I came up with the same appealing and astonishing chart. If you don't mind, I'll apply it in my Workbooks and Share with others in LinkedIn, Facebook, Twitter. Off Course giving you the Right Credits. Thank you so much for sharing this type of material with us.
@robertojunior9375
3 жыл бұрын
Parabéns meu amigo, você é uma referência em excel pra mim.
@JoseMerced-dk2fb
11 ай бұрын
Thank you for your videos. They are so very helpful.
@PKAnExcelExpert
11 ай бұрын
Glad you like them!
@duartebotelho4183
6 жыл бұрын
Great job :-) Only change slightly your VBA code to 1 line: Shapes("Group 10").Rotation = Range("C2") * 248 A lot of work but in the end it really pays.
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching and sharing your valuable feedback.
@querobinenator
5 жыл бұрын
amzing.tnx
@irvanmunadi26
3 жыл бұрын
Thank you very much sir, kindness last forever
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@fdarko1
6 жыл бұрын
PK you are just awesome! this video has really made my year! from afar Speedometer design seems impossible but you've nailed it for me! Thanks!
@brandonh3375
5 жыл бұрын
Awesome job, you do a terrific job instructing also thank you very much!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@michaelsmall340
6 жыл бұрын
This is great - except that you need to use VBA... An alternative is to create the shape-graphics exactly as you have done in the videos without the needle- and then use a pie-chart as the needle. The pie chart has 3 wedges. the 'middle' wedge would have a width of 1 and a fill color of black. the other wedges would take up the remainder of the pie chart - and their colors are all no-fill. all of the wedges would also have no outlines. If you center the pie-chart over the middle of the speedometer - then changes to the pie-values are reflected in the '1' wedge, which then positions itself somewhere on your dial. I used '200' as the total for my pie chart - with the 1st wedge being the variable that I wanted to change. the next wedge is always 1 (unless I want a thicker needle) and the last wedge has a value equal to 200 minus the values in wedge 1 and wedge 2. If you use a pivot table - then any changes in the pivot are automatically reflected on the dial - without the need to run a macro. Hope this helps.
@PKAnExcelExpert
6 жыл бұрын
Hi Michael, Thanks for watching and sharing your valuable information. Creating a Speedometer with the macro is just an experiment however I have already created few videos regarding Speedometer without VBA. Please see below the link: kzitem.info/news/bejne/yWmIl4yVbaOBfKQ kzitem.info/news/bejne/s5qdzX18pHtzimk
@gavdownes100
6 жыл бұрын
The first video he says this was created without using any charts
@karengoldberg65
5 жыл бұрын
Hi, can you help me with this? I'm trying your method thx
@RFILHO23
3 жыл бұрын
Uma solução muito bacana sem precisar usar gráficos. Muito criativo! Parabéns!
@dirkwangke9476
6 жыл бұрын
complicated especially with those macro.. but its all worth a subscription.. Good Job and Thanks
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@williamreinman8192
5 жыл бұрын
Great work, PK. Thanks for taking the time to share your knowledge.
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@LuisRivera-gv7zw
6 жыл бұрын
¡Excelente, eres un mago de Excel! Gracias por compartir tus conocimientos
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@MrRanjitsihag
4 жыл бұрын
Koi jabab hi nhi hai Bhai saab 1 number 👌👌
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@pedromartinez1165
3 жыл бұрын
You're THE MAN! Thank you
@PKAnExcelExpert
3 жыл бұрын
Thanks
@yosephambawofficial7961
6 жыл бұрын
ur the best! u even make this available to download blessings men appreciated
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@andrewcraddock1819
5 жыл бұрын
Fantastic. Thank you for the time. This is an excellent tool.
@wagnerbarbosa1894
5 жыл бұрын
Very Good! Thank you for sharing your knowledge in Excel!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@gundimedaphani7400
6 ай бұрын
As viewers, Sumeet ji should teach us Politics. A Super-charged analyst
@investofun9551
Жыл бұрын
Thanks a lot. Great education!
@PKAnExcelExpert
Жыл бұрын
Glad you enjoyed it!
@thierrybroyer4376
3 жыл бұрын
Namste and shourkryia : excellent, uo're my champion !!!
@davidtaylor4039
2 жыл бұрын
Awesome video. Just what I needed! Thank you PK
@PKAnExcelExpert
2 жыл бұрын
Glad it helped!
@MagnusLundberg
3 жыл бұрын
Hi PK..when using a source value in an xl cell based on a combo active-x controller selection, I simply don't get the arrow to move. It works fine when typing in a value in the target cell, but not when using the combobox (active-X) selection to change the target cell value. How to fix this? / Best Magnus
@anandnavaratna6407
3 жыл бұрын
Very nice video. Can you make a video for needle/ value change for continues value. Like speed of bike fed in excel sheet row (w.r.t time) and when u play it u can see at what time what was the needle value.
@Excel-power-users
6 жыл бұрын
Very nice looking for this for a long time
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching
@fernandoperes5164
5 жыл бұрын
Impressive Excel !!! Great work !!! Tks you!!! Graet work Master!!!
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback.
@txpatriot7044
3 жыл бұрын
So far so good but I dont have a developer tab? How do I get one? Ok figured it out. GREAT video!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback.
@garytaylor982
5 жыл бұрын
Fantastic Thank you, Thank You I take my hat off to you sir
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback. Request you to please share this with your friends and colleagues.
@josecastanedaantunano4528
6 жыл бұрын
Desde México Felicidades muy bien explicado y muy útil
@ammaynard9901
3 жыл бұрын
This is Awesome! Thanks for putting this stuff up!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
@SantoshSingh-lx3um
5 жыл бұрын
Thanks from . My Bottom of heart for this amazing video...It really helped me lot...Love to learn from you more...But wanna meet u and thank Personally....Thanks once again.....Can I download this excel sheet sir
@PKAnExcelExpert
5 жыл бұрын
Thanks Santosh for nice words and your valuable feedback. Download link has been given in videos discretion box
@jbkregs2766
4 жыл бұрын
This is fantastic! Is there a way to lock it all together so it can be moved as one once it is finished?
@jbkregs2766
4 жыл бұрын
Also will the code change for the pointer once grouped together? Thank you so much!
@vipinpal2240
3 ай бұрын
I have Watched your ultimate speedometer videos which is really very good. Both part. But my question is can we connect it with data. Because I have connected it but is not running. Please suggest.
@Proyekta.Solutions
6 жыл бұрын
Excelent. Very good. Congratulations. You give me a good idea for my financial model un VBA Excel.
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback. Please share it with your friends and colleagues whoever is looking for excel and vba tutorials.
@shakifrauf2204
2 жыл бұрын
VERY CREATIVE
@PKAnExcelExpert
2 жыл бұрын
Thanks🙏
@sukdebghosh2946
3 жыл бұрын
First of all thank you for your great tutorial. It would be great help for me if you help me with vb code so that i can add more than one speedometer in a single work sheet.
@myriaince7143
3 жыл бұрын
Sorry I am late to the party. I just discovered these tutorials and they are great! I was able to construct several copies. However, I have a question about the math. I have a metric that I want to measure where the highest percentage is 25%, not 100%. What is the best way to modify the VB to accommodate this? What would the math be if the field is a time value of mm:ss? Thanks!
@nimalperera8222
5 жыл бұрын
Excellent. Thank you very much
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@TKILPATRICK100
4 жыл бұрын
Please could you advise can the VBA formula be copied & pasted onto another excel sheet and when saving the work is the file format always xlsb?
@navdeipkkohli299
6 жыл бұрын
PK... I am your fan... you are my friend now...
@PKAnExcelExpert
6 жыл бұрын
It is my pleasure Navdeep. Thanks for your valuable support to my channel.
@navdeipkkohli299
6 жыл бұрын
Thanks... please tell what changes we need to make in VBA codes for 2nd and 3rd speedometer, Do we need to write again or the same codes will work?
@Esteebbo
6 жыл бұрын
I would like to know as I have been unable to recreate the 2nd and 3rd
@bluelion1962
6 жыл бұрын
Absolutely great job!
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@BertandRussell
6 жыл бұрын
Mind Blowing....
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@atlascopcoaustralia9austra489
2 жыл бұрын
great video how do you lock all the boxes and move the dial as one shape ? and while reducing the size of it :-)
@MunaffalNawaz
6 жыл бұрын
Thanks a lot for sharing. It is really wonderful and helpful
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@MyGamePerformanceSchoolSport
6 жыл бұрын
Hi PK, Excellent and very useful. How do I use the needle to point to the chart in seconds. For example I need to create the gauge to point towards times that I have set for various tasks. One task takes between 1.5 seconds to 3 to complete and the other task takes between 10 and 20 seconds. Obviously I need two gauges but I can not seem to get the needle to move without using a % in the task cell.. Thanks in advance
@ishu1827
Жыл бұрын
I've got a formula copying a percent from another page to the sheet with the speedometers. The needles won't move based on that formula. Is there a change to the VBA to get it to recognize the formula calculation and move the needle? I believe since the cell is not changing the needle doesn't move even though there is a new calculation. Please advice ASAP
@inderr7bajaj
4 жыл бұрын
Bhai awesome! Subscribed...
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@jonathancopley7429
4 жыл бұрын
I love this and been trying to create one for years. Only issue i have is that i feed my percentage figure from another tab. the figure updates on the tab with the dial however the dial does not update?
@jabrifoued4123
6 жыл бұрын
thank you very much for the vedio and for the excel file
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@CarlosVazquez-jp7vg
6 жыл бұрын
Excellent video. Thanks
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@gavdownes100
6 жыл бұрын
Very nice for part 2 as well
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@syedarshadali2436
5 жыл бұрын
Very nice video and useful for me. I just prepared the speedometer and working well but have only one problem. The macro is running perfect while opening the file or while changing the cell value by pressing enter at the end. If the cell value is changed by a formula the needle could not moved as macro not running by changing cell value theough formula. Any one can help me how to run the macro when cell value changed by a formula. Thanks for every one for help. Regards Syed.
@rjvdb67
6 жыл бұрын
Hey thanks for the great tutorial. Just a question. Your chart changes when you manually change the value. I have a chart where the value changes dynamically but the speedometer won't update when the value changes. How do I make the chart reference the updated value in the cell so that it changes as the cell value changes without having to manually press enter? Thanks
@ishu1827
Жыл бұрын
I am facing same issue but no solution. P.K please help
@mohdsartaj7942
6 жыл бұрын
U r genius amazing video boss !!
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@gadamrshmanov7731
2 жыл бұрын
good job
@PKAnExcelExpert
2 жыл бұрын
Thanks
@dashrathsutar8615
5 жыл бұрын
Sir ,we are put lot effort to create this but in most of companies does not have such high durable to create this
@gjangenent
4 ай бұрын
Thanks a lot!!
@PKAnExcelExpert
4 ай бұрын
Most welcome
@fhatuwanimakungo24
5 жыл бұрын
great work always thanks you .
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@gopalsugavanam3847
4 жыл бұрын
Hi PK, this is an awesome video published by you... I am quiet regularly following your tips. Actually, I tried to do the same exercise for one of my official requirement. For me for the Speedo meter to change I am referring to a Cell value "F17" in the same worksheet. But the F17 is having a variable value "=OVERUTIL". This means when ever the variable value changes, the speedo meter has to change. When I do the cell value change manually, the needle is working properly. But When the variable value is changing, the needle is not working. Also I tried to put a break-point in the Macro. I found that it doesn't shoot to macro itself. How can I execute the Macro which we have written, when the Variable Value is changing dynamically. Please help me. If you give your contact number, I can give you a call to clarify.
@ishu1827
Жыл бұрын
I have same problem. Is there any solution?? please advice ASAP
@TKILPATRICK100
4 жыл бұрын
Please could you advise, can the speedometer be made without VBA?
@maheshlowe907
6 жыл бұрын
Great tuto. Thank you.
@hgilbert9479
6 жыл бұрын
Great video! I had no problems creating the first speedometer. I am creating four speedometer's and having trouble within VBA after I enter data for the second speedometer. The needle is all over the place and will not set correctly. Is there a specific way of entering the data in VBA to get four speedometer's to work properly? Not sure what I am doing wrong.
@19710306
4 жыл бұрын
Genius! Thanks
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@raginishahani9605
6 жыл бұрын
Great Video PK can’t see your excel file though
@yell-o8503
4 жыл бұрын
Amazing. Thumbs up.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@ahmedhosny3037
4 жыл бұрын
Goood Job ,can you share link to upload this template please
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback. Download link has been given in videos discretion box.
@tabcentralalabama9944
2 жыл бұрын
PK - I need to use data on different sheet in the same workbook for a speedometer that I created. what VB code do I need to use to make the speedometer on one page use data on another?
@leadedge7081
6 жыл бұрын
this is excellent - well done
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@nagakumarb.b.tudayekar1854
4 жыл бұрын
thank you sir, subscribed your channel please share the google drive link .
@PKAnExcelExpert
4 жыл бұрын
I have changed the link form google drive to my website. You can download it from below link: www.pk-anexcelexpert.com/ultimate-speedometer-in-excel/
@ryanlybeck6592
3 жыл бұрын
I've got a formula copying a percent from another page to the sheet with the speedometers. The needles won't move based on that formula. Is there a change to the VBA to get it to recognize the formula calculation and move the needle? I believe since the cell is not changing the needle doesn't move even though there is a new calculation.
@mursank2008
4 жыл бұрын
Super Sir
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@viper3636dr
5 жыл бұрын
OMG that is so cool. Thank you thank you.
@FAlqahtani
5 жыл бұрын
Great , thank you ♥️
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@yulinliu850
6 жыл бұрын
Thanks a lot for sharing!
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching
@sginnova
6 жыл бұрын
Very well done.
@PKAnExcelExpert
6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@yudafernando4376
5 жыл бұрын
Cara save setelah di buat bagaimana bos
@jonathanmarin6123
6 жыл бұрын
Hi is there a way i can have the vba code make the needle move incrementally (0% - data point) rather than it going directly to the data point?
@ReeteshGungadin
3 жыл бұрын
I was thinking about that too but i don't know how to do it.
@josephhorling6013
6 жыл бұрын
Hi PK, Can't seem to get my angle working. It keeps on going back to 0 degrees. Joe, Michigan.
@alirezamogharabi8733
6 жыл бұрын
Thanks a lot, I have a question! Every time i create a chart like this, i want to use that multiple times, but when i change data from select data, the color of chart changes, how to change data source of chart whit out changing the color of chart?
@marioalday5966
3 ай бұрын
The needle is not scalating with the remaining elements of the gauge. How can i set it to belong to the goup?
@naoma1993
6 жыл бұрын
tu é fantástico!!!!
@PKAnExcelExpert
6 жыл бұрын
Obrigado pelo seu valioso feedback
@shoryaarora1464
5 жыл бұрын
Awesome 👏🏻
@PKAnExcelExpert
5 жыл бұрын
Thanks for your valuable feedback
@Shriny100
6 жыл бұрын
So beautiful!!! Keep it up. Subscribing to your channel right away
@PKAnExcelExpert
6 жыл бұрын
Thanks Shrinivas, for watching and sharing your valuable feedback. And also thanks for subscribe my channel.
@abdulazeezpulikkool5316
6 жыл бұрын
Lovely, thank you PK
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@sonysudheesh8870
6 жыл бұрын
feet
@Esteebbo
6 жыл бұрын
To make the additional Speedo's, do you have to make them step by step again, or is there a simple way to reproduce them quickly (copy?) and modify the links?
@PKAnExcelExpert
6 жыл бұрын
Hi Stephen, You can copy it to make another Speedometer. Just keep needle group saparate and use this group name in VBA code Thanks for watching
@GouravKkhurana
5 жыл бұрын
For Needle Rotation, you have written one small VBA Code. Do we need to write such 3 different VBAs for 3 Speedometers? Kindly clarify.
@mdyusuf2007
Жыл бұрын
I m facing this issue? Any solution to this problem?
@BattleScar09
4 жыл бұрын
When I tried to run the script I get compile error, invalid use of property and it highlights the last active sheet line. Any reason why this would be?
@BattleScar09
4 жыл бұрын
All good I fixed it, typo
@ericiriarte2880
5 жыл бұрын
Lo único que no he visto en tu canal son gráficas con mapas
@pg7419
6 жыл бұрын
When I reference the cell that indicates the % for rotation it is a formula, however, when I update anything that in turn updates the percentage, it won't run the VBA rotation for the new number unless I click into any cell and then hit enter? How can I fix this?
@belindacoad7057
Жыл бұрын
what do you do if data is on one sheet and dials are on another?
@topfundus1093
Жыл бұрын
Danke, super!
@PKAnExcelExpert
Жыл бұрын
Sehr willkommen
@SAMalik-ts7fy
6 жыл бұрын
Excellent
@sicsubbu
6 жыл бұрын
Good info
@PKAnExcelExpert
6 жыл бұрын
Thanks for your valuable feedback
@sicsubbu
6 жыл бұрын
PK: An Excel Expert Actual last 2 weeks before only found your videos in KZitem during searching excel videos.. Easy to understand and learn many things by practising with our data. This speedometer was long time search..today fulfill ..suggesting your videos to others ...
@PKAnExcelExpert
6 жыл бұрын
Thanks Subramanian for your valuable feedback. Your words will work like power booster for me and will create more innovative videos on excel. Thanks for your support to my channel.
@4uchinnu
Жыл бұрын
What is group 10 and how can I link specific cell in my file
@SD-bq5uk
2 жыл бұрын
Sir the VB code tat you wrote it won't get saved.. Logic all works..wen the time comes as closing- it won't get saved..nd throw an error.. Kindly help..
@hgilbert9479
6 жыл бұрын
Any advice for creating speedometers for mins, hours, percentage and customer service rating? I have them created but the only one that will change correctly is the Service Level. The rest I have to change manually because the needle will not match. For example, the hours are set to 0-24 but if I select 2 it moves to 10. Any help will be appreciated! Thank You!
@henryleonrivera7385
4 жыл бұрын
Porqué cuando quiero ejecutar el código en VBA me sale que no encuentra la imagen?
@mrinalsinha9465
3 жыл бұрын
I am unable to move the speedometer needle when using slicer
@huunguyen1831
6 жыл бұрын
Hi, I done 1st piece and it's run very well. Then I tried with the 2nd & 3rd but it's not workI am not good at VBA so I think I got wrong code. Could you please share the code for 2nd and 3rd in the same worksheet?Here is my VBA 1st code:Private Sub Worksheet_Change(ByVal Target As Range)ActiveSheet.Shapes.Range(Array("Group 11")).Select Selection.ShapeRange.Rotation = Range("A4").Value * 243 ActiveCell.SelectEnd Sub
@martytag
5 жыл бұрын
I am having the same problem, cant figure out how to get the additional ones to work properly
Пікірлер: 204