Line Chart Problem

[r1998]

Dear Friends and Respected Seniors,
I have the Y coordinates for a simple line chart from A1 to A8, I select A1-A8 and create a line chart (X coordinates are generated automatically from 1-8)
Data in A1 to A8 is

1
2
3
3
3
3
3
1

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

The problem I am facing is, for the last two Y coordinates the X value is same, so it must make a vertical line in chart. I tried to assign X coordinates manually by filling values in B1-B8 as

1
2
3
4
5
6
7
7

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

and then assigning by clicking on chart>selectdata>horizontal axis lables and selecting from b1-b8.... but it still didnt work
the chart that i have now is
https://paste.pics/4XCRB

the chart that i want
https://paste.pics/4XCRQ

Can anyone please kindly guide and help me
Awaiting your replies.
Thank you.

 

[Jon Peltier]

First, put your X values in the first column and your Y values in the second column (and subsequent columns if there are more sets of Y values). Put a label above each column of Y values, and leave the cell above the X values blank. When you make a chart from a range like this, the blank cell helps Excel figure out what to plot as X and Y, and it will use the labels above the Y values as series names, which will then appear in the legend.

Second, you don't want a LINE chart, you want an XY SCATTER chart. A line chart treats the X values as text labels, not as numerical positions.

 

[r1998]

Thank you so much Jon Peltier Sir, I googled and searched for almost 3 hrs, got fed up, then finally posted this question here.
i did exactly as u said, now X coordinates are in Column A, Y coordinates in column B, and then created the XY scatter chart. Everything worked perfectly.
Thank you.