Further to the 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 correctives.
Note: this example is applied form HR KPI.