Create Speedometer Chart In Excel

  Рет қаралды 1,163,198

My E-Lesson

My E-Lesson

11 жыл бұрын

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 жыл бұрын
I've never seen anyone so excited about Excel in my life. Great tutorial.
@annfesu3639
@annfesu3639 7 жыл бұрын
Thisssssssssssssssss :D so much excitement
@michelleh2702
@michelleh2702 5 жыл бұрын
So cute!!
@rnnayak1352
@rnnayak1352 4 жыл бұрын
Very nice
@tawseefgullgull280
@tawseefgullgull280 4 жыл бұрын
@@michelleh2702 , , Z ,
@nasebear
@nasebear 9 жыл бұрын
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!
@VibhoreGupta
@VibhoreGupta 9 жыл бұрын
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.
@karlrodriguez
@karlrodriguez 6 жыл бұрын
its incredible the excitement that you transmit with this tutorial, looking forward to start the lessons with your course
@bodaciousbuilds8890
@bodaciousbuilds8890 8 жыл бұрын
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 жыл бұрын
+Charles Edwards Thanks!! i was facing this problem
@leighrushbrook7101
@leighrushbrook7101 8 жыл бұрын
+Charles Edwards THANKS! Was having this issue. Much appreciated.
@bonsaiforu
@bonsaiforu 8 жыл бұрын
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 7 жыл бұрын
thanks. i have the same issue about the pointer. (: great.. really great.. never expected that we can do more about excel....
@winpins9539
@winpins9539 6 жыл бұрын
@Charles Edwards This doesn't work for me. It hides the first chart and I'm left with ONLY the pointer. :(
@ofps2
@ofps2 10 жыл бұрын
Es una de las mejores creaciones que he visto utilizando Excel. Felicitaciones excelente video.
@xswooshx
@xswooshx 7 жыл бұрын
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.
@fammnak852
@fammnak852 9 жыл бұрын
had a rough day; but your video made my day! "chart is so cool.. so fun.." haha thank you so much.
@jslanempo
@jslanempo 10 жыл бұрын
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
@shaolinmaster6362
@shaolinmaster6362 8 жыл бұрын
I like how happy you sound while creating this file!!! haha loved it!
@DenisIgua
@DenisIgua 9 жыл бұрын
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: )
@SurendranNambiath
@SurendranNambiath 5 жыл бұрын
WoW!! Thanks for the Tutorial Guru, this old(ish) 'Exceler' has learnt an awesome Magic Trick! I like your style and passion too, dude!!👌👍
@sdscottie5
@sdscottie5 10 жыл бұрын
This is FANTASTIC!! Thanks so much - easy to do and your approach was easy to understand. Thank you!
@23gundo
@23gundo 3 жыл бұрын
Thank's! I was looking for this to make a BMI chart. Your approach is genius and I love your enthousiasm!
@GuruJii
@GuruJii 11 жыл бұрын
Learn MS ‪#‎excel‬| Advanced Level Course | Class 13 |Create a Speedometer In Excel !|kzbin.info/www/bejne/nGfGamZjm7afedU
@MarkZabel
@MarkZabel 8 жыл бұрын
Love your enthusiasm brother!
@GuruJii
@GuruJii 8 жыл бұрын
Welcome Dear, you can watch all my videos on www.myelesson.org
@sanddiemonot444
@sanddiemonot444 5 жыл бұрын
I agree : thank you not only for the tutorial but for your great spirit and laughs !
@Scott93312
@Scott93312 2 жыл бұрын
9 Years later and you're still teaching people awesome tricks in your videos. Also, I love your enthusiasm!
@ChrisKade98
@ChrisKade98 10 жыл бұрын
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.
@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)
@entertainmentanalyst1559
@entertainmentanalyst1559 4 жыл бұрын
you're not just informative but quite enthusiastic as well. this actually helps in concentration
@markburke9578
@markburke9578 Жыл бұрын
Had to go through it step by step in my own example, but finally got there with it. Very useful
@heatherangelus5992
@heatherangelus5992 9 жыл бұрын
I really enjoyed this lesson. Thank you so much for sharing!
@GuruJii
@GuruJii 9 жыл бұрын
Heather Angelus Welcome :)
@TheWonderfulWino
@TheWonderfulWino 10 жыл бұрын
You Sir . . . are the Master!! Thank You for sharing.
@vparthiban
@vparthiban 10 жыл бұрын
Guru Ji... You are awesome. Can't imagine the innovation you have come up. Thanks for sharing...
@exwhyz33
@exwhyz33 10 жыл бұрын
Jolly teacher !! Easily doubles up as a Performance Indicator indicator.
@waterboy12342232
@waterboy12342232 8 жыл бұрын
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
@musiciansgym243
@musiciansgym243 10 жыл бұрын
GuruJi: You are not only very informative, you are also hilarious!!!! Thanks a bunch!!!!
@vr6954
@vr6954 4 жыл бұрын
Ur smiling face... Makes excel very easy
@jaiporje1153
@jaiporje1153 4 жыл бұрын
This is super. Loved the excitement with which you explained the entire process.
@KrishnaKumar-zn9kg
@KrishnaKumar-zn9kg 8 жыл бұрын
Superb. I agree that your enthusiasm is contagious! Loved it. Thanks. Krishna
@GuruJii
@GuruJii 8 жыл бұрын
+Krishna Kumar Welcome , you can also watch all my videos on www.myelesson.org
@danahashcroft9482
@danahashcroft9482 7 жыл бұрын
I have never had an excel tutorial brighten my day. Thanks! and now i have sweet condition graphs
@GuruJii
@GuruJii 7 жыл бұрын
:)
@notesfromleisa-land
@notesfromleisa-land 9 жыл бұрын
Loved your enthusiasm and your exposition of this technique. Thanks very much.
@PrashanthSadashivan
@PrashanthSadashivan 7 жыл бұрын
Your enthusiasm is infectious. You have an amazingly fetching voice- I think you could easily provide voiceovers for advertisements :)
@KrishAgr
@KrishAgr 10 жыл бұрын
Wonderful Guru. Like how the simple chart is converted into a fun chart.
@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!
@abiola5757
@abiola5757 3 жыл бұрын
The happiest lesson I have ever come across...well done
@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.
@thomassankara6105
@thomassankara6105 3 жыл бұрын
Fantastic tutorial and great to see an enthusiastic host! thank you!
@gustavmartinask3409
@gustavmartinask3409 5 жыл бұрын
Love your enthusiasm! Thanks for a great tutorial!
@processfitness
@processfitness 9 жыл бұрын
Hi, This was great! At 6:15 in the video the Change Type Chart will look different in Excel 2013. It lets you select which chart to change. If you don't select the chart then it will replace your existing chart. Thank you. It is really great.Question: What formula did you use to get the pointer values to change automatically summing up to 100?
@sudhakarshankar
@sudhakarshankar 7 жыл бұрын
Excellent Lessen :) Thanks a lot pal. So well described, feels very easy now.
@kashinathbnatikar5909
@kashinathbnatikar5909 6 жыл бұрын
tumba channagide sir I mean soooo super
@debmat6
@debmat6 6 жыл бұрын
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 жыл бұрын
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.
@luisguillermolarottac5352
@luisguillermolarottac5352 8 жыл бұрын
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
@jayantachakrabarti2153
@jayantachakrabarti2153 10 жыл бұрын
so good to see ur so enthusiastic way of teaching and talking in such a nice manner. keep it up.cheers.
@Apogeezies
@Apogeezies 7 ай бұрын
A very informative video. I really enjoyed the humor of the video instructor; the humor made a mundane topic interesting!
@alicevix7489
@alicevix7489 6 жыл бұрын
What a joy to watch. If I ever meet you, I'll give you a hug!!
@couponlover93
@couponlover93 6 жыл бұрын
I really enjoyed your enthusiasm. Made me smile cause I was excited too! LOL
@patrickv1693
@patrickv1693 4 жыл бұрын
Fantastic! Thank you for sharing your knowledge and enthusiasm.
@joypuente472
@joypuente472 10 жыл бұрын
Hi Michael! I was finally able to get it to work! I changed the pie chart to a column chart first. I was hoping to do something with the secondary axis. I ended up not changing anything, but when I changed it back to the pie chart it was not longer hidden!
@mauermouse
@mauermouse 9 жыл бұрын
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.
@francopietrozearo4486
@francopietrozearo4486 9 жыл бұрын
I really enjoyed your video! Thank you so much for sharing. What software did you use to shoot the video tutorial?
@labohoulet
@labohoulet 8 жыл бұрын
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
@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
@vthakur83
@vthakur83 3 жыл бұрын
thank You so much ...admired the way You teach , very energetic ..I have created my speedo meter , following the steps :)
@mllx5adb
@mllx5adb 9 жыл бұрын
This is amazing - thank you so much!! Really impressed
@chrisfigel2420
@chrisfigel2420 6 жыл бұрын
Great stuff. Using Excel 2016, I couldn't get the needle to stay in the pie chart format, but it sort of worked as to donuts.
@SebastianRamirez-rw5iy
@SebastianRamirez-rw5iy 7 жыл бұрын
You are a freaking genius , thanks for the tutorial, was amazing.
@titonegombo
@titonegombo 7 жыл бұрын
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.
@adisboggy289
@adisboggy289 9 жыл бұрын
your lesson is awesome and funny too, it's sounds like excell is not complicated stuff...thanks bro
@mikespocket
@mikespocket 7 жыл бұрын
This is so clever. Indeed it is awesome. Thank you. Love your enthusiasm..
@amitthakur3941
@amitthakur3941 4 жыл бұрын
Sir ...first of all...Nice to explain your colloquial and things ...valuable vedio for me....thanks.
@satyavijay4913
@satyavijay4913 6 жыл бұрын
You love your job, i love it. that was a great explanation - Easy to understand and very easy to create one. cant resist subscribing... :)
@GuruJii
@GuruJii 6 жыл бұрын
Welcome dost :)
@aiishasoudha77
@aiishasoudha77 10 жыл бұрын
Good sense of humour; very much appreciated!!!
@saimanojkumar
@saimanojkumar 4 жыл бұрын
Fantastic video tutorial. it was very easy to follow and do it. Love your style.
@sudarshanmurali6642
@sudarshanmurali6642 7 жыл бұрын
very excited and interactive way of teaching. super and all the best for all ur future teachings
@Nabiletsanaa
@Nabiletsanaa 8 жыл бұрын
Very well presented and easy to build - a nice way to motivate people to learn. Thanks for the valuable demonstration,
@GuruJii
@GuruJii 8 жыл бұрын
Thank you : )
@Bruv327
@Bruv327 9 жыл бұрын
This is such an awesome lesson. You are so happy and enthusiastic. Well done Bro
@GuruJii
@GuruJii 9 жыл бұрын
Bruv327 Thanks :)
@amitjoshi8997
@amitjoshi8997 Жыл бұрын
Sir you are owesome 🙏🙏. Charan sparsh I have learned this from you as a guru 🙏
@ZafarWaheed
@ZafarWaheed 7 жыл бұрын
Dude, I love the style, so interacting and entertaining ... Thumbs Up.
@softwareguide7246
@softwareguide7246 6 жыл бұрын
You are a great teacher. Awesome tutorial!
@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.....
@krummb
@krummb 6 жыл бұрын
God, lol, I love how much fun he is having as he makes this.
@Malaphisis
@Malaphisis 10 жыл бұрын
thanks bro, appreciate this video. to move the needle to the front right click, series options, plot series on. when in doubt right click.
@gregs_garage
@gregs_garage 8 жыл бұрын
soooo fun sooo fun to make!
@sharuk66
@sharuk66 6 жыл бұрын
Speedometer functions with explanation kzbin.info/www/bejne/hqCXY2msodp4has
@alexluckas8437
@alexluckas8437 8 жыл бұрын
I love your style of presentation and really really neat speedometer!
@GuruJii
@GuruJii 8 жыл бұрын
Thank you
@niccoc1603
@niccoc1603 7 жыл бұрын
dude the way you are so happy is awesome
@GuruJii
@GuruJii 7 жыл бұрын
Thank you, Please visit www.myelesson.org to watch all of my training videos.
@rachsoxfan
@rachsoxfan 9 жыл бұрын
Good lesson. I'm having trouble with the pointer showing through the red/yellow/green. Ahhhh, after scrolling through the comments, I see the remark to change to 'secondary axis'. Thank you for this information, good stuff!
@kumaresanchinnamani8268
@kumaresanchinnamani8268 5 жыл бұрын
Very nicely explained. Hats off to you Sir.... Gr8. Thank you very much
@bonitabanana9342
@bonitabanana9342 2 жыл бұрын
Thank you so much! Your demo and expkanation is easy to understand and follow
@ISpy2G
@ISpy2G 9 жыл бұрын
Thank you! It's beautiful, and I thought it was awesome you were having such a great time :) Careful with the background noise when recording.
@GuruJii
@GuruJii 9 жыл бұрын
***** Welcome and thanks Friend :)
@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
@TheGar1ma
@TheGar1ma 4 жыл бұрын
This is amazing! Thank you so much
@rakeshknight
@rakeshknight 5 жыл бұрын
Excellent tutorial video ! Thank you !
@oulag
@oulag 10 жыл бұрын
Guru ji...Thanks a lot for teaching an awesome chart in a very brilliant way.
@GuruJii
@GuruJii 10 жыл бұрын
You are welcome
@GuruJii
@GuruJii 11 жыл бұрын
I am glad that you liked them : )
@wgconsultants3030
@wgconsultants3030 7 жыл бұрын
I really enjoy your passion for this!
@soilblack1992
@soilblack1992 9 жыл бұрын
I am so happy to hear your happy teach voice. good job buddy
@electricus_aniruddhachanda8184
@electricus_aniruddhachanda8184 Жыл бұрын
Really its stunning . Hats off Sir.
@V_Dubya
@V_Dubya 8 жыл бұрын
Brilliant video. You've got a great presentation style!
@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.
@opoku-mensahotuo
@opoku-mensahotuo 8 жыл бұрын
Fantastic!!Keep up the good work.
@sulaimansafdar8491
@sulaimansafdar8491 7 жыл бұрын
this is amazing.. seriously.. thank you so much for sharing the knowledge.
@GuruJii
@GuruJii 7 жыл бұрын
Thank you, Please visit www.myelesson.org to watch all of my training videos.
@nochacharles3673
@nochacharles3673 Ай бұрын
Had fun listening to you made it interesting and easy.
@brookeboatright2360
@brookeboatright2360 10 ай бұрын
YOU SAVED THE DAY! Thank you so much!!!
@danielawagner9853
@danielawagner9853 Жыл бұрын
Wow, thanks for this great tutorial!!!
@Olumide.Oyalola
@Olumide.Oyalola 10 жыл бұрын
Very informative. Many Thanks
@sumithraas
@sumithraas 8 ай бұрын
it is really amazing. thank you very much. when i tried, it all came very well except the data labels. for "pointer" all three segments are showing values (value, pointer and end). i'm unable to get data labels only for "value" on the pointer
@alphabeta01
@alphabeta01 11 жыл бұрын
Liked your videos. Easy to follow and practice. Thanks for sharing.
Create Pareto Chart In Excel
9:02
My E-Lesson
Рет қаралды 421 М.
Как бесплатно замутить iphone 15 pro max
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 8 МЛН
UNO!
00:18
БРУНО
Рет қаралды 1,6 МЛН
Nastya and SeanDoesMagic
00:16
Nastya
Рет қаралды 38 МЛН
Эффект Карбонаро и нестандартная коробка
01:00
История одного вокалиста
Рет қаралды 10 МЛН
How to Create STUNNING Speedometer Chart Template in PowerPoint
12:23
Presentation Process
Рет қаралды 84 М.
Half Circle KPI info graphic chart
9:47
PK: An Excel Expert
Рет қаралды 111 М.
Speedometer Chart in Excel 2019
11:08
My E-Lesson
Рет қаралды 48 М.
Learn Vlookup Formula For Beginners in Excel
7:50
My E-Lesson
Рет қаралды 1,3 МЛН
Ultimate Speedometer in Excel: Part 1
15:58
PK: An Excel Expert
Рет қаралды 349 М.
How to Create a Gauge Chart in Excel
15:00
ExcelDemy
Рет қаралды 2,4 М.
Make Speedometer Chart in Excel Hindi
11:57
My E-Lesson
Рет қаралды 4,9 М.
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 211 М.
Как бесплатно замутить iphone 15 pro max
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 8 МЛН