PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?UC0xNQ==?=
Guest
Posts: n/a
 
      5th Apr 2006
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
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      5th Apr 2006
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" <P-(E-Mail Removed)> wrote in message
news:9274D27D-6923-4D0D-9CD9-(E-Mail Removed)...
> 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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a box where I can input data =?Utf-8?B?RGF2aWQ=?= Microsoft Excel Worksheet Functions 0 5th Jun 2007 08:33 PM
How do I set up slider bars to input data in Excel? =?Utf-8?B?RWxmU3I=?= Microsoft Excel Worksheet Functions 1 2nd Apr 2007 08:41 PM
create report only if certain data is input =?Utf-8?B?RGFuaWVs?= Microsoft Access Reports 1 15th Aug 2006 08:01 PM
Losing focus on a slider control within a user control Israel Microsoft Dot NET 1 22nd Mar 2006 04:03 PM
Excel VBA - is there a multiple slider sliderbar control Marq Microsoft Excel Programming 0 9th Jun 2004 03:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:53 AM.