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
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
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.
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.
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: ua-cam.com/video/h3R1X_4qPIo/v-deo.html ua-cam.com/video/RdggIFkIBW4/v-deo.html
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.
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?
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.
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.
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?
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..
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?
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?
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.
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
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?
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!
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.
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.
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!
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
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.
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?
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.
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
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
I wonder if anyone can help me, I have gotten the dial to work with a cell reference as the video shown. However when i try and link a formula to that reference cell the dial does not update? Do i need to add anything different to the VBA?
I have downloaded your excel sheet, and it still doesn't work when the active cell has a formula in it. So the speedo only works on set values or if the values are manually added in!
Hi Nevlen, The event of macro is on "Change“ in worksheet events. You can change it as per your requirements. Make sure Excel calculation should be AUTOMATIC and macros should be enabled.
I am having issue with the code. I am trying to have all my data exist on sheet 2 (Data). Sheet 1 has my Speedo's (Dashboard). When I update the data in sheet 2 the speedo will not move. The numerical value under the speedo does based on percentage, but the speedo does not. Any help?
Hi Harry, Since your data is on sheet 2, plase check the below things: 1- change event should be on sheet2 (data sheet) 2-make sure you have used proper sheet name before shapes rotation code. 3- Proper sheet should be used before Range value code. I hope it will help you. Thanks for watching
Thank you for replying PK! I made the modifications and now am getting a Compile error: Sub or Function not defined, and the top line of code is yellow. Here is my code if it helps. Also to reiterate.. my data is on sheet 2 but I am formulating over to sheet one in Cell B3 which is in the code. Private Sub Worksheet_Change(ByVal Target As Range) Worksheet("Dashboard").Shapes.Range(Array("Group 17")).Select Worksheet("Dashboard").Selection.ShapeRange.Rotation = Worksheet ("Dashboard") .Range("B3").Value * 255 ActiveCell.Select End Sub
Try this code... change Sheet2 and with your second sheet nameWorksheet("Dashboard").Shapes("Group 17").Rotation = Worksheet ("Sheet2") .Range("B3").Value * 255
Koi jabab hi nhi hai Bhai saab 1 number 👌👌
Thanks for your valuable feedback
Superb bro you done created awesome, i did for same for three speed meters
Thank you very much sir, kindness last forever
Thanks for your valuable feedback
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.
Thanks for your valuable feedback
Thank you for your videos. They are so very helpful.
Glad you like them!
Parabéns meu amigo, você é uma referência em excel pra mim.
You're THE MAN!
Thank you
Thanks
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!
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
Awesome job, you do a terrific job instructing also thank you very much!
Thanks for your valuable feedback
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
¡Excelente, eres un mago de Excel! Gracias por compartir tus conocimientos
Thanks for your valuable feedback
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?
Great work, PK. Thanks for taking the time to share your knowledge.
Thanks for your valuable feedback
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.
Amazing. Thumbs up.
Thanks for your valuable feedback
Awesome video. Just what I needed! Thank you PK
Glad it helped!
Thanks a lot. Great education!
Glad you enjoyed it!
Uma solução muito bacana sem precisar usar gráficos. Muito criativo! Parabéns!
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.
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:
ua-cam.com/video/h3R1X_4qPIo/v-deo.html
ua-cam.com/video/RdggIFkIBW4/v-deo.html
The first video he says this was created without using any charts
Hi, can you help me with this? I'm trying your method thx
Very Good! Thank you for sharing your knowledge in Excel!
Thanks for your valuable feedback
Fantastic. Thank you for the time. This is an excellent tool.
Impressive Excel !!! Great work !!! Tks you!!! Graet work Master!!!
Thanks for your valuable feedback.
Very nice looking for this for a long time
Thanks for watching
This is Awesome! Thanks for putting this stuff up!
Thanks for your valuable feedback
Please could you advise, can the speedometer be made without VBA?
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.
Thanks for watching and sharing your valuable feedback.
amzing.tnx
Namste and shourkryia : excellent, uo're my champion !!!
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?
ur the best! u even make this available to download blessings men appreciated
Thanks for your valuable feedback
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.
The needle is not scalating with the remaining elements of the gauge. How can i set it to belong to the goup?
What is group 10 and how can I link specific cell in my file
Bhai awesome! Subscribed...
Thanks for your valuable feedback
what do you do if data is on one sheet and dials are on another?
VERY CREATIVE
Thanks🙏
file still available? Could not download....
Absolutely great job!
Thanks for watching and sharing your valuable feedback
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.
Hi PK, Can't seem to get my angle working. It keeps on going back to 0 degrees. Joe, Michigan.
Porqué cuando quiero ejecutar el código en VBA me sale que no encuentra la imagen?
Cara save setelah di buat bagaimana bos
Excellent. Thank you very much
Thanks for your valuable feedback
As viewers, Sumeet ji should teach us Politics. A Super-charged analyst
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?
I was thinking about that too but i don't know how to do it.
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?
Fantastic Thank you, Thank You
I take my hat off to you sir
Thanks for your valuable feedback. Request you to please share this with your friends and colleagues.
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..
great video how do you lock all the boxes and move the dial as one shape ? and while reducing the size of it :-)
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?
All good I fixed it, typo
I am unable to move the speedometer needle when using slicer
complicated especially with those macro.. but its all worth a subscription.. Good Job and Thanks
Thanks for watching and sharing your valuable feedback
This is fantastic! Is there a way to lock it all together so it can be moved as one once it is finished?
Also will the code change for the pointer once grouped together? Thank you so much!
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?
Mind Blowing....
Thanks for your valuable feedback
Desde México
Felicidades muy bien explicado y muy útil
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.
If I save the project and again open it not work how open again
PK... I am your fan... you are my friend now...
It is my pleasure Navdeep.
Thanks for your valuable support to my channel.
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?
I would like to know as I have been unable to recreate the 2nd and 3rd
Excellent video. Thanks
Thanks for your valuable feedback
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
I am facing same issue but no solution. P.K please help
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?
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!
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.
Thanks a lot!!
Most welcome
how use vlookup in many tables
great work always thanks you .
Thanks for your valuable feedback
good job
Thanks
Very nice for part 2 as well
Thanks for your valuable feedback
Danke, super!
Sehr willkommen
U r genius amazing video boss !!
Thanks for your valuable feedback
Goood Job ,can you share link to upload this template please
Thanks for your valuable feedback. Download link has been given in videos discretion box.
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.
Great Video PK can’t see your excel file though
sorry but i miss the macros on the downloaded workbook.
Hi can you teach me how to make Speedometer in -100 to 100 and connect to dashboard
thank you very much for the vedio and for the excel file
Thanks for your valuable feedback
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!
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
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.
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?
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
So far so good but I dont have a developer tab? How do I get one? Ok figured it out. GREAT video!!
Thanks for your valuable feedback.
For Needle Rotation, you have written one small VBA Code.
Do we need to write such 3 different VBAs for 3 Speedometers?
Kindly clarify.
I m facing this issue? Any solution to this problem?
Genius! Thanks
Thanks for your valuable feedback
this is excellent - well done
Thanks for your valuable feedback
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.
I have same problem. Is there any solution?? please advice ASAP
thank you sir, subscribed your channel please share the google drive link .
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/
Super Sir
Thanks for your valuable feedback
Excelent. Very good. Congratulations. You give me a good idea for my financial model un VBA Excel.
Thanks for your valuable feedback. Please share it with your friends and colleagues whoever is looking for excel and vba tutorials.
Thanks a lot for sharing. It is really wonderful and helpful
Thanks for watching and sharing your valuable feedback
Great tuto. Thank you.
tu é fantástico!!!!
Obrigado pelo seu valioso feedback
Awesome 👏🏻
Thanks for your valuable feedback
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
Thanks Santosh for nice words and your valuable feedback. Download link has been given in videos discretion box
Lovely, thank you PK
Thanks for your valuable feedback
feet
Thanks a lot for sharing!
Thanks for watching
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
I am having the same problem, cant figure out how to get the additional ones to work properly
I wonder if anyone can help me, I have gotten the dial to work with a cell reference as the video shown. However when i try and link a formula to that reference cell the dial does not update? Do i need to add anything different to the VBA?
Hi Please download this excel file from download link has been given in videos discretion box. I hope it will help you
I have downloaded your excel sheet, and it still doesn't work when the active cell has a formula in it. So the speedo only works on set values or if the values are manually added in!
Hi Nevlen,
The event of macro is on "Change“ in worksheet events. You can change it as per your requirements.
Make sure Excel calculation should be AUTOMATIC
and macros should be enabled.
OMG that is so cool. Thank you thank you.
I am having issue with the code. I am trying to have all my data exist on sheet 2 (Data). Sheet 1 has my Speedo's (Dashboard). When I update the data in sheet 2 the speedo will not move. The numerical value under the speedo does based on percentage, but the speedo does not. Any help?
Hi Harry,
Since your data is on sheet 2, plase check the below things:
1- change event should be on sheet2 (data sheet)
2-make sure you have used proper sheet name before shapes rotation code.
3- Proper sheet should be used before Range value code.
I hope it will help you.
Thanks for watching
Thank you for replying PK! I made the modifications and now am getting a Compile error: Sub or Function not defined, and the top line of code is yellow. Here is my code if it helps. Also to reiterate.. my data is on sheet 2 but I am formulating over to sheet one in Cell B3 which is in the code.
Private Sub Worksheet_Change(ByVal Target As Range)
Worksheet("Dashboard").Shapes.Range(Array("Group 17")).Select
Worksheet("Dashboard").Selection.ShapeRange.Rotation = Worksheet ("Dashboard") .Range("B3").Value * 255
ActiveCell.Select
End Sub
Try this code... change Sheet2 and with your second sheet nameWorksheet("Dashboard").Shapes("Group 17").Rotation = Worksheet ("Sheet2") .Range("B3").Value * 255
I will give it a shot, thank you!