Animated charts

[unique]

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

 

[Jon Peltier]

The example near the bottom of this page:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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]

The example near the bottom of this page:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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/
_______

Hello,

yes I understand whats on that sheet, but I still cant get it what I want it
to do. How do I make it so the colour under those lines, gets filled, from
clear as you press the slider.

regards

 

[Jon Peltier]

You need to use an area chart series. It gets complicated to get the
vertical edge at the last selected point. However, I just remembered another
page on my web site:

http://peltiertech.com/Excel/Charts/XYAreaChart.html

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

 

[unique]

Hello,

Can you clarify the procedure to link the scroller with the chart. The first
link seems rather unclear.

regards

 

[Jon Peltier]

There are named ranges in the worksheet which change based on values in
cells (such as start date and end date). The chart uses these named ranges
as the X and Y data. The scroll bars are linked to the cells whose values
control the endpoints of the defined ranges.

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