Further to your requested below please find attached; Example format.
What you need to do is add info on data sheet and create chart sheet basically whatever data your input to datasheet its will link to Index and chart however please carefully review and check for formula and link on each sheet for accuracy
Note: this example is applied form HR KPI.