PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
How do I create a slider bar in Excel to control data input?
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
How do I create a slider bar in Excel to control data input?
![]() |
How do I create a slider bar in Excel to control data input? |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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/...icle.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" <P-15@discussions.microsoft.com> wrote in message news:9274D27D-6923-4D0D-9CD9-F269F825D3CF@microsoft.com... > 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. |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

