Rolling dynamic data range

  • Thread starter Thread starter SueD
  • Start date Start date
S

SueD

I have 2 adjacent columns of data that my chart is based
on. This data is continually expanding downwards. I want
my chart to always reflect the bottom 10 rows of data
without having to manually change the source references
each time. Using a named worksheet range I can get it to
dynamically start at the top and go to the bottom of the
range, but cannot get it to start at the bottom and count
back 10 rows.
 
Hi Sue
try the following dynamic range (assumption: no blank rows in between9:
=OFFSET($A$1,COUNTA($A:$A)-10,0,10)
define a name for this range and use this in your chart

HTH
Frank
 
Back
Top