Create Speedometer Chart In Excel

[@BrettWyrick]

I've never seen anyone so excited about Excel in my life. Great tutorial.

[@annfesu3639]

Thisssssssssssssssss :D so much excitement

[@michelleh2702]

So cute!!

[@rnnayak1352]

Very nice

[@tawseefgullgull280]

@@michelleh2702 , , Z ,

[@bodaciousbuilds8890]

If the pointer is behind the donut chart - click on the pointer on the chart, once it is selected, right click, choose "format data series", in the window that pops up, on series option tab at bottom choose "secondary axis" in the "plot series on". this brings the pointer forward

[@naagmani1]

+Charles Edwards Thanks!! i was facing this problem

[@leighrushbrook7101]

+Charles Edwards THANKS! Was having this issue. Much appreciated.

[@bonsaiforu]

Thank you so much. I was having this problem and you solved it for me. Thank you to the video poster and you both!

[@kennethrempis9165]

thanks. i have the same issue about the pointer. (: great.. really great.. never expected that we can do more about excel....

[@winpins9539]

@Charles Edwards This doesn't work for me. It hides the first chart and I'm left with ONLY the pointer. :(

[@nasebear]

I never like to add comments. That said, I really appreciated your tutorial and your personality. Many times, people are boring or long-winded. Your laughter is contagious. Please keep sharing with the world! My only critique was that I had to try a few times without understanding what I was doing wrong because I couldn't see my pointer. I finally realized my since data was much larger than yours, my needle Pointer value set at 1 was invisible, so I had to increase it to at least 50 to see it. (My end data value was 7250) So, for very high values/data, the pointer value should also be increased to compensate. Overall, this tutorial was fabulous and I can't wait to show my coworkers the graphic I made with your help! Have a fabulous day!

[@abe3125]

An amazing guide, a charming person, laughing and happy, at the same time and giving the right tools! This is the right way to guide! Come on, where's the next video?😀

[@Scott93312]

9 Years later and you're still teaching people awesome tricks in your videos. Also, I love your enthusiasm!

[@titonegombo]

You are a grate teacher ..most of the people doesn't like share his knowledge with others ...then your very special for me ...thanks your video ..

[@GuruJii]

Welcome Dear and thank you for the kind words.

[@debmat6]

I never imagined anyone to be more excited about excel than me....you are a legend

[@GuruJii]

Debbie Matthews Matthews Thank you sooo much dear.

[@VibhoreGupta]

It's so amazing the way you are taking so much pleasure in what you are doing and teaching. One perfect example of the person who loves his job! Was real fun watching the video!!! Thank you for uploading.

[@tiwarisantosh55]

Thank You very much sir.... With the help of your video I teach a lot of people associate with me in office as well as at home .... keep sharing.....

[@abiola5757]

The happiest lesson I have ever come across...well done

[@raguanand221]

sir...,your teaching style is very smart.....,

[@GuruJii]

Ragu anand Thanks

[@danahashcroft9482]

I have never had an excel tutorial brighten my day. Thanks! and now i have sweet condition graphs

[@GuruJii]

:)

[@darrenvickexcelsolutions7068]

Some people have enthusiasm and some have even more enthusiasm coupled with a layer of warmth that makes this video a greate training aid. There's more than just an Excel lesson here.

[@GuruJii]

Thank you for the kind words.

[@DenisIgua]

This is so great and indeed if this was how I was taught math at school- the sense of humor would make me a guru!! Thank you.

[@GuruJii]

Denis Igua Thanks for the kind words: )

[@kashinathbnatikar5909]

tumba channagide sir I mean soooo super

[@PrashanthSadashivan]

Your enthusiasm is infectious. You have an amazingly fetching voice- I think you could easily provide voiceovers for advertisements :)

[@Apogeezies]

A very informative video. I really enjoyed the humor of the video instructor; the humor made a mundane topic interesting!

[@waterboy12342232]

Perfect and speedy enough for a techy. I also enjoy his laugh! These charts are great for business data.

[@GuruJii]

+Charles Padera Thank you for the kind words :) you can watch all my videos on www.myelesson.org

[@musiciansgym243]

GuruJi: You are not only very informative, you are also hilarious!!!! Thanks a bunch!!!!

[@vr6954]

Ur smiling face... Makes excel very easy

[@disisalice]

What a joy to watch. If I ever meet you, I'll give you a hug!!

[@sanddiemonot444]

I agree : thank you not only for the tutorial but for your great spirit and laughs !

[@joemac4705]

Michael - read what joy said and try again. Change the pie chart to a needle chart, then back again to pie. Not sure why but it worked for me.

[@jayantachakrabarti2153]

so good to see ur so enthusiastic way of teaching and talking in such a nice manner. keep it up.cheers.

[@jslanempo]

Wow...I even got this to work in Excel for Mac through some trickery (copy/paste chart to insert second series, put first chart element to 50% transparency). Been looking at other ways of creating speedometer charts, and this is the best! Thank you!

[@neerajraonkr]

J. Scott Lane can you share it please

[@fammnak852]

had a rough day; but your video made my day! "chart is so cool.. so fun.." haha thank you so much.

[@maxkcng860729]

learned and entertained in the same time.. lol.. good job Mr. Nasir

[@GuruJii]

+Max NG Welcome

[@thomassankara6105]

Fantastic tutorial and great to see an enthusiastic host! thank you!

[@aiishasoudha77]

Good sense of humour; very much appreciated!!!

[@abigpeacheyadventure]

You deserve a comment just because of how happy you are about this! What a great video :)

[@GuruJii]

Thanks

[@entertainmentanalyst1559]

you're not just informative but quite enthusiastic as well. this actually helps in concentration

[@luisguillermolarottac5352]

I never enjoyed before a tutorial as much as I did with this one!! Thanks a lot

[@GuruJii]

+Luis La-Rotta Welcome, please visit www.myelesson.org for more videos

[@SurendranNambiath]

WoW!! Thanks for the Tutorial Guru, this old(ish) 'Exceler' has learnt an awesome Magic Trick! I like your style and passion too, dude!!👌👍

[@exwhyz33]

Jolly teacher !! Easily doubles up as a Performance Indicator indicator.

[@shaolinmaster6362]

I like how happy you sound while creating this file!!! haha loved it!

[@MarkZabel]

Love your enthusiasm brother!

[@GuruJii]

Welcome Dear, you can watch all my videos on www.myelesson.org

[@financewomania]

I know how to make only in power bi..Thanks to you..Now i know in excel too.

[@GuruJii]

+Shatakshi Gaur welcome dear

[@justathoughthere4808]

Very good and very simple by your instructions...thank you

[@GuruJii]

Just a thought here Welcome :)

[@LuisOreamuno]

Hearing you laugh while I'm worried about how to get this excel presentation in time put things into perspective for me that it's important to have fun with all of this. Thank you!

[@zaibunnisa2290]

I like this video so much .I learn something new about excel after watching your video.

[@GuruJii]

+Zaibun Nisa Thank you for the kind words :)

[@soilblack1992]

I am so happy to hear your happy teach voice. good job buddy

[@amitthakur3941]

Sir ...first of all...Nice to explain your colloquial and things ...valuable vedio for me....thanks.

[@KrishnaKumar-zn9kg]

Superb. I agree that your enthusiasm is contagious! Loved it. Thanks. Krishna

[@GuruJii]

+Krishna Kumar Welcome , you can also watch all my videos on www.myelesson.org

[@jmgeneroso9953]

thank you brother.. this is very helpful and informative and friendly way of teaching.. Great job and God bless you .. keep it up

[@vthakur83]

thank You so much ...admired the way You teach , very energetic ..I have created my speedo meter , following the steps :)

[@vparthiban]

Guru Ji... You are awesome. Can't imagine the innovation you have come up. Thanks for sharing...

[@sudarshanmurali6642]

very excited and interactive way of teaching. super and all the best for all ur future teachings

[@jaiporje1153]

This is super. Loved the excitement with which you explained the entire process.

[@PranishBhaskaran]

Wow... the way you explained was wonderful. Any dumb can easily follow, you are a great teacher. I wish if I had a teacher like you :). Thanks a lot for sharing your knowledge.

[@bonitabanana9342]

Thank you so much! Your demo and expkanation is easy to understand and follow

[@electricus_aniruddhachanda8184]

Really its stunning . Hats off Sir.

[@23gundo]

Thank's! I was looking for this to make a BMI chart. Your approach is genius and I love your enthousiasm!

[@ZafarWaheed]

Dude, I love the style, so interacting and entertaining ... Thumbs Up.

[@oulag]

Guru ji...Thanks a lot for teaching an awesome chart in a very brilliant way.

[@GuruJii]

You are welcome

[@alphabeta01]

Liked your videos. Easy to follow and practice. Thanks for sharing.

[@rajeevsrivastava4963]

hi sir Good evening I watch your video its really Good easy way to teach us. once Great thanks

[@GuruJii]

Welcome, you can watch all my videos at www.myelesson..org

[@brookeboatright2360]

YOU SAVED THE DAY! Thank you so much!!!

[@JafranHasanAdhuna-v9j]

Really needed it before my excel exam ❤

[@rakeshknight]

Excellent tutorial video ! Thank you !

[@alexluckas8437]

I love your style of presentation and really really neat speedometer!

[@GuruJii]

Thank you

[@segarello82]

Man .. you are great informer with a very exciting mood .. i learned from your video and applied it .. Easy and Fun .. Thank You

[@Bruv327]

This is such an awesome lesson. You are so happy and enthusiastic. Well done Bro

[@GuruJii]

Bruv327 Thanks :)

[@markburke9578]

Had to go through it step by step in my own example, but finally got there with it. Very useful

[@cly2007]

Very Good explanation!!! Congratulations!!!

[@rahmanihamidou6093]

you are very simple ,and your lesson's it' very easy , thank you Sir

[@kumaresanchinnamani8268]

Very nicely explained. Hats off to you Sir.... Gr8. Thank you very much

[@Nabiletsanaa]

Very well presented and easy to build - a nice way to motivate people to learn. Thanks for the valuable demonstration,

[@GuruJii]

Thank you : )

[@sdsatna]

this very effective and useful to learn excel great job

[@GuruJii]

+Sanjay Dubey Welcome , you can also watch all my videos on www.myelesson.org

[@mauermouse]

You really seem to be having fun in this lesson and I in turn had fun learning it. Thank you so much for both for sharing the knowledge and your joy in doing so.

[@TheWonderfulWino]

You Sir . . . are the Master!! Thank You for sharing.

[@TheJazzdevotee]

Way cool. This is a great way to show a status. Thanks for the video.

[@GuruJii]

***** Welcome

[@wgconsultants3030]

I really enjoy your passion for this!

[@charlyparker2003]

Keep up the good work. Can I go back in time, back to elementry school & have you as my teacher... I might have turned out to be a rocket scientiest!

[@GuruJii]

Thanks @charly parker for the kind words :)

[@marshmellow8881]

I like the enthusiasm 😂 thanks for this video 👍👍👍👏👏👏

[@softwareguide7246]

You are a great teacher. Awesome tutorial!

[@gardennss]

I found it so easy after watching your video Thanks

[@fatesu]

Thank bro. i managed to follow your steps and get it right

[@GuruJii]

Awesome !

[@fatesu]

try this . I implemented to my source code Function GaugeMeter(rng As Range) ' DrawGaugeMeter 'Application.ScreenUpdating = False Dim ActSheet As Worksheet Set ActSheet = ActiveSheet Dim chartTtitleValue As String Dim targetCellValue As Double Dim vtop As Integer Dim chartName As String If (rng.Count = 2) Then chartTtitleValue = Range(rng.Address).Cells(1) targetCellValue = Range(rng.Address).Cells(2) vtop = (rng.Row - 1) * 100 Dim chtObj As ChartObject 'Create a chart Set chtObj = ActiveSheet.ChartObjects.Add(Left:=100, Width:=100, top:=vtop, Height:=100) 'Give chart some data chtObj.Chart.ChartType = -4120 ' xlDoughnut chartName = "chart" + CStr(rng.Row) chtObj.name = chartName Dim s1 As Series Dim pts1 As Points Set s1 = chtObj.Chart.SeriesCollection.NewSeries With s1 .name = "Speedometer" .Values = Array(0, 2, 3, 5, 10) ' 5 points 'point 'start point , initial point, mid point, max point End With chtObj.Chart.ChartGroups(1).FirstSliceAngle = 271 Set pts1 = s1.Points pts1(1).Interior.ColorIndex = 3 ' red pts1(2).Interior.ColorIndex = 45 'amber pts1(3).Interior.ColorIndex = 4 ' green pts1(4).Interior.ColorIndex = 5 ' blue pts1(5).Interior.ColorIndex = 0 chtObj.Chart.HasTitle = True chtObj.Chart.ChartTitle.Text = chartTtitleValue chtObj.Chart.HasLegend = False Dim s2 As Series Dim pts2 As Points Set s2 = chtObj.Chart.SeriesCollection.NewSeries With s2 .name = "Pointer" .Values = Array(targetCellValue, 0.2, 10) ' 3 points 'valuer point , pointer marker point, max point End With Set pts2 = s2.Points s2.ChartType = 5 'xlPie s2.AxisGroup = 2 'xlSecondary chtObj.Chart.ChartGroups(2).FirstSliceAngle = 271 pts2(1).Interior.ColorIndex = 0 ' empty pts2(2).Interior.ColorIndex = 1 ' black pts2(3).Interior.ColorIndex = 0 ' empty pts2(2).HasDataLabel = True pts2(2).DataLabel.Text = targetCellValue pts2(2).DataLabel.Font.ColorIndex = 1 'black s2.HasLeaderLines = False ' Application.ScreenUpdating = True Else 'nothing Debug.Print "else" End If GaugeMeter = "" End Function

[@waynelloyd9672]

Great tutorial, simple to follow and it work really works well.

[@GuruJii]

Thanks @wayne

[@waynelloyd9672]

Hi Guru Ji, I have ben working with your data validation tutorial and wondered if I can take it a step further, I would like to add additional information but restrict it from being copied & pasted in to another cell by some one else. Is there a way this can be done. you help would be appreciated.

[@TheSign18]

I have learnt excel through tutorials, but I really liked the way u taught, in a friendly manner .... keep up the good work. Plus your voice is cool too ;) should start singing

[@GuruJii]

Welcome dear and thank you for the kind words.

[@notesfromleisa-land]

Loved your enthusiasm and your exposition of this technique. Thanks very much.

[@niccoc1603]

dude the way you are so happy is awesome

[@GuruJii]

Thank you, Please visit www.myelesson.org to watch all of my training videos.

[@couponlover93]

I really enjoyed your enthusiasm. Made me smile cause I was excited too! LOL

[@krummb]

God, lol, I love how much fun he is having as he makes this.

[@edwinruzive2213]

You are a star thanks for the video, a real eye opener

[@GuruJii]

Thanks edwin ruzive

[@johnsmith7742]

Thats Awesome Mate,,,, that's what I was looking for Years

[@GuruJii]

Welcome John : )

[@gustavmartinask3409]

Love your enthusiasm! Thanks for a great tutorial!

[@amitjoshi8997]

Sir you are owesome 🙏🙏. Charan sparsh I have learned this from you as a guru 🙏

[@KEEMxCHI]

I’m having trouble @6:56 where you double click to minimize the pie into a pointer shape - I don’t know why mine isn’t minimizing. Not sure if it’s because I upgraded to Windows 10. Could you please help? X

[@nochacharles3673]

Had fun listening to you made it interesting and easy.

[@saimanojkumar]

Fantastic video tutorial. it was very easy to follow and do it. Love your style.

[@walencarbr]

Congratulations ... Very funny and helpful

[@GuruJii]

William A :)

[@shaukatsamad2510]

I added in this Speedometer a spin Button n its work in place of value..... when I click the button its work, thx GOD..!!!!!

[@ChrisKade98]

Hi Guru, I very much appreciate what I learnt from this video. Thank you for sharing your knowledge and time to educate so many. Good Job and I wish you all the best.

[@kashinathbnatikar5909]

today from I'm Ur big fan I'm from Karnataka..

[@christopher2012ful]

Very useful and he made it simple... Thank you.

[@GuruJii]

I am glad that you liked them : )

[@WildlifeinHindi]

Superb super you are a greater man you really enjoy excel way of teaching awesome 👏👍❤❤

[@adisboggy289]

your lesson is awesome and funny too, it's sounds like excell is not complicated stuff...thanks bro

[@saleemsayaani]

i really love your way of laugh rather, and the way you teach is really soooooo lovely you are very rare rare species. veeeeeeeeery very good man you are

[@sdscottie5]

This is FANTASTIC!! Thanks so much - easy to do and your approach was easy to understand. Thank you!

[@mikespocket]

This is so clever. Indeed it is awesome. Thank you. Love your enthusiasm..