Hello Friends,
This is the second and last part of “Ultimate Speedometer” tutorial. In this video you will how to create a speedometer chart in dial shape without using of image or any chart.
Watch Ultimate Speedometer in Excel: Part 1
Download the excel file from below given link:
Learn and free download best excel template:
Learn VBA with me:
Watch the best info-graphics and dynamic charts from below link:
Website:
Facebook:
Pinterest:
Telegram:
Twitter:
************* Suggested Books *********
VBA:
Excel Dashboard:
Power Query:
Power Pivot and Power BI:
Exam Ref 70-778 (Power BI):
************* My Stuff ****************
Mic :
Video Editor:
The needle is not scalating with the remaining elements of the gauge. How can i set it to belong to the goup?
sorry but i miss the macros on the downloaded workbook.
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.
Thanks a lot!!
As viewers, Sumeet ji should teach us Politics. A Super-charged analyst
I use to follow your tips, but somehow, you are to fast and jump to other tricks without explaining anything.
Thank you for your videos. They are so very helpful.
Thank you for your videos. They are so very helpful.
What is group 10 and how can I link specific cell in my file
Danke, super!
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
Thanks a lot. Great education!
what do you do if data is on one sheet and dials are on another?
VERY CREATIVE
If I save the project and again open it not work how open again
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?
Awesome video. Just what I needed! Thank you PK
good job
file still available? Could not download….
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 🙂
💞👌
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.
You're THE MAN!
Thank you
👍👍👍👍👍👍
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.
Parabéns meu amigo, você é uma referência em excel pra mim.
Dhang se Hindi bol le bhai, English nhi aati toh
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!
This is Awesome! Thanks for putting this stuff up!
So far so good but I dont have a developer tab? How do I get one? Ok figured it out. GREAT video!!
Thank you very much sir, kindness last forever
Superb bro you done created awesome, i did for same for three speed meters
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