Rolling dynamic data range

[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.

 

[Frank Kabel]

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

 

[Jon Peltier]

Sue -

This page has a dynamic chart example that charts the last 12 months of
data. It wouldn't take much to adapt to your needs.

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon

 

[SueD]

Thank very much - with your help I've cracked it now