# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello, I have an excel data where I update one row (with multiple columns) each week. During plotting, I go back every n weeks (n rows) to generate average plot of each of these columns. It is difficult to manually choose n rows everytime I update a new row. Is there a way to automate this so that once I update a new row, a plot is automatically generated going back n rows from this new row? Thanks!
Solved by S. F. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/04/2018 - 09:35
Hi welcome to Gotit
Excelchat Expert 06/04/2018 - 09:35
User 06/04/2018 - 09:36
sure, let me make an arbitrary sheet to show the problem
Excelchat Expert 06/04/2018 - 09:36
ok
User 06/04/2018 - 09:42
Hi
Excelchat Expert 06/04/2018 - 09:42
yes
User 06/04/2018 - 09:43
in this document, let's say I have already generated a plot using C as X axis and B as Y axis
User 06/04/2018 - 09:43
now if I add another row
Excelchat Expert 06/04/2018 - 09:43
yes
User 06/04/2018 - 09:43
is there a way I can generate the same plot with same number of rows automatically
User 06/04/2018 - 09:44
meaning, it goes back to same number of rows each time I add a row
Excelchat Expert 06/04/2018 - 09:44
it same rows or with added row?
User 06/04/2018 - 09:44
User 06/04/2018 - 09:44
let's say I add another row after the existing ones now
User 06/04/2018 - 09:45
and want to have same 12 rows
User 06/04/2018 - 09:45
again
User 06/04/2018 - 09:45
but this time with the new row
Excelchat Expert 06/04/2018 - 09:45
oh
User 06/04/2018 - 09:46
is there a way to automate this, so I don't need to plot again everytime
Excelchat Expert 06/04/2018 - 09:47
I think there is a way
Excelchat Expert 06/04/2018 - 10:06
Hello
User 06/04/2018 - 10:06
yes
Excelchat Expert 06/04/2018 - 10:07
Using offset we can achieve this
User 06/04/2018 - 10:07
Excelchat Expert 06/04/2018 - 10:08
yes
User 06/04/2018 - 10:18
hello are you there
Excelchat Expert 06/04/2018 - 10:18
yes
User 06/04/2018 - 10:19
Excelchat Expert 06/04/2018 - 10:19
=OFFSET(B1,COUNTA(B1:B19),1,1,1)
User 06/04/2018 - 10:21
okay thank you
Excelchat Expert 06/04/2018 - 10:21
you have to use this in graph range
Excelchat Expert 06/04/2018 - 10:21
you know how to use them
User 06/04/2018 - 10:22
actually I dont know
Excelchat Expert 06/04/2018 - 10:22
Offset function make the data to move from column data
Excelchat Expert 06/04/2018 - 10:23
It help in adding the new row
User 06/04/2018 - 10:23
okay
Excelchat Expert 06/04/2018 - 10:33
Hello
User 06/04/2018 - 10:33
yes
Excelchat Expert 06/04/2018 - 10:33
Can you see the sheet
User 06/04/2018 - 10:33
yes
Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.