rolling data

I have a spreadsheet which requires people to add another piece of data
every day. It is plotted into a chart. What I want is for the chart to
use only the last 20 columns or so for the chart. How can I do this?
(I am not familiar with Macros, but could pick it up if needed.)

thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/