Articles

How do you make a scatter graph on Excel?

by Rhyley Bryan

How do you make a scatter graph on Excel?

To create a scatter chart of this information, take the following steps:

  1. Select the worksheet range A1:B11.
  2. On the Insert tab, click the XY (Scatter) chart command button.
  3. Select the Chart subtype that doesn’t include any lines.
  4. Confirm the chart data organization.
  5. Annotate the chart, if appropriate.

What is scatter graph Excel 2010?

Scatter Chart In Excel 2010 A scatter chart plots the values for two variables as a set of points on a graph. One variable controls the position on the x-axis of a point, whilst the other variable controls the position on the y-axis.

How do you plot a scatter plot in Excel?

Creating a Scatter Plot Open Excel. Open a blank document. Enter in values for your scatter plot. Click on the Insert tab. Highlight the cells that you want to include in the scatter plot. Click the scatter plot icon. Click the first scatter plot option to make a basic scatter plot.

How to scatter plot data on Excel?

Select all the cells that contain data

  • Click on the Insert tab
  • Look for Charts group
  • Y) Chart
  • Click the arrow to see the different types of scattering and bubble charts
  • You can pause the pointer on the icons to see the preview in your document
  • Click on Scatter Chart
  • you will see the scatter chart.

    • How to do a two-sided graph in Excel?

    Open Microsoft Excel and enter your two data sets in separate columns.

  • by holding down the left mouse button and dragging your pointer over each cell.
  • Click “Insert” on the main file ribbon.

    • How do you build a graph in Excel?

    How to Make a Graph in Excel. Enter your data into Excel. Choose one of nine graph and chart options to make. Highlight your data and ‘Insert’ your desired graph. Switch the data on each axis, if necessary. Adjust your data’s layout and colors. Change the size of your chart’s legend and axis labels.