Hi everyone,
I have a chart that gets updated weeky, currently i am updating it manually but would like to have it update automatically if possible. I not sure how to do this any help would be appreciated. The formula for the chart at the moment is below.
=SERIES('Defects Total'!$A$72,'Defects Total'!$C$39:$N$39,'Defects Total'!$C$72:$N$72,1)
=SERIES('Defects Total'!$A$71,'Defects Total'!$C$39:$N$39,'Defects Total'!$C$71:$N$71,2)
The table the info is coming from is from (A40:N79) each week the chart needs to get the data from the last 2 rows with data in them, then the chart show the difference from current week & previous week.
I have a chart that gets updated weeky, currently i am updating it manually but would like to have it update automatically if possible. I not sure how to do this any help would be appreciated. The formula for the chart at the moment is below.
=SERIES('Defects Total'!$A$72,'Defects Total'!$C$39:$N$39,'Defects Total'!$C$72:$N$72,1)
=SERIES('Defects Total'!$A$71,'Defects Total'!$C$39:$N$39,'Defects Total'!$C$71:$N$71,2)
The table the info is coming from is from (A40:N79) each week the chart needs to get the data from the last 2 rows with data in them, then the chart show the difference from current week & previous week.
