Table of Contents
To connect points in a scatter plot in Excel, follow these steps:
1. Select the data points you want to connect in the scatter plot.
2. Right-click on one of the selected points and choose “Add Trendline” from the menu.
3. In the “Format Trendline” window, go to the “Line” tab and select “Linear” or “Exponential” depending on the type of trendline you want.
4. Check the box next to “Display Equation on chart” if you want the trendline equation to be shown on the chart.
5. Click “Close” to apply the trendline to your scatter plot.
This will connect the data points with a line or curve, providing a visual representation of the relationship between the variables. Adjustments can be made to the trendline by right-clicking on it and selecting “Format Trendline” to change its appearance or add additional features.
Connect Points in a Scatter Plot in Excel
Often you may want to connect the points in a scatter plot in Excel.
Fortunately this is easy to do and the following step-by-step example shows how to do so.
Step 1: Enter the Data
First, let’s enter the following dataset in Excel:
Step 2: Create the Scatter Plot
Next, we will create a scatter plot to visualize the values in the dataset.
To do so, highlight the cells in the range A2:B14, then click the Insert tab along the top ribbon, then click the Scatter icon in the Charts group:
The following scatter plot will automatically be created:
Notice that the points in the plot are not connected by default.
Step 3: Connect the Points in the Scatter Plot
To connect the points in the plot, double click on any individual point in the plot.
In the Format Data Series panel that appears on the right side of the screen, click the paint bucket icon, then click the Line group, then click Solid Line:
The points in the plot will automatically be connected with a line:
Also note that within the Format Data Series panel, you can control the style of the line including:
- Line color
- Line width
- Line dash type
Feel free to modify the appearance of the line to make it look however you’d like.
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How do I connect points in a scatter plot in Excel?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-connect-points-in-a-scatter-plot-in-excel/
stats writer. "How do I connect points in a scatter plot in Excel?”." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-connect-points-in-a-scatter-plot-in-excel/.
stats writer. "How do I connect points in a scatter plot in Excel?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-connect-points-in-a-scatter-plot-in-excel/.
stats writer (2024) 'How do I connect points in a scatter plot in Excel?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-connect-points-in-a-scatter-plot-in-excel/.
[1] stats writer, "How do I connect points in a scatter plot in Excel?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I connect points in a scatter plot in Excel?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.