A scatter plot is just one style of chart-making in Excel. If you find that you need more flexibility in the presentation, you can right-click on the chart and select Change chart type .

In the case of a scatter plot, whether you use it simply with marking points or lines, the graph is spread across the XY-axis. Eg. Let us consider this example of a person’s salary across the ...

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. Each point will then be plotted as a ...

Microsoft Excel 2013 enables you to add sets of data to a chart one at a time. If your data is in the proper order, however, you can plot both sets of data at the same time. Adding Data Sets One ...

To find the CPI percentage, simply select the cell with the CPI ratio and hit the percentage symbol. ... Read: How to create a Line Chart and Scatter Plot Graph in Excel.