View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.