Point clouds with different x-coordinates
LCFloor
-
LCFLoor -
LCFLoor -
Hello everyone,
I want to create a scatter plot but with different x-values for each series.
for example, the following series...
SERIES A
columns
A B
2 10.2
2 12.5
12 15.3
22 18.4
32 22.5
32 23.5
SERIES B
columns
A B
4 9.2
4 11.5
14 14.3
24 19.4
34 23.5
34 24.5
where the values in column A are the x-values, and B are the y-values.
the goal is to compare similar value series but avoid overlap.
How to do this?
Thank you
Laurent
I want to create a scatter plot but with different x-values for each series.
for example, the following series...
SERIES A
columns
A B
2 10.2
2 12.5
12 15.3
22 18.4
32 22.5
32 23.5
SERIES B
columns
A B
4 9.2
4 11.5
14 14.3
24 19.4
34 23.5
34 24.5
where the values in column A are the x-values, and B are the y-values.
the goal is to compare similar value series but avoid overlap.
How to do this?
Thank you
Laurent
Configuration: EXCEL 2002
6 answers
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.
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
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