But using a gradient meant we lost the lines in the blue background. ... This is just one of many Excel charts. A scatter plot is just one style of chart-making in Excel.

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 .

Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet. Sometimes, it is useful and informative to plot two different sets of data on the same chart ...

Learn how to plot coordinates and create straight line graphs to show the relationship between two variables. Also, plot graphs that contain a negative coefficient of x.

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.