First, highlight the data you want to use for your scatter plot. Select the “Insert” tab on teh ribbon and click the Insert Scatter option in the Charts group. Choose the type of scatter plot you want to insert.
A scatter plot, sometimes referred to as a scatter chart or XY chart, compares the relationship between two different data sets. This makes it easier to visualize two sets of values in your Excel spreadsheet. Here’s how it works.
Create a Scatter Plot
To create a scatter plot, open your Excel spreadsheet that contains the two data sets, and then highlight the data you want to add to the scatter plot.
Once highlighted, go to the “Insert” tab and then click the “Insert Scatter (X, Y) or Bubble Chart” in the “Charts” group. A drop-down menu will appear. Here, select the scatter plot style you’d like to use.
Once selected, the scatter plot will be inserted into the spreadsheet.
…
Read Full Article Source
