View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Choosing last set of data in column

Consider putting your most recent data at the top of the column (pushing
older data down) instead of the bottom.

That way you will always know where the last five sets are.
--
Gary''s Student - gsnu200727


"Erik" wrote:

How do I choose the last five sets of data in a column. I want to make a
chart that continually updates as I add in data but only with the last five
sets of data. Is this possible with "offset" and how would I do this?

Erik