How do you create a scatter plot on Excel?

How do you create a scatter plot on Excel?

Create a scatter chart

  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data you want to plot in a scatter chart.
  2. Select the data you want to plot in the scatter chart.
  3. Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.
  4. Click Scatter.

How do you make a scatter plot on Excel on a Mac?

It also includes information for Android and iOS devices….What to Know

  1. Select at least two columns or rows of data in Excel. Then, choose Insert.
  2. In Charts, select the Scatter (X,Y) or Bubble Chart drop-down menu. Select More Scatter Charts and choose a chart style.
  3. Excel inserts the chart.

How do I make a scatter plot?

Draw a graph with the independent variable on the horizontal axis and the dependent variable on the vertical axis. For each pair of data, put a dot or a symbol where the x-axis value intersects the y-axis value. (If two dots fall together, put them side by side, touching, so that you can see both.)

What is Scatter graph Excel 2010?

Scatter Plot Chart in excel is the most unique and useful chart where we can plot the different points with value on the chart scattered randomly, which also shows the relationship between the two variables placed nearer to each other.

How do you make a scatter plot on a Mac?

Create a scatter chart

  1. Click.
  2. Click a scatter chart or drag one to the sheet.
  3. Click the Add Chart Data button near the chart.
  4. Select the table rows or columns that have the data you want to use by clicking the numbers or letters for those rows or columns.

How do I create a chart in Excel 2010?

To create a chart:

  1. Select the cells you want to chart, including the column titles and row labels.
  2. Click the Insert tab.
  3. In the Charts group, select the desired chart category (Column, for example).
  4. Select the desired chart type from the drop-down menu (Clustered Column, for example).

How do I add a chart element in Excel 2010?

  1. Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
  2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then select the chart element that you want to format.

Where can I make a scatter plot?

Use Excel to Make a Scatter Plot

  1. Highlight data you want to plot.
  2. Go to the “Insert” tab.
  3. Find the “Charts” section.
  4. Click on the scatter plot icon.
  5. Edit ranges, axis titles, chart title, and anything else you want to adjust.
  • September 16, 2022