View Single Post
  #1   Report Post  
Brandon
 
Posts: n/a
Default Rolling data table??

Does anyone know how to make a data table continually show the last part of
your data? I have about 3yrs of a data table for each month, and I am
wanting the chart and graph to show just the last 12mos each time I update
it. Is there a formula, rather than just adjusting the series values?

Thanks