If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

That said, scatter plots are limited in how data is presented. If you’re looking for a chart using lots of text, a line chart might be a more appropriate option for your needs.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

How to add a separating line between the top area and the plot background in Excel As is, the color of the top area is so light that it fades into the plot area, which is white.