Excel superimposing a graph, x-axis gets different values

Question

I tried superimposing two scatter plots with the same x values for each of them. But whenever I add the second one it seems to use way higher values.

These plots are supposed to in vertical comparison to each other, but instead I have one set of data (correct values for x) and then another set of data (weird values of x that do not correspond to what was used)

Answer 1

I do not understand your chart. How can the x-xise go to 12 when you d values are 0.210 to 3.99?

Here is my offering

Select A1:A1; holding down CTRL, select C1:C11 and E1:E11

Use Insert | Charts | Scatter XY to make chart 1

Right click on the Theory data in the chart, use Format Axis to put this data on a secondary axis

Format the x-axis to limit the range, add axes and chart titles

best wishes

Answer 2

Yes how do I do a graph like that? When I tried on my excel file using the same column for x, the values for x were shifted for the second column z.

Mind you, the data columns are farther apart, so I created first a scatter plot for (x,y), then I added a series for (x,z) on the same graph.

If you tell me how to post my graph here like you did

d (m)	u(d) (m)	T (N)	u(T) (N)	T(theoretical) (N)
0.399	0.0005	3.6	0.05	24.72
0.378	0.0005	3.6	0.05	26.00
0.356	0.0005	3.7	0.05	27.51
0.340	0.0005	3.9	0.05	28.74
0.319	0.0005	4.1	0.05	30.54
0.296	0.0005	4.3	0.05	32.81
0.281	0.0005	4.5	0.05	34.50
0.261	0.0005	4.7	0.05	37.05
0.235	0.0005	5.1	0.05	41.04
0.210	0.0005	5.6	0.05	45.81

d = x, T = y, T(theoretical) = z

Answer 3

Your question is not clear - tell more what you mean by superimposing.

best wishes

Answer 4

What do you mean the value is combined?

And why not have an option to simply superimpose them to compare the values?

Also the article you gave only applies for vertical axis, what do I do for horizontal, which is what I'm trying to do?

Thanks,

Answer 5

Hi,

What you are experiencing is normal when you two scatter plots on a graph. The reason being the values is combined.

We highly recommend creating a combo chart with a secondary axis instead.

Refer to this article for more information on how to create a combo chart with a secondary axis.

Let us know if you need anything else.