The data labels will reflect the number format of the range. How you have it set up currently there is only 1 number format in use.
Start by adding 2 rows of formula to the calc sheet so you have a set of data with a row for each KPI.
Format each row of data with correct number format.
Use the name manager to Define that data
ALL_DATASETS: =calc!$B$14:$M$16
Define another range to reference the currently selected KPI
USE_DATASET: =INDEX(ALL_DATASETS,MATCH(calc!$A$13,REF!$H$2:$H$4,0),0)
Now on the chart checked the number format of the data labels so it is linked to the cells.
Edit the series formula
=SERIES(,calc!$B$13:$M$13,'1371411.xlsx'!USE_DATASET,1)
Bookmarks