I have a chart with data going back to 1998. This chart automatically
updates when i add new data. But, everytime i add new data, the chart
grows. How can I make my chart only account (visually) for the past
five years of data, yet still update? For example: I add a new year of
data to the chart, and the last year of data disapears from the chart.

I've tried using Data Validation and the drop down boxes, but it didn't
really work. please help.


--
jordanwho
------------------------------------------------------------------------
jordanwho's Profile: http://www.excelforum.com/member.php...o&userid=36241
View this thread: http://www.excelforum.com/showthread...hreadid=561552

jordanwho

You can do exactly what you want by creating a dynamic range name. here a
link to a page that shows you how to do it.

http://processtrends.com/pg_dynamic_charts.htm

...Kelly




"jordanwho" wrote
in message ...

I have a chart with data going back to 1998. This chart automatically
updates when i add new data. But, everytime i add new data, the chart
grows. How can I make my chart only account (visually) for the past
five years of data, yet still update? For example: I add a new year of
data to the chart, and the last year of data disapears from the chart.

I've tried using Data Validation and the drop down boxes, but it didn't
really work. please help.


--
jordanwho
------------------------------------------------------------------------
jordanwho's Profile:
http://www.excelforum.com/member.php...o&userid=36241
View this thread: http://www.excelforum.com/showthread...hreadid=561552