Thread: My chart automatically updates, but how can i keep it within a static date range????
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
jordanwho jordanwho is offline
external usenet poster
  
Posts: 1
Default My chart automatically updates, but how can i keep it within a static date range????

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

Reply With QuoteReply With Quote