You will see two tabs: Setup and Customize. The Edit chart option will open up the Chart editor window on the right side of the screen. Select the chart (the chart window will appear blue when you select it) and click on the three dots in the upper right corner to open the menu. To achieve this, we need to convert the chart to a Line chart. This chart looks great, but we want a line connecting these dots. In this case, it will create a Scatter plot as shown below: When you insert a chart, Google Sheets IntelliSense will automatically pick the best chart suitable for the selected data. Navigate to the Insert menu and click on Chart. Select the entire range from A1 to B11 (including headers). We will use the data of ten individuals, as shown below, showing the height in centimeters and weight in pounds under columns A and B, respectively.ġ. Let’s go through the process together one step at a time. To tackle this problem, simply create a line chart and use the Chart editor to increase the size of the points in the Series Format section. This will give the impression of a scatter plot with the points joined together by a line.Ĭheck out the example below and follow the step-by-step guide to make one for yourself in the following section.Ĭonnecting Scatter Plot Points: The Workaround Increase the point size for each data point so they stand out on the line. Use a line chart based on the same data as the scatter plot. Google Sheets does not provide a quick and easy method to create a scatter plot chart that allows you to connect the points on the chart with a line.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |