Ive been told theres a code of some type that will keep formulas and
associated charts in place even if the spreadsheet is later sorted by someone
else. Can someone walk me through how to do this?

Were using Excel 2007.
Thanks!