Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: continuously update scatter chart from scroll bars
Dear All,
In Excel 2007 I am using a scroll bar to input a range of data into a set of equations that feeds their answers to a scatter chart to be plotted. I would like the chart to be updated on each generated value as I scroll through the range of values I am interested in. Unfortunately, the scatter chart only updates on the final value sent from the slider to the equations, even though the equations are generating new points as I slide the scroll bar. My question is, how do I get Excel 2007 to continuously update a scatter chart from data originally generated by scroll bars and linked to the chart via an equation. Thank you in advance for your help. Jim S. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: continuously update scatter chart from scroll bars
A scrollbar from the controls toolbox updates continuously, while a scroller
from the forms toolbar only updates when you release it. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JimS." wrote in message ... Dear All, In Excel 2007 I am using a scroll bar to input a range of data into a set of equations that feeds their answers to a scatter chart to be plotted. I would like the chart to be updated on each generated value as I scroll through the range of values I am interested in. Unfortunately, the scatter chart only updates on the final value sent from the slider to the equations, even though the equations are generating new points as I slide the scroll bar. My question is, how do I get Excel 2007 to continuously update a scatter chart from data originally generated by scroll bars and linked to the chart via an equation. Thank you in advance for your help. Jim S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Scroll Bars | Excel Discussion (Misc queries) | |||
Both scroll bars missing in 2007 | New Users to Excel | |||
How do I show scroll bars and tabs in Excel 2007 | Setting up and Configuration of Excel | |||
I am trying to hide or display the scroll bars in Excell 2007. | Excel Discussion (Misc queries) | |||
adding scroll bars to a chart | Charts and Charting in Excel |