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 would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel .

How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers. You can give spreadsheet ...

Launch the Excel 2010 spreadsheet that holds the scatter plot you want to adjust. Click anywhere on the chart, then click the "Layout" tab that appears at the top of the Excel window.