Very nice video, I like it very much. This looks very beautiful, very smart design. There is one problem, when this is built on a Windows computer it’s don’t look good any more on a Mac computer. These kinds of problems are more common between windows and mac. It seems that Microsoft finds it difficult to equalize these platforms.
That was an excellent work . For me tho video was fresh breath of air . It shows how the excel is powerful program for many uses if you are a profetional user of excel. Thank you very much for this excellent tutorial.
This is really cool. I love it and your other videos. Very informative. Is there a way to make this Ultimate Speedometer work for PowerPoint visualization? I like this pointed 'needle' better than when you use a tiny slice of a pie chart, which expands towards the outer edge. I would assume it is necessary to have some VBA code in PowerPoint to control the needle, based on a cell in Excel which could be either hidden or on another slide? Guidance would be greatly appreciated.
Thank for sharing nice video, can you please help me out to reset rotation, when needle is on 0 degree and actually in the rotation cell it's shows as 68 degree if i change that as Zero then needle position will be completely towards down .
Hi PK, thank you for all your video! They are amazingly cool. I have one question about this "Ultimate Speedometer". After I created it, whenever I changed my number, the speedometer didn't change unless I double clicked on an empty cell. Do you know why it is and how can I solve this problem?
Thank you PK, can you please share how to use excel 2010? I saw in another video you have also shown how to use tricks in excel 2010. I will appreciate it.
Hi Bro,, Awesome work,, However, if I make the values changing by connecting with my pivot or database table, then its not working as I have to literally make the changes manually in the cell c2/c3/c6 etc... how can I have this cell reference to other sheet or pivot or database etc...
If have a data in next sheet but I want to display speedometer in master sheet based on the data in the next sheet , how it is possible can any one can explain?
Sir I want to ask you an important question. I have prepared a simple speedometer in excel. i just want it to be shown on my desktop. i.e. i change my readings in excel file, close it, and the speedometer shown on the dashboard gets updated automatically.
Thanks for watching and sharing your valuable feedback. Excel download link has been given in videos discretion box of "Ultimate Speedometer in Excel: Part 2"
Hi PK. Working on the arrow/triangle. I am not able to make the value of zero at rotation zero. Instead mine is saying 151. How do I get the arrow to show zero and rotate from there?
How can I have the Speedometer update, if I am not entering the data directly into the cell? i am pulling the data from another worksheet in C2, C3 and C4 by "='Expenditure Detailed Data'!U2" formula, is there a code to update when the cell data change?
Hi RODERICK, This code is on worksheet change event. If you want update it from another sheet then please put the same code on worksheet activate event.
Hello, When the reference cell is a directly inputted number I can get this to work. However, I am having trouble making the needle turn if the reference cell contains a formula obtained value i.e. average of other cells. Please can you help?
Sorry, I think we have a miscommunication somewhere. I want the needle to turn based on a cell which equals the sum of a column. Currently it only seems to work if you directly type a value into the target. If the cell you want to be the target contains a formula e.g. sum(A1:A20) the needle will not turn. I downloaded the link starting "drive google.com" which opened up your version but it has the same issue. Any help would be most appreciated
Hi Gary, Put the some formula in place of value from where needle is linked and in the vba code the if condition for Target address. Take it in target.row and target. Column according to your range.
Hi Gary, Please use below given code. I am assuming your data is on range "A2:A20". Put the Sum("A2:A20") on rarnge C2. Change the Group10 with whatever the Group name in you workbook. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then If Target.Row >= 2 And Target.Row
The idea of the double needle is brilliant. good job
Thanks
Muito bom seu ensinamento, parabéns e continue com seus ensinamentos, que ajuda muitas pessoas pelo mundo afora.
obrigado
Forte abraço.
I built these and they look great. What I need is a video on how to manage them in power point or other display product.
Thanks a lot. Great education!
You are welcome!
BEAUTIFUL!!! I LOVE IT.
Thank you! 😊
Thank you Mr. PK ... Very helpful
Thanks for your valuable feedback
Thank you!. From El Salvador.
Thanks for watching
Found it ! Geeat tutorial
Thanks🙏
My favourite UA-cam channel
Thanks for your valuable feedback
Thank you sir !! I got to learn a lot from you video!!
Might I suggest using text transform? This will allow you to draw text around the curved shapes..
Superb..appricieate your efforts...
Thanks for your valuable feedback
Very helpful tutorial; thank you.
Glad it was helpful!
Very good and informative video
Danke! Super!
Sehr willkommen
Tooooooooooopppp greeeeat job
Thanks for your valuable feedback
Very nice video, I like it very much.
This looks very beautiful, very smart design.
There is one problem, when this is built on a Windows computer it’s don’t look good any more on a Mac computer. These kinds of problems are more common between windows and mac.
It seems that Microsoft finds it difficult to equalize these platforms.
Awesome video dude. You put a lot of effort to make this. Thanks.
Thanks for your valuable feedback
Merci
Très bienvenu
That was an excellent work . For me tho video was fresh breath of air . It shows how the excel is powerful program for many uses if you are a profetional user of excel. Thank you very much for this excellent tutorial.
Thanks Vegen,
For watching and sharing your valuable feedback. Audience like you always encourage me to do something innovative in Excel.
+PK: An Excel Expert hi can send ur email or contact number plz
Kumar Nice work !
Thanks for your valuable feedback
Thanks a lot!Excellent guidance to learn and explore new possibilities. I really did not know we could do so much.Very innovative.
Thanks for watching and sharing your valuable feedback
great vid. Will definitely use it!
Thanks for your valuable feedback
An excellent contribution, cheers!!!
Thanks for watching and sharing your valuable feedback
I have a problem adjusting the rotation degrees. When I put 0, the needle points to the 12:00 position. How do I fix this?
You are creative and all your videos very beneficial, I am interesting to watching it always
Thanks for watching and sharing your valuable feedback
You are the best!
Thanks for your valuable feedback
very smart thank you
Thanks for your valuable feedback
Thank you - you're amazing
Thanks for watching and sharing your valuable feedback
AM YOUR BIG FAN FROM UK, KEEP UP THE GOOD JOB DO MORE EXCEL STAFF
Thanks for valuable feedback. Audience like you always encourage me to do something innovative in Excel.
Thanks for your support to my channel.
Parabens Professor por esta mas uma excelente aula.
Agradeco os seus valiosos commentarios
Sou fãn do seu Canal e um dos principais seguidores. Que Deus te abençoe e continue compartilhando experiências. Abraço daqui de Cabo Verde
Obrigado pela linda palavra Devid.
Continue assistindo ... continue aprendendo
Great video and works well
How have you got VBA to not show the connection dots when the % number is changed?
Congratulation exelent chanel
Thanks for the watching and sharing your valuable feedback
This is really cool. I love it and your other videos. Very informative. Is there a way to make this Ultimate Speedometer work for PowerPoint visualization? I like this pointed 'needle' better than when you use a tiny slice of a pie chart, which expands towards the outer edge. I would assume it is necessary to have some VBA code in PowerPoint to control the needle, based on a cell in Excel which could be either hidden or on another slide? Guidance would be greatly appreciated.
Dear PK..your videos make my brain fly...now im looking for scrollable pivot graph...based on scroll bar selection...trying to use index..but stuck..
Hi Aan,
Please see below video. It may help you to understand how to use scrollbar with chart
ua-cam.com/video/Krsr0tSx6jk/v-deo.html
Awesome ...... Realy Nice
Thanks for watching and sharing your valuable feedback
Hi. Fantastic tutorial. Jut wondering if you would know how to do the same speedometer but with a range of -1 to +1 ?
Thank for sharing nice video, can you please help me out to reset rotation, when needle is on 0 degree and actually in the rotation cell it's shows as 68 degree if i change that as Zero then needle position will be completely towards down .
Great Video.. thanks for sharing.
Thanks for watching and sharing your valuable feedback
Sir
Rather than doing this paintbrush work, there should be some automatic way of doing it
any ways good efforts taken
Hi PK, thank you for all your video! They are amazingly cool. I have one question about this "Ultimate Speedometer". After I created it, whenever I changed my number, the speedometer didn't change unless I double clicked on an empty cell. Do you know why it is and how can I solve this problem?
Amazing
Thanks for your valuable feedback
Very nice
Thanks for your valuable feedback
Thank you PK, can you please share how to use excel 2010? I saw in another video you have also shown how to use tricks in excel 2010. I will appreciate it.
Excellent
Thanks for watching and sharing your valuable feedback
Thank you, can you send one please
Sir Is there any way to show negative values on speedometer graph?
Thank you. I hope you keep producing such vdo :)
Thanks for watching
Hi Bro,, Awesome work,, However, if I make the values changing by connecting with my pivot or database table, then its not working as I have to literally make the changes manually in the cell c2/c3/c6 etc... how can I have this cell reference to other sheet or pivot or database etc...
👍👍👍👍👍👍
Kindly creat a chart what consume less time
Please could you help stop the needle going past 100% when the result is greater than 100
how can i change type chart
thanks.
If have a data in next sheet but I want to display speedometer in master sheet based on the data in the next sheet , how it is possible can any one can explain?
💞👌
Sir I want to ask you an important question.
I have prepared a simple speedometer in excel.
i just want it to be shown on my desktop. i.e. i change my readings in excel file, close it, and the speedometer shown on the dashboard gets updated automatically.
Hi Dear, hope you will be fine. I hv a problem, when i put the %age the speedometer dsnt work. Kndly help me plz.
This is very beautiful speedometer .
I just want to say can I get your this file ?
Thanks for your valuable feedback. Download link has been given in videos description box of Part-2. Please download this excel file from there.
Excellent Video - Cheers. How can I download the excel file? There is no link in the description for the excel file.
Thanks for watching and sharing your valuable feedback. Excel download link has been given in videos discretion box of "Ultimate Speedometer in Excel: Part 2"
Hi PK. Working on the arrow/triangle. I am not able to make the value of zero at rotation zero. Instead mine is saying 151. How do I get the arrow to show zero and rotate from there?
Me too PK, I can't make the arrow to start at zero degrees. It does automatically becomes 233 degrees when I do rotate it...
How can I have the Speedometer update, if I am not entering the data directly into the cell? i am pulling the data from another worksheet in C2, C3 and C4 by "='Expenditure Detailed Data'!U2" formula, is there a code to update when the cell data change?
Hi RODERICK,
This code is on worksheet change event. If you want update it from another sheet then please put the same code on worksheet activate event.
I am unable to group it please explain clearly
Hello, When the reference cell is a directly inputted number I can get this to work. However, I am having trouble making the needle turn if the reference cell contains a formula obtained value i.e. average of other cells. Please can you help?
Hi Gary,
Please download this excel file from the link given in 2nd part of the video's discretion box. You can see the code and formula from there.
Sorry, I think we have a miscommunication somewhere. I want the needle to turn based on a cell which equals the sum of a column. Currently it only seems to work if you directly type a value into the target. If the cell you want to be the target contains a formula e.g. sum(A1:A20) the needle will not turn. I downloaded the link starting "drive google.com" which opened up your version but it has the same issue. Any help would be most appreciated
Hi Gary,
Put the some formula in place of value from where needle is linked and in the vba code the if condition for Target address. Take it in target.row and target. Column according to your range.
So what would the new line of code be? I really can't get it to work. Thanks
Hi Gary, Please use below given code. I am assuming your data is on range "A2:A20". Put the Sum("A2:A20") on rarnge C2. Change the Group10 with whatever the Group name in you workbook.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If Target.Row >= 2 And Target.Row
Can u please drop this spedometer download link
Excel download link has been given in Part-2 of this video's discretion box. Please download this excel file from there.
Can you share the ms excel spread to me? Many thanks
Excel file link has been given in videos discretion box. Please download this excel file from there.
Thanks for watching.
Bro first u learn n get confidence then you can teach others... Goodluck
Please remove background Music/sound
hi sir
can u help me out in hr mis
wat u have done in sales na i want to do in same format for hr
Omg, so complicating, people won't be so much time to do all this. Give them the format
Your learning completed wring because for one small learning you making 2 3 videos very very but completely confusing learning.
You Pakistani?
I wasted 15 mins of my time