How to Create 3D Speedometer Chart in Excel
ฝัง
- เผยแพร่เมื่อ 8 มิ.ย. 2018
- Please watch this video to learn how to make a beautiful 3D Speedometer Chart in Excel. Also, how to add Conditional Formatting on Chart.
#3DSpeedoMeter
Thanks for Watching!
Please like, share, subscribe and share.
Have a good day!
Outstanding. Instructions very clear, love the polish and detail and *especially* the conditional formatting - amazing!
Good tutorial
Nicely presented and well explained. Great stuff, thanks.
Amazing...
Master Job.. Keep it up with new ones.
Thanks for sharing with us your experience ! Very nice tutorial. Step by step. Appreciated !
Thanks for your appreciation!
Great video.
Great
Very well done. I learned a ton ... not just about how to make a gauge, but about shape and object formatting, in general. Thanks.
Thanks for your appreciation! Please subscribe our channel.
Great graphic. Great explanation! Thank you.
Thanks for your appreciation!
Thank you so very much!
Hello , Great explanation it was very helpful, Keep the good work up
What an excellent Excel hack!!
🤔🤗😁
Thanks! Please like and share.
Thank you very muck dear bro from Somalia keep this good task to your people
Thanks for your feedback and support!
This was very helpful, thanks a lot!
Thanks for your feedback!
nicely done! I subscribed because it was so good
Thank you!
Hello . I have a data table with 10 columns in Excel and I want to display two separate ranges of this table in a listbox form. For example, the first five columns and the last two columns. Thank you for your guidance.
Respect!
Thanks!
Hi there. Great demo! However I want to create a gauge to show variable blood sugar levels. The ranges that I need are: Poor - 8.3 mmol/l to 14.5 Good: 7 mmol/l to 8.2 and Excellent :1 to 6.9. Any help would be much appreciated!
Please kindly provide download link for this tutorial. Thanks for sharing.
Thank you sharing. I have one query regarding display of percentage, currently it is showing only value of rectangular shape . Can you give dynamic solution for this. Thanks
You can link the text box with any cell value. That will work dynamically. Thanks!
😍😁😀
Thanks! Please like, subscribe and share.
sir i need speedometer in range between -15 to 15 so pls help . how to input value
Hi! Do you know what this song is?
Please share the link to download
First of all, your lecture is informative. However, I really would like your assistance about the speedometer in a different manner.
Supposing that I want to apply your speedometer but in two colors: one is red and the other is green. The red will be for below values and green will be for above values (both in %). The needle will be in the middle. I want to ensure that this needle to stay fixed on zero% as an actual performance. And make an equation that states anything below 0 (in minus value%) should be within the red color vise versa for the green. Also, I want to make a condition that either both values exceeded their limits, I don’t want the needle to exceed on the last points of the meters.
For example to illustrate my point, range values for green is between 1% to 250% (if the performance value is more than 250%, the needle will not point beyond green and it will stay green) vise versa for red but in minus.
Is it possible to be done without VBA & Macros?