Where is the XY scatter plot in Excel Mac?

Tap the cell in the upper left of the data you want to chart, then drag the cursor to the lower right cell of the data set to select it. (Denoted by a small circle.) On larger devices, such as a tablet, tap Insert > Charts > X Y (Scatter).

How do you make an XY scatter plot on Excel?

Create a scatter chart Click the Insert tab, and then click X Y Scatter, and under Scatter, pick a chart. With the chart selected, click the Chart Design tab to do any of the following: Click Add Chart Element to modify details like the title, labels, and the legend.

How do I connect points to a scatter plot in Excel on a Mac?

On the Select Data Source window click on the “hidden or empty cells” button located on the bottom left of the window. Click the “connect data points with a line” radar button. The press OK. The lines between the data points will be updated and connected.

How do you make a graph in Excel on a Mac?

Create a chart in Excel for Mac

  1. Select the data you want to chart.
  2. Click the Insert tab, and then do one of the following: Click Recommended Charts and select the chart type you want.
  3. With the chart selected, click the Chart Design tab to do any of the following:

Where is chart tools in Excel on Mac?

Click the Insert tab, and then do one of the following: Click Recommended Charts and select the chart type you want. Click a specific chart type and select the style you want.

How do I connect points to a scatter plot in Excel?

In the chart, select a data series (by clicking, but not double-clicking, on one of its points) and then right click. Select “Format Data Series” from the context (popup) menu that appears. Depending on your version of Excel, a dialog will appear that allows you to add lines to the data series.

How do you make a graph on Mac?

Creating Line Graphs

  1. Start a new page layout document.
  2. Click the Charts button on the toolbar.
  3. Click the Line Graph option. Click to view larger image.
  4. A line graph will appear with sample data.
  5. Bring up the Inspector window.
  6. Go to the Chart inspector.
  7. Click Axis.
  8. We’ll start by setting some options for the Y axis.