Create Speedometer Chart In Excel

Поделиться
HTML-код
  • Опубликовано: 18 май 2013
  • Create Speedometer Chart In Excel, Download link bit.ly/2GWi6i0 a Doughnut chart and Pie Chart is used in order to accomplish the speedometer graph.
    Watch the video for more details on how to create a speedometer chart in excel
    10 Most Used Formulas MS Excel
    • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners || Part 1
    • Learn Basic Excel Skil...
    10 Most Used Excel Formula
    • 10 Most Used Excel For...
    *Most Imporant Excel Formuls Tutorials*
    Learn Vlookup Formula For Beginners in Excel
    • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews
    • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel
    • Create Speedometer Cha...
    Learn the Basic of Excel for Beginners || Part 2
    • Learn the Basic of Exc...
    Create Pareto Chart In Excel
    • Create Pareto Chart In...
    How to Create Dashboard in Excel
    • How to Create Dashboar...
    Excel Interview Questions & Answers
    • Excel Interview Questi...
    To watch more videos and download the files visit : www.myelesson.org
    To Buy a Excel Course visit :www.myelesson.org/product 10 Most Used Formulas MS Excel
    • 10 Most Used Formulas ...
    Learn Basic Excel Skills For Beginners || Part 1
    • Learn Basic Excel Skil...
    10 Most Used Excel Formula
    • 10 Most Used Excel For...
    *Most Imporant Excel Formuls Tutorials*
    Learn Vlookup Formula For Beginners in Excel
    • Learn Vlookup Formula ...
    5 Excel Questions Asked in Job Interviews
    • 5 Excel Questions Aske...
    Create Speedometer Chart In Excel
    • Create Speedometer Cha...
    Learn the Basic of Excel for Beginners || Part 2
    • Learn the Basic of Exc...
    Create Pareto Chart In Excel
    • Create Pareto Chart In...
    How to Create Dashboard in Excel
    • How to Create Dashboar...
    Excel Interview Questions & Answers
    • Excel Interview Questi...

Комментарии • 687

  • @BrettWyrick
    @BrettWyrick 7 лет назад +272

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

  • @nasebear
    @nasebear 9 лет назад +11

    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!

  • @GuruJii
    @GuruJii  11 лет назад +3

    Learn MS ‪#‎excel‬| Advanced Level Course | Class 13 |Create a Speedometer In Excel !|ruclips.net/video/f6c93-fQlCs/видео.html

  • @VibhoreGupta
    @VibhoreGupta 9 лет назад +7

    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.

  • @sanddiemonot444
    @sanddiemonot444 5 лет назад

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

  • @Scott93312
    @Scott93312 2 года назад +3

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

  • @ofps2
    @ofps2 10 лет назад

    Es una de las mejores creaciones que he visto utilizando Excel. Felicitaciones excelente video.

  • @bodaciousbuilds8890
    @bodaciousbuilds8890 8 лет назад +47

    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
      @naagmani1 8 лет назад +1

      +Charles Edwards Thanks!! i was facing this problem

    • @leighrushbrook7101
      @leighrushbrook7101 8 лет назад +1

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

    • @bonsaiforu
      @bonsaiforu 8 лет назад +1

      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
      @kennethrempis9165 6 лет назад

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

    • @winpins9539
      @winpins9539 6 лет назад +1

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

  • @fammnak852
    @fammnak852 9 лет назад +3

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

  • @entertainmentanalyst1559
    @entertainmentanalyst1559 4 года назад

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

  • @abiola5757
    @abiola5757 3 года назад

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

  • @karlrodriguez
    @karlrodriguez 6 лет назад

    its incredible the excitement that you transmit with this tutorial, looking forward to start the lessons with your course

  • @markburke9578
    @markburke9578 Год назад

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

  • @23gundo
    @23gundo 3 года назад

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

  • @shaolinmaster6362
    @shaolinmaster6362 8 лет назад +3

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

  • @sdscottie5
    @sdscottie5 10 лет назад

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

  • @TheWonderfulWino
    @TheWonderfulWino 10 лет назад +1

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

  • @DenisIgua
    @DenisIgua 9 лет назад +5

    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
      @GuruJii  9 лет назад

      Denis Igua Thanks for the kind words: )

  • @exwhyz33
    @exwhyz33 10 лет назад +1

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

  • @SurendranNambiath
    @SurendranNambiath 5 лет назад +2

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

  • @MarkZabel
    @MarkZabel 8 лет назад +6

    Love your enthusiasm brother!

    • @GuruJii
      @GuruJii  8 лет назад

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

  • @aiishasoudha77
    @aiishasoudha77 10 лет назад

    Good sense of humour; very much appreciated!!!

  • @waterboy12342232
    @waterboy12342232 8 лет назад +1

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

    • @GuruJii
      @GuruJii  8 лет назад

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

  • @debmat6
    @debmat6 6 лет назад +3

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

    • @GuruJii
      @GuruJii  6 лет назад

      Debbie Matthews Matthews Thank you sooo much dear.

  • @darrenvickexcelsolutions7068
    @darrenvickexcelsolutions7068 7 лет назад +1

    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
      @GuruJii  7 лет назад

      Thank you for the kind words.

  • @notesfromleisa-land
    @notesfromleisa-land 9 лет назад

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

  • @shaukatsamad2510
    @shaukatsamad2510 6 лет назад

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

  • @danahashcroft9482
    @danahashcroft9482 7 лет назад +1

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

  • @titonegombo
    @titonegombo 7 лет назад +1

    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
      @GuruJii  7 лет назад

      Welcome Dear and thank you for the kind words.

  • @gustavmartinask3409
    @gustavmartinask3409 5 лет назад

    Love your enthusiasm! Thanks for a great tutorial!

  • @jaiporje1153
    @jaiporje1153 4 года назад

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

  • @KrishAgr
    @KrishAgr 10 лет назад +4

    Wonderful Guru. Like how the simple chart is converted into a fun chart.

  • @vparthiban
    @vparthiban 10 лет назад +1

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

  • @thomassankara6105
    @thomassankara6105 3 года назад

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

  • @ameliakusar9136
    @ameliakusar9136 5 лет назад

    what a lifesaver, thank you so much for this tutorial! Your joy and enthusiasm also MADE MY DAY!!! I want to show this to some of my students who say "I can't make excel sound exciting in a presentation." :0)

  • @brookeboatright2360
    @brookeboatright2360 9 месяцев назад

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

  • @xswooshx
    @xswooshx 7 лет назад +1

    Nice tutorial! Thanks for making it!
    As a side note, my pointer got stuck behind the main chart. But, reformatting it to be on the secondary axis remedied that.

  • @heatherangelus5992
    @heatherangelus5992 9 лет назад +3

    I really enjoyed this lesson. Thank you so much for sharing!

    • @GuruJii
      @GuruJii  9 лет назад

      Heather Angelus Welcome :)

  • @alicevix7489
    @alicevix7489 5 лет назад

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

  • @jslanempo
    @jslanempo 10 лет назад +1

    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
      @neerajraonkr 5 лет назад

      J. Scott Lane can you share it please

  • @patrickv1693
    @patrickv1693 4 года назад

    Fantastic! Thank you for sharing your knowledge and enthusiasm.

  • @PrashanthSadashivan
    @PrashanthSadashivan 7 лет назад +1

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

  • @SebastianRamirez-rw5iy
    @SebastianRamirez-rw5iy 7 лет назад

    You are a freaking genius , thanks for the tutorial, was amazing.

  • @couponlover93
    @couponlover93 5 лет назад

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

  • @musiciansgym243
    @musiciansgym243 10 лет назад +8

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

    • @vr6954
      @vr6954 4 года назад

      Ur smiling face... Makes excel very easy

  • @ChrisKade98
    @ChrisKade98 10 лет назад +1

    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.

  • @mllx5adb
    @mllx5adb 9 лет назад

    This is amazing - thank you so much!!
    Really impressed

  • @luisguillermolarottac5352
    @luisguillermolarottac5352 8 лет назад +2

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

    • @GuruJii
      @GuruJii  8 лет назад

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

  • @amitjoshi8997
    @amitjoshi8997 11 месяцев назад

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

  • @kashinathbnatikar5909
    @kashinathbnatikar5909 6 лет назад +1

    tumba channagide sir I mean soooo super

  • @PranishBhaskaran
    @PranishBhaskaran 7 лет назад

    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.

  • @sudhakarshankar
    @sudhakarshankar 7 лет назад

    Excellent Lessen :) Thanks a lot pal. So well described, feels very easy now.

  • @LuisOreamuno
    @LuisOreamuno 4 года назад

    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!

  • @mikespocket
    @mikespocket 7 лет назад

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

  • @labohoulet
    @labohoulet 8 лет назад +1

    Thank you a lot! God bless you! You improve my EXCEL practice.

    • @GuruJii
      @GuruJii  8 лет назад

      +Luc Armand BOHOULET Welcome, please visit www.myelesson.org for more videos

  • @kumaresanchinnamani8268
    @kumaresanchinnamani8268 4 года назад

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

  • @amitthakur3941
    @amitthakur3941 3 года назад

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

  • @Olumide.Oyalola
    @Olumide.Oyalola 10 лет назад +1

    Very informative. Many Thanks

  • @rakeshknight
    @rakeshknight 5 лет назад

    Excellent tutorial video ! Thank you !

  • @tiwarisantosh55
    @tiwarisantosh55 11 лет назад

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

  • @mauermouse
    @mauermouse 9 лет назад +1

    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.

  • @bonitabanana9342
    @bonitabanana9342 2 года назад

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

  • @Apogeezies
    @Apogeezies 6 месяцев назад

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

  • @jmgeneroso9953
    @jmgeneroso9953 Год назад

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

  • @danayl1781
    @danayl1781 8 лет назад +1

    Excelent Video. Excelent Profesor.

  • @vthakur83
    @vthakur83 3 года назад

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

  • @krummb
    @krummb 6 лет назад +4

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

  • @KrishnaKumar-zn9kg
    @KrishnaKumar-zn9kg 8 лет назад +3

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

    • @GuruJii
      @GuruJii  8 лет назад +1

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

  • @rjsankarful
    @rjsankarful 9 лет назад +1

    Excellent job, thank you.

  • @softwareguide7246
    @softwareguide7246 6 лет назад

    You are a great teacher. Awesome tutorial!

  • @jayantachakrabarti2153
    @jayantachakrabarti2153 9 лет назад

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

  • @christopher2012ful
    @christopher2012ful 7 лет назад

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

  • @hannelynchavez5410
    @hannelynchavez5410 8 лет назад +1

    i'm soo excited to use this for presentations

  • @jenniferevans6371
    @jenniferevans6371 9 лет назад

    Love your laugh! Thanks for the help!

  • @MG425555
    @MG425555 5 лет назад

    Thank you so much, great tutorial!

  • @electricus_aniruddhachanda8184

    Really its stunning . Hats off Sir.

  • @adisboggy289
    @adisboggy289 9 лет назад

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

  • @manueln2104
    @manueln2104 6 лет назад

    You are Cool Man! I loved this lesson! Simply Excellent!

  • @3054509
    @3054509 9 лет назад

    My best compliments...great!

  • @gregs_garage
    @gregs_garage 8 лет назад +17

    soooo fun sooo fun to make!

    • @sharuk66
      @sharuk66 6 лет назад

      Speedometer functions with explanation
      ruclips.net/video/Po426vluEOI/видео.html

  • @kseniaivanova1568
    @kseniaivanova1568 3 года назад

    just beautiful! thank you!

  • @soilblack1992
    @soilblack1992 9 лет назад

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

  • @danielawagner9853
    @danielawagner9853 Год назад

    Wow, thanks for this great tutorial!!!

  • @auraatendido8008
    @auraatendido8008 10 лет назад

    Thank you! This is very helpful.

  • @dianewescott804
    @dianewescott804 6 лет назад

    Love it! Thank you!!

  • @GuruJii
    @GuruJii  11 лет назад +1

    I am glad that you liked them : )

  • @natraj6716
    @natraj6716 8 лет назад

    Thank you sir for letting me know how to create speedometer:)

  • @prashantshinde4222
    @prashantshinde4222 3 года назад

    It solved my problem to great extent. Thanks

  • @joemac4705
    @joemac4705 10 лет назад

    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.

  • @TheGar1ma
    @TheGar1ma 4 года назад

    This is amazing! Thank you so much

  • @pedrocotta8320
    @pedrocotta8320 Год назад

    Excellent video. Thanks.

  • @ZafarWaheed
    @ZafarWaheed 6 лет назад

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

  • @segarello82
    @segarello82 7 лет назад

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

  • @tejvarma4621
    @tejvarma4621 11 месяцев назад

    Pure soul Happy Person ❤😊

  • @donks5306
    @donks5306 7 лет назад

    Great video, I love your enthusiasm!

  • @robertdufour2456
    @robertdufour2456 7 лет назад

    So cool! I appreciate your enthusiasm

  • @rahmanihamidou6093
    @rahmanihamidou6093 7 лет назад

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

  • @saimanojkumar
    @saimanojkumar 4 года назад

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

  • @fiddleywest3778
    @fiddleywest3778 3 года назад +1

    Love This Thank you so much!!!

  • @opoku-mensahotuo
    @opoku-mensahotuo 8 лет назад +1

    Fantastic!!Keep up the good work.