PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting How do I create a slider bar in Excel to control data input?

Reply

How do I create a slider bar in Excel to control data input?

 
Thread Tools Rate Thread
Old 05-04-2006, 03:22 AM   #1
=?Utf-8?B?UC0xNQ==?=
Guest
 
Posts: n/a
Default 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.
  Reply With Quote
Old 05-04-2006, 12:34 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: 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/...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.



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off