The example near the bottom of this page:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

shows how to use a slider to control which data is charted. Ignore that my
example uses dates, and just set it up for whatever units your X-axis uses.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"unique" <unique@discussions.microsoft.com> wrote in message
news:6B8AA09D-3FE5-4C5C-AAD5-DA547355A75A@microsoft.com...
> Hello, I want to create a chart, which has a slider, and when the slider
> is
> constantly clicked the area under a curve from a chart starts
> progressively
> being coloured (filled) until it reaches the end of the curve and the end
> of
> the slider. How can create these types of charts.
>
> regards