Solving wrong displayed value in chart using dynamic names

I have an excel file where I load multiple files reference using a macro.


On the first sheet, after loading the files I have references like this:

Camera Passport OC120-135 best.xlsx 0,006748 0,005638 0,005248 0,005425 999,19 985,57 996,39 1078,74 5.7
Etc for all the files loaded

On the other sheets I have create dynamic graph using Names defined like this:

=OFFSET(Sheet1!$B$1;0;0;COUNTA(Sheet1!$B:$B))

I create also a Name for the last value which contains a point ".".

I replace the point by a comma using this function:

=IF(Sheet1!J2="-";"";IF(ISNUMBER(SEARCH(".";Sheet1!J2));REPLACE(Sheet1!J2;FIND(".";Sheet1!J2);1;",");Sheet1!J2))

I see the correct value in the cells:

5,7 5,2 3,6 5,9 10,5 21

This issue is, when I plot these values into a graph only the "21" is displayed all the other values are 0 like this:

0;0;0;0;0;21

The strange thing is, when I use all the other values from column B to I, it's working fine.

Is this function used to replace the point by a comma can make the graph not working???