![]() |
How do I create a slider bar in Excel to control data input?
When the slider is clicked on and moved back and forth, different input data
is selected for graphing a function. For example, for y = mx + b, moving the slider inputs different values for x (and/or b) which causes a graph of the function to change in real time. It is a great way to see how a variable affects the value of a function. |
How do I create a slider bar in Excel to control data input?
Are you asking how, or telling us how?
If you're asking, this article shows how to use sliders to control dynamic charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "P-15" wrote in message ... When the slider is clicked on and moved back and forth, different input data is selected for graphing a function. For example, for y = mx + b, moving the slider inputs different values for x (and/or b) which causes a graph of the function to change in real time. It is a great way to see how a variable affects the value of a function. |
All times are GMT +1. The time now is 06:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com