Thank you, it was very helpful, I practice on sample data and it works but
when I apply it to my own data, I have a problem with the labels on the
x-axis. I'm using a
xy scatter chart, and I have date from Aug 2004 to Feb 2005, and it's not
showing that it shows, whatever 1900, and I don't know how to change it.
It's plottign the dta ajust fine, but the x-axis display is so wrong. My
chart is not in the same page with the data ii's on a shhet on it's own. Any
ideas of why is this happening?
Thank you
"John Mansfield" wrote:

tiw,

This article explains how to make a 13 month trend dynamic trend chart. You
could easily modify the instructions to include 90 periods instead of 13.

http://pubs.logicalexpressions.com/p...cle.asp?ID=518

----
Regards,
John Mansfield
http://www.pdbook.com



"tiw" wrote:

I'm trying to create a chart that automatically will chart the last 90
entries of a list of information (containing only numbers) without having to
change the range every time. Please any suggestions????