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

[TABLE="width: 230"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Line Data[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]84[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]55.7[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]67.5[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]43.55[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]75.55[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]52.5[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]XY Scatter Data[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]84[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]55.7[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]67.5[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]43.55[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]75.55[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]52.5[/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="width: 230"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Line Data[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]84[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: center"]55.7[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]67.5[/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD="align: center"]43.55[/TD]
[/TR]
[TR]
[TD="align: center"]60[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]70[/TD]
[TD="align: center"]75.55[/TD]
[/TR]
[TR]
[TD="align: center"]80[/TD]
[TD="align: center"]52.5[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]XY Scatter Data[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]84[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: center"]55.7[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]67.5[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]43.55[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]75.55[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]52.5[/TD]
[/TR]
</tbody>[/TABLE]

​

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.