View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
asmithbcat asmithbcat is offline
external usenet poster
 
Posts: 12
Default Only Include Last Four Entries in a Chart

I have a very simple chart that I am putting together on a weekly basis. I
want the chart to show only the last four entries, but I do not want to
update the source data every time I need a new chart. However, I want a
historical record of the data, so I don't want to delete any entries.

Is there a way to set up the source data so that it only pulls the last four
entries in a specific range?