I would like to request Experts help to modify the attached formula to allow data automatically shows a specific data from cell D66:N66 at cell G59 (chart sheet) based on data displayed at cell S1 (chart sheet). E.g if cell S1 showed “TH1” therefore cell at G59 will display 100.00 (D66). If “TH5” was displayed at S1 cell, data at cell G59 will display data from cell H66 (97.33). The S1 data display is controllable at Chart 2 with spinner selection. Hope Experts will help me to modify this formula.