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
