Moving average

[Guest]

How do I drop the oldest data point and add the newest data point in a 90 day market chart which plots the daily prices of a mutual fund so that I can apply various moving average trend lines?

 

[Andy Pope]

Hi PJP,

You need to use named ranges.

Have a look at Jon's example of dynamic charting.
(http://peltiertech.com/Excel/Charts/DynamicLast12.html)

or Tushar's Dynamic Charts page on his site,
(http://www.tushar-mehta.com/)

How do I drop the oldest data point and add the newest data point in a 90 day market chart which plots the daily prices of a mutual fund so that I can apply various moving average trend lines?

--

Cheers
Andy

http://www.andypope.info