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 ...

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.

How to Plot a Formula in Excel. ... When you click the "OK" button, Excel plots the chart for you and places it over your worksheet_. Drag or resize_ the chart as needed.