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.
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
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!
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?
Master Job.. Keep it up with new ones.
Great
Outstanding. Instructions very clear, love the polish and detail and *especially* the conditional formatting - amazing!
Great video.
Amazing...
Thanks for sharing with us your experience ! Very nice tutorial. Step by step. Appreciated !
Thanks for your appreciation!
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.
Nicely presented and well explained. Great stuff, thanks.
Good tutorial
Hello , Great explanation it was very helpful, Keep the good work up
Thank you very muck dear bro from Somalia keep this good task to your people
Thanks for your feedback and support!
nicely done! I subscribed because it was so good
What an excellent Excel hack!!
🤔🤗😁
Thanks! Please like and share.
Great graphic. Great explanation! Thank you.
Thanks for your appreciation!
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.
This was very helpful, thanks a lot!
Thanks for your feedback!
Thank you!
Thank you so very much!
Respect!
Thanks!
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!
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.
😍😁😀
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?