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.

How to make a line graph in Excel 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight ...

Microsoft Excel makes great charts, but often they’re not eye-pleasing. Learn how to change formats to yield a professional-looking chart.