+ Reply to Thread
Results 1 to 3 of 3

creating graphs with data which can change using formula

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    44

    creating graphs with data which can change using formula

    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.

  2. #2
    Forum Contributor
    Join Date
    09-10-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    176

    Re: creating graphs with data which can change using formula

    Hi,

    Please attach the sample spread sheet, so that it will be helpful for providing the solution.

    Regards,
    Humac

  3. #3
    Registered User
    Join Date
    10-07-2011
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: creating graphs with data which can change using formula

    its ok now i realised wat was wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1