Point clouds with different x-coordinates

Hello,

Actually, it is quite possible based on the basic scatter plot function. BUT, the problem comes from using formulas for the values of the graph.
The function refuses to graph with different X values if there are non-numeric values (in the y-axis column). However, a formula that returns nothing is considered a non-numeric value.

To solve the problem, the formula must always return a numeric value. In my specific case, I use a condition to return a value equal to 0; I make it disappear from the screen with conditional formatting that changes the font color to white if the value is equal to 0.

That's it.
Thank you all.
L.

Hi,

If I understood correctly what you want to do:
You need to put your x-values in a single column, then the y-values of each series in different columns. Following your example, you get something like this (the dots are just for "layout"), which you can then "plot".

X......SERIES A...SERIES B
2......10.2
2......12.5
12....15.3
22....18.4
32....22.5
32....23.5
4.....................9.2
4....................11.5
14..................14.3
24..................19.4
34..................23.5
34..................24.5

ha I don't know how to do it in Microsoft Excel, I only use Open Office, sorry.

What software do you use?
Open Office?

Microsoft Excel 2002.

Thank you
L.

Sorry, I should have replied with my username LCFloor.

I am the one who wrote the above solution.

L.