Combined Chart ( Line Chart and XY Scatter Chart ) Problem

[r1998]

Dear Friends and Respected Seniors,
I have a chart containing a Line Chart Series and an XY Scatter Chart Series. Data for Line Chart is from A1-B9 and data for XY Scatter Chart is from A11-B19.
Data from A1-B19 is

	Line Data
1	#N/A
2	84
3	55.7
4	67.5
5	43.55
6	#N/A
7	75.55
8	52.5
	XY Scatter Data
1	#N/A
2	84
3	55.7
4	67.5
4	43.55
4	#N/A
4	75.55
4	52.5

<tbody>
</tbody>

The chart is generated correctly.
https://paste.pics/4XOFK


but when i change data of Column A, the chart generated is incorrect.
The new data from A1-B19 is

	Line Data
10	#N/A
20	84
30	55.7
40	67.5
50	43.55
60	#N/A
70	75.55
80	52.5
	XY Scatter Data
10	#N/A
20	84
30	55.7
40	67.5
40	43.55
40	#N/A
40	75.55
40	52.5

<tbody>
</tbody>

​

The chart is generated incorrectly
https://paste.pics/4XOGB

What am I doing wrong ?
Can anyone please kindly point out my mistake and help me.
Awaiting your replies.
Thank you.

 

[Jeffrey Mahoney]

The series for the line Data has to be edited manually. When you created the original chart, the values 1 through 8 were inserted. You have to edit those in the Horizontal Axis section on the right side of the "Select Data Source" dialog. It will let you select the new X series.

 

[Jeffrey Mahoney]

My bad. I duplicated the issue. I had to change the X Axis Type to Date to get it to work. I guess the X Axis is being ruled by a Text based structure instead of a number based structure. The numbers 10-80 are just labels to the Line Data. The XY series uses numbers and can interpolate between. You'll have to play with the Units to get it right.

 

[r1998]

Thank you so much Jeffrey Mahoney Sir
I converted Column A to the Date format and correct chart was generated. Tried with other formats too but only the Date format works ( not sure why ).
Correct chart's pic
https://paste.pics/4XP5Y
( formatted x axis in chart as number to show numbers instead of dates )

Thank you.

 

[Jeffrey Mahoney]

I didn't have to change the numbers to dates on the sheet, just on the chart.