Ultimate Speedometer in Excel: Part 1

Hello Friends,
This is the first 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 2
• Ultimate Speedometer i...
Download the excel file from below given link:
www.pk-anexcel...
Learn and free download best excel template:
• Excel Dashboards
Learn VBA with me:
• VBA Tutorial
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Follow me on Facebook:
/ pkan-excel-expert-9748...
Website:
www.PK-AnExcel...
Pinterest:
/ pkanexcelexpert
Telegram: t.me/joinchat/...
blogger: pk-anexcelexper...
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

[@fekrabusinesssolutions]

The idea of the double needle is brilliant. good job

[@PKAnExcelExpert]

Thanks

[@txpatriot7044]

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.

[@isaiasfranciscodasilva644]

Muito bom seu ensinamento, parabéns e continue com seus ensinamentos, que ajuda muitas pessoas pelo mundo afora.
obrigado
Forte abraço.

[@investofun9551]

Thanks a lot. Great education!

[@PKAnExcelExpert]

You are welcome!

[@123prenyvkmg]

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.

[@PKAnExcelExpert]

Thanks Vegen,
For watching and sharing your valuable feedback. Audience like you always encourage me to do something innovative in Excel.

[@vs9886]

+PK: An Excel Expert hi can send ur email or contact number plz

[@rajendersingh1133]

Thank you sir !! I got to learn a lot from you video!!

[@ricardo6606]

BEAUTIFUL!!! I LOVE IT.

[@PKAnExcelExpert]

Thank you! 😊

[@drawing_by_words]

You are creative and all your videos very beneficial, I am interesting to watching it always

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@ambajirao9523]

Thanks a lot!Excellent guidance to learn and explore new possibilities. I really did not know we could do so much.Very innovative.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@mamounawad9294]

Thank you Mr. PK ... Very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anonymouse2141]

My favourite CZcams channel

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RJG-Studios]

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.

[@pattheitguy]

Might I suggest using text transform? This will allow you to draw text around the curved shapes..

[@JoseBarahonaes]

Thank you!. From El Salvador.

[@PKAnExcelExpert]

Thanks for watching

[@larrymweetwa5783]

AM YOUR BIG FAN FROM UK, KEEP UP THE GOOD JOB DO MORE EXCEL STAFF

[@PKAnExcelExpert]

Thanks for valuable feedback. Audience like you always encourage me to do something innovative in Excel.
Thanks for your support to my channel.

[@nadermounir8228]

Found it ! Geeat tutorial

[@PKAnExcelExpert]

Thanks🙏

[@onkar8775]

Awesome video dude. You put a lot of effort to make this. Thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@obegodson]

Very helpful tutorial; thank you.

[@PKAnExcelExpert]

Glad it was helpful!

[@thebesttechnical3608]

Very good and informative video

[@narenderkumar-personal1234]

Superb..appricieate your efforts...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@g3sty1]

Great video and works well
How have you got VBA to not show the connection dots when the % number is changed?

[@justmboung7112]

Merci

[@PKAnExcelExpert]

Très bienvenu

[@anniechen9083]

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?

[@jonevans5704]

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.

[@aansuwandi]

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..

[@PKAnExcelExpert]

Hi Aan,
Please see below video. It may help you to understand how to use scrollbar with chart
czcams.com/video/Krsr0tSx6jk/video.html

[@topfundus1093]

Danke! Super!

[@PKAnExcelExpert]

Sehr willkommen

[@7RQ89]

Kumar Nice work !

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ihsanbaig2235]

An excellent contribution, cheers!!!

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@elshanmehdiyev6474]

great vid. Will definitely use it!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JeffersonAlvesDadosCriativos]

Tooooooooooopppp greeeeat job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@qualitechinternational6477]

very smart thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@molaken]

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.

[@ajayjoshi2408]

Sir
Rather than doing this paintbrush work, there should be some automatic way of doing it
any ways good efforts taken

[@carlosjavierbardalez6171]

You are the best!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SuperDavidFz]

Parabens Professor por esta mas uma excelente aula.

[@PKAnExcelExpert]

Agradeco os seus valiosos commentarios

[@SuperDavidFz]

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

[@PKAnExcelExpert]

Obrigado pela linda palavra Devid.
Continue assistindo ... continue aprendendo

[@briankennedy31]

Hi. Fantastic tutorial. Jut wondering if you would know how to do the same speedometer but with a range of -1 to +1 ?

[@mauricioreyes1761]

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?

[@girishh5471]

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 .

[@dennisn2324]

Thank you - you're amazing

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@yanivnativ]

Thank you, can you send one please

[@ejaz-ul-haque4691]

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.

[@kevintaylor788]

Please could you help stop the needle going past 100% when the result is greater than 100

[@rajeshangamuthu6106]

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...

[@Todotienesolucion8370]

Congratulation exelent chanel

[@PKAnExcelExpert]

Thanks for the watching and sharing your valuable feedback

[@zelfiroze]

Thank you. I hope you keep producing such vdo :)

[@PKAnExcelExpert]

Thanks for watching

[@MANJEET19891189]

Great Video.. thanks for sharing.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@MAQXDS]

Sir Is there any way to show negative values on speedometer graph?

[@navyamounika23]

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?

[@commonmansfitness882]

Amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AnandMishrahapy2helpu]

Awesome ...... Realy Nice

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@hasenchaudhry3787]

Excellent Video - Cheers. How can I download the excel file? There is no link in the description for the excel file.

[@PKAnExcelExpert]

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"

[@sourabhsaxena3629]

This is very beautiful speedometer .
I just want to say can I get your this file ?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Download link has been given in videos description box of Part-2. Please download this excel file from there.

[@gavdownes100]

Very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ferma3279]

how can i change type chart
thanks.

[@ishtiaqhussainzaidi6703]

Hi Dear, hope you will be fine. I hv a problem, when i put the %age the speedometer dsnt work. Kndly help me plz.

[@faisalhspmed8666]

Excellent

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@dashrathsutar8615]

Kindly creat a chart what consume less time

[@michaelcenter7379]

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?

[@aidaanzivino3551]

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...

[@vikramreddy303]

I am unable to group it please explain clearly

[@pa2happiness13]

💞👌

[@ycaroovoador7744]

👍👍👍👍👍👍

[@roderickwilliform]

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?

[@PKAnExcelExpert]

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.

[@dinuachar]

Bro first u learn n get confidence then you can teach others... Goodluck

[@garya2680]

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?

[@PKAnExcelExpert]

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.

[@garya2680]

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

[@PKAnExcelExpert]

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.

[@garya2680]

So what would the new line of code be? I really can't get it to work. Thanks

[@PKAnExcelExpert]

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

[@brahmanandbakkannavar348]

Please remove background Music/sound

[@amaturetrader1393]

Can u please drop this spedometer download link

[@PKAnExcelExpert]

Excel download link has been given in Part-2 of this video's discretion box. Please download this excel file from there.

[@irviantantohaditomo8917]

Can you share the ms excel spread to me? Many thanks

[@PKAnExcelExpert]

Excel file link has been given in videos discretion box. Please download this excel file from there.
Thanks for watching.

[@notwrong6028]

Omg, so complicating, people won't be so much time to do all this. Give them the format

[@nitinbangera9348]

hi sir

[@nitinbangera9348]

can u help me out in hr mis

[@nitinbangera9348]

wat u have done in sales na i want to do in same format for hr

[@alisharifi7781]

Your learning completed wring because for one small learning you making 2 3 videos very very but completely confusing learning.

[@Faeemworld]

You Pakistani?

[@sureshteam1114]

I wasted 15 mins of my time