hi there im making graphs for an ICT project and i have come to a problem where i have been using ='sheetname'cellrefrence so for example =ks3x1. the problem i have is that when i change data which affects the overal averages for each class it is not updated on the data or processing sheet. all target and effort grades change if data is deleted or changed (this is all the data in the data sheet up to row 176). from 178 onwards nothing changes which means when i have to hand the system over it will show graphs which are wrong. with no data in the system the graphs should all show nothing when tasks get completed and marked the formula implamented in the system should work out averages etc. then as they change the graphs should also change. can anyone help at all cause im running out of time to get this complete. Final system V8.xlsx . Ks3,Ks4 and Ks5 are all connected to the data and processing sheet using the formula similar to the example =ks3x1 is it this type of formula which wont pick up the changes of is there a problem of which i havent found yet.
Bookmarks