**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

Can you please share your sheet

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

with added row

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

okay, can you please explain

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

thanks, can you please help me using offset

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