Trying to produce a graph with a dynamic range. Excel sheet is linked to Access data base with data populated daily. I only want to graph the last 10 rows (days) of data. I've tried using the following OFFSET formulas for my axis ranges but I keep getting "function is not valid".
=OFFSET(‘Azone MTTR MF’!$A:$A,COUNTA(‘Azone MTTR MF’!$A:$A) -10,0,10,1)
The following formula gives me same "function is not valid", but when I select OK when I get the error, it takes me back to the table and re-highlight the last 10 rows instead of the entire row.
=OFFSET('AZone MTTR MF'!$A$2, ROWS(Table_AZone_DTR_MF.accdb)-10, 0, 10, 1)
NOTE: Excel is linked to access database. Data and graph are on separate sheets within same workbook
=OFFSET(‘Azone MTTR MF’!$A:$A,COUNTA(‘Azone MTTR MF’!$A:$A) -10,0,10,1)
The following formula gives me same "function is not valid", but when I select OK when I get the error, it takes me back to the table and re-highlight the last 10 rows instead of the entire row.
=OFFSET('AZone MTTR MF'!$A$2, ROWS(Table_AZone_DTR_MF.accdb)-10, 0, 10, 1)
NOTE: Excel is linked to access database. Data and graph are on separate sheets within same workbook