Hello forum,

I have to process some data that i collect in a software.
So basically i want to compare two series of number, let's call it A and B.
The purpose is to show that A is very close to B so that the curve is near to y=x, quite simple.


In that specific situation B is a constant number, however A is a serie of variable numbers.
It happens that i discovered the stacked curve function, and it fitted exactly with the kind of approach i wanted for this situation.
f(A)=B was impossible due to the fact that i have different abscissa for the same final value, meanwhile i could see that there was a link between the different variables and the constant number, but i didn't know yet how to perfectly represent the similitude percentage between the A series and the B one.

To summar two questions :

-Why does the stacked curve function represents two very similar curves spaced with continuous gap (wich is actually the kind of stuff i want to get). I mean normally the curve B have to be constant through "time" (actually in abscissa there is no time but sample numbers, so that '120' for instance corresponds to the sample n°120). I don't get it how does excel manage to represent this second curve that way. I have joined the file for more visual approach.

-Is there any specific funtion to represent the similitude percentage between a variable serie of numbers and a constant one.


Best regards,

Attached Files

Instance.xls (60.5 KB, 14 views)