Animated charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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/
_______
Click to expand...




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
 
Hello,

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

regards
 
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/
_______
 
Back
Top