Hi,
I have a spreadsheet with approximately 20 columns of numerical data (including some blank cells) which I update with more daily values every couple of days. One of the columns is the date. There are around 800 data-points in each column.
I use offset and counta to define the ranges of the columns which means my line and scatter charts update automatically as I input more data:
OFFSET('Sheet 1'!$K$4,0,0,COUNTA('Sheet 1'!$K:$K)-1)
I want to somehow automatically select the last 30 data points to use in the charts, I want these 30 data points to automatically update as I add more data. Is there a formula I can use to do this, or do I need to visit the world of VBA?
Thanks
Bob
Bookmarks