Scatter plot and Bar chart

Hi,

I would like to use multiple scatter plots and bar charts in one chart. Problem is that X-Axis goes horribly wrong every time, even if I have same points on both scatter and bar. Here is Data for 2 Scatter Plots

X Scatter1
1,43 0,14
2,60 0,25
3,04 0,37
3,60 0,50
3,93 0,60
4,69 0,80
X Scatter2
5,10 0,92
5,36 1,00
6,43 1,26
7,60 1,53
8,19 1,65
8,79 1,77
9,69 1,93

And here is data for 2 Bar Charts

X Bar Chart1 Bar Chart2
1,43 #N/A 0,00
2,60 #N/A 0,01
3,04 0,01 0,01
3,60 #N/A 0,01
3,93 #N/A 0,01
4,69 #N/A 0,00
5,10 0,02 0,01
5,36 #N/A 0,01
6,43 #N/A 0,02
7,60 0,04 0,02
8,19 #N/A 0,01
8,79 0,11 0,02
9,69 #N/A 0,01

I start with Scatterplot and put those in the graph, then I add other data and change it to Bar Chart, but this is the point where X-Axis gets mixed up and scatter plot X data and Bar chart X data are not matching. Any ideas?

example.xlsx

Here is simple example. As you can see, barChart and Scatter Chart X values are not matching.

ok, if possible could you do it to that example? Thanks, otherwise will just start testing myself. I would just hope to find away that it would work out on its own, bc I have 23 more charts to do