# Combined Chart ( Line Chart and XY Scatter Chart ) Problem

#### r1998

##### Board Regular
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.
Thank you.

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
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.

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.

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.

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

Replies
2
Views
95
Replies
3
Views
1K
Replies
9
Views
640
Replies
1
Views
475
Replies
1
Views
219

1,203,398
Messages
6,055,168
Members
444,767
Latest member
bryandaniel5

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back