excel chart production course

Why do I excel with the drawing, always appear two lines? Kind of how I can put my 2, a Liedang abscissa, Liedang-ordinate?

1.Why do you excel drawing, always appear two lines?
A:What you said is not clear enough.
Are you referring to the two lines which is to coordinate Orthogonal axis shows the two lines, or do you add the two trend lines.
If I am talking about the former, then right-click the icon to choose the option column, and then click Options axis , To remove the main.Coordinate axis lines to scale.
If the latter, then you can remove the trend line.
2.How can you put the two data, a Liedang abscissa, a When ordinate?
:Very simple.With the left mouse button on the vertical you need to select the source data, and then choose to excel in the table mapping option, select the type of chart – to scatter.( Note:This operation resulted in the left column is the X-axis data, the right data for the Y axis.Such as the need to modify data in the series, re-select the data out)