I need excel to only use the last 26 rows in a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large spreadsheet that has data in it that is entered weekly. I
would like for the chart to grab the most recent 26 weeks of data
automatically. Does anyone know of a formula that will do this?
 
Logan:

If you haven't already, you may want to establish dynamic ranges for your
data set. This will allow you to automatically update your chart(s) as new
data is entered It will also allow you to plot the last number of days/weeks
that you want.

This post explains how to set up dynamic range names and plot user specified
number of days. It should get you started on dynamic range names and offset
formulas.

http://processtrends.com/pg_dynamic_charts.htm

(e-mail address removed)
 
Back
Top