). The following scatterplot will appear: Step 3: Add Labels to Points. We opted for the Line with Markers chart. This video w Nov 27, 2022 · This guide will provide a step by step run through on how to make a Scatter Plot in Excel. ここでは例として、12人の生徒の国語と数学の試験結果を使用します。. Right off the bat, outline a helper table where all the calculations for your chart will take place. Select the type of scatter plot you want to create. Select the chart and make adjustments by clicking + (plus) to display elements you can apply or alter. Step 3: In the 'Charts' group, select 'Scatter' and then choose the 3D scatter plot option. Step 1: Adding a Break Value and a Restart Value. Press Ctrl + D to duplicate the plotted graph. Jun 23, 2023 · Click on the “Insert” tab in the Excel ribbon, and select the “Scatter” chart type. Click on "Add Chart Element": Within the "Chart Design" tab, locate the "Add Chart Element" button. In the chart, select the data series that you want to add up/down bars to. Create a new spreadsheet and input the values for your two variables into separate columns. Mar 16, 2023 · Learn how to make a scatter plot in Excel to show the relationship between two variables. After selecting your data, click on the ‘Insert’ tab on the Excel ribbon and then click on the ‘Scatter’ chart type. Go to the Insert tab >> click on Shapes. Steps: Choose the data. Click on the Insert Tab and go to Charts Jun 3, 2021 · This tutorial provides a step-by-step example of how to add a quadratic trendline to a scatterplot in Excel. For basic visualization, the simple scatter plot without lines is perfect. Open your scatter plot in Excel. Feb 15, 2021 · Step 2: Create a Scatterplot. 1, 1, 10, 100, 1000), you can follow these simple steps: 1. May 20, 2023 · Creating a scatter plot in Excel is a simple and effective way to visualize data and communicate insights to your audience. 1. This is a useful tool that can help you understand data better. In the first column, enter the values of the independent variable. Once you're on the "Insert" tab, look for the "Charts" group. Then click the plus (+) sign in the top right corner of the plot and check the box that says Trendline. Note: we used the AVERAGE function to calculate the Jun 27, 2023 · Step 3: Insert the Scatterplot. goskills. Click the Insert tab along the top ribbon, then click the first chart option under Insert Scatter in the Jun 17, 2024 · Method 1– Adding a Dummy Axis. Explain how to input the data into Excel. In this video, we'll show you how to create a categorical scatterplot in Excel. You should now see a linear straight line that reflects the trend of your data. Click inside the box below Series X values, then select the X data (either click and drag or Sep 9, 2013 · Select one of the Area data series (still plotted as XY), press Ctrl+1 to open the Format Series Task Pane or Dialog, and choose Secondary Axis. This will immediately insert an XY scatter chart in your worksheet. We will store the Break Value and our Restart Value in these 2 cells. Download the free practice Excel file for this video from https://www. Click on it to reveal a drop-down menu. Feb 16, 2022 · Next, highlight the cells in the range A2:B9, then click the Insert tab, then click the Scatter option in the Charts group: Excel will automatically insert the following scatter plot: Step 3: Create the Quadrant Chart. Go to the "Chart Design" tab: This tab is located at the top of the Excel window, next to the "Format" tab. 5. Make sure to organize your source data correctly before creating a scatter plot in Excel. I also show how to change the scale, and draw the line of best fit. Here's the step-by-step method to achieve the result you referenced (and hopefully solves your problem). " This will instruct Excel to treat the X-values as dates and display them accordingly. Embed scatter plots in presentations, reports, and documents. Select OK. Jun 29, 2024 · Steps. Follow these steps: Select the scatter plot: Click on the scatter plot to select it. The simplest option is usually the best to start with, as you can always add more features later. Select the "Insert" tab, followed by the "Scatter" icon within the "Charts" group. Then, go to the “ Insert ” tab of your Excel menu bar and click on the scatter plot icon in the Detailed instructions for adding a vertical axis label in an Excel scatter plot. For the detailed step-by-step instructions, please see: How to create scatter plot in Excel; How to add trendline to Jun 21, 2023 · Step 2: Insert the Scatter Plot. Select Paste Special Select Add. It's the second option in the Format Trendline panel. To label the x-axis, right-click on the axis and Custom Error Bars. go to the Series tab; the last option there is Category (X) axis labels. Along the top ribbon, click the Insert tab and then click Insert Scatter (X, Y) within the Charts group to produce the following scatterplot: The (X, Y) coordinates for each group are shown, with each group May 20, 2023 · Creating a scatter plot in Excel is a quick and straightforward process that can help you to better understand the relationships between two sets of data. This would bring a small text box to the top of your chart. , linear, exponential, logarithmic, etc. Name 2 cells as Break and Restart. 2. The x-axis is represented by a linear Jun 27, 2023 · Click on the “Insert” tab on the top of the screen. May 20, 2023 · Step 3: Insert Your Chart. Next, highlight the range A2:A9. This article explains how to create a scatter plot in Excel for You can quickly show a chart like this by changing your chart to a combo chart. Click the lower part of the Paste button on the Home tab of the ribbon. This process will create a blank scatter plot graph in your worksheet. Dec 20, 2021 · Go to the Home tab, click the Sort & Filter drop-down arrow in the ribbon, and choose "Filter. By plotting two sets of numbers as one series of xy coordinates, you can see if there’s a pattern or relationship between them. Improve this answer. By following these simple steps and applying some basic tips for creating effective graphs, you can create professional-quality scatter plots that make your data easy to understand and A scatter plot is a built-in chart type in Excel meant to show the relationship between two variables. Then, click the Insert tab along the top ribbon and click the Insert Scatter (X,Y) option in the Charts group. Excel gives us the secondary vertical axis along the right edge of the chart. In a scatter plot, both the X and Y axis display values – an XY chart has no category axis. Finally, select the scatter chart option. A. First, this method creates a scatter chart using our dataset. Publish, share, and download high-resolution images. Next, highlight the cell range H2:H4, then click the Insert tab, then click the icon called Clustered Column within the Charts group: The following bar chart will appear that shows the mean number of points scored by each team: To add the standard deviation values to each bar, click Feb 2, 2022 · Highlight the two columns you want to include in your scatter plot. In the Charts group of the ‘Insert’ tab, you’ll find the ‘Scatter’ option. Adding a trendline to the scatter plot. Click on the "Scatter" chart type in the Charts group. You can change the marker shape in an Excel graph by inserting custom pictures or shapes for individual marker points. First, let’s enter the following dataset in Excel: Step 2: Create the Scatter Plot. Then, hold Ctrl and highlight every cell in the range D2:F9. In Excel 2013, click the plus icon beside the chart, click on the right-facing arrow May 20, 2023 · To create a scatter plot in Excel, enter your data in a spreadsheet and select the data series you want to plot. g. Do the same step but select different date ranges for other Label B and Label C. Click on the Insert tab. Nov 9, 2023 · Inserting a Scatter Plot. The following are the advantages of using the Scatter Plots in Excel: The scatter charts help determine the relationship between two or more variables, and they mainly showcase the relationship of one variable concerning another. Click Add Trendline on the menu. Choose the first scatter plot option (the one with data points not connected by lines). Jan 28, 2022 · This tutorial provides a step-by-step example of how to change the x-axis and y-axis scales on plots in Excel. Nov 25, 2020 · Very simple and general answer: Right click the graphic portion of the axis you wish to change; a menu will appear, select "Edit axis", "Properties" or similar (actual choice depends on Excel version, or if using e. Copy it. " Feb 15, 2023 · To create a scatter chart on an Excel sheet, follow the steps below: Open the worksheet containing the data that you want to plot on the Scatter chart. The first thing we need to do is select all of our data – this simply means highlighting everything (including the headers) from B2 down to C12 in our example dataset: Next up, under the Insert menu up in the ribbon, in the Charts section, choose the Insert Scatter (X,Y) or Bubble Chart: From 1. After that, we utilize the Excel shapes to add a vertical line to that scatter plot. Select the type of scatter plot that you want to use in your data visualization. In Charts, select the Scatter (X,Y) or Bubble Chart drop-down menu. go to Insert -> Chart -> choose the line chart and click Next. Click on the Chart Elements button as shown above. Feb 2, 2022 · In this post, we cover the basics of creating a scatter plot in Excel. Press the button next to that. Each piece of data is then plotted as a discrete point on the chart. In the “Charts” area, click the dropdown with the scatter plot (highlighted in the image below). Next, we will create a scatter plot to visualize the values in the dataset. Oct 18, 2023 · 6. Click "Chart Elements": In the top-right corner of the chart, click on the "+" icon and select "Chart Elements". However, the way each of these chart types plots data along the horizontal axis (also known as the x-axis) and the vertical axis (also known as the y-axis) is very different. Excel will automatically generate a scatter plot based on your data. Click on the ‘Scatter chart’ option in the charts thats show up. Oct 6, 2022 · Step 3: Plot the Mean and Standard Deviation for Each Group. Scatter charts and line charts look very similar, especially when a scatter chart is displayed with connecting lines. The process of inputting data into Excel involves the following steps: Step 1: Open Excel and create a new spreadsheet or open an existing one. Go to the Insert tab in the ribbon. Right click this blank chart > Select Date Source > click Add > Enter the Series Name, such as Label A, select the data range for X values and Y values. By default, Excel will create a chart with markers and lines; however, you can choose to display only markers. Remove the legend. " Click the arrow at the top of the column for the chart data you want to filter. Read More: How to Do Interpolation with GROWTH & TREND Functions in Excel. For example, right-click the x-axis (numbers 0 to 4), click Format Axis, and change Minimum and Maximum by clicking Fixed (instead of Auto) and filling in the values that you want, perhaps 1. A scatter plot will be created on your worksheet, displaying the relationship between the two variables. Select “Scatter” from the options in the “Recommended Charts” section of your ribbon. There are several steps to inserting a scatter plot into an Excel worksheet listed below: First, select the data that you wish to plot. Click the arrow to see the different types of scattering and bubble charts. VIDEO CHAPTERS0 May 19, 2024 · Method 3 – Using a Custom Marker. Click on the "Scatter" chart type to insert a basic scatter plot onto the spreadsheet. This is where you'll find the charting options for creating a scatter plot. Note: we used the AVERAGE function to calculate the Dec 7, 2019 · To create or make Scatter Plots in Excel you have to follow below step by step process, Select all the cells that contain data. Fortunately this is easy to do and the following step-by-step example shows how to do so. LibreOffice). STEP. To create a scatter plot with two variables on Excel, follow these simple steps: A. May 20, 2023 · To create a scatter plot in Excel, enter your data in a spreadsheet and select the data series you want to plot. Then click the Insert tab along the top ribbon, then click the Insert Scatter icon in the Charts group and choose the first option to insert a scatter plot: Mar 18, 2021 · Do the following: Select the values in the second column. 1. Instead, create a (longer) table that has a column for the city, for the priority and the corresponding value: Now that your data is inputted into Excel, you can move on to creating the scatter plot: Select Data: Click on the “Insert” tab and then select the “Scatter” option from the Charts group. First, let’s enter a simple dataset into Excel: Step 2: Create a Scatterplot. Then, go to the “ Insert ” tab of your Excel menu bar and click on the scatter plot icon in the “ Recommended Charts ” area of your ribbon. In a blank workbook, create two columns of data. For example, you can choose “Scatter with Only Markers” or “Scatter with Smooth Lines and Markers. Next, highlight every value in column B. From the Charts section, select Line or Area Chart. Jun 13, 2020 · Go to Insert > Choose one Scatter Graphic in Charts group, then we will get a blank chart. Insert a chart and add an exponential trendline (similar to Method 1 ). In cell F7, enter the following formula: =GROWTH(C5:C12,B5:B12,F6,2) Press ENTER to find the interpolated value. How to Generate a Scatter Plot in Excel. Now that the scatter plot is created, we may need to update the formatting of our graph. Under “Charts,” select “Scatter. Next, click anywhere on the chart until a green plus (+) sign appears in the top right Jul 7, 2024 · The simplest way to create a scatter plot in Excel is to highlight the cells in the two columns that contain your two numeric variables—in this case, the “ MONTHS OF EMPLOYMENT ” and “ MONTHS WITH ABOVE-AVERAGE PERFORMANCE ” columns. In the second column, enter the values of the dependent variable. Inserting a scatter plot in Excel. [5] 7. Add a trendline: Right-click on any data point on the scatter plot, select "Add Trendline," and choose the type of trendline you want to add (e. Demonstrate how to add a horizontal line using the "Add Chart Element" feature in Excel. To begin, open your Excel workbook and navigate to the "Insert" tab at the top of the window. Share. Data can be uploaded directly from spreadsheets. Enter the Break Value in cell C11. Below you can find our data. 5 and 3. Custom Error Bars. Click OK. In line charts, column and bar graphs, numeric values are plotted only on the y-axis. Then, click on “Insert” tab on the ribbon, select “Scatter” under the “Charts” section, and choose the desired scatter plot type. グラフにしたいデータを全て選択し、「挿入」→「グラフ Insert a scatter plot: Go to the "Insert" tab, select "Scatter" from the chart options, and choose the desired scatter plot style. If you see numbers there instead of the desired text, click Edit and select the range where the text labels are. Learn how to create a scatter plot using Excel 2016. Click Add above the bottom-left window to add a new series. From here, select the scatter plot that best fits your data. 相関を調べたい2つのデータを用意しましょう。. Excel trendline formulas should only be used with XY (scatter) graphs because only in this chart type both the y-axis and x-axis are plotted as numeric values. Sep 2, 2021 · Step 3: Create the Scatterplot. Scatter Plots can be a really useful visual representation of our data, especially when we are hoping to find any trends and correlations between two separate variables. First, let’s create some data to work with: Step 2: Create a Scatterplot. Y data points in Excel. Click on the "Insert" tab at the top of the Excel window, then click on the "Scatter" chart icon in the Charts group. Before you can create a scatter plot, you need to input your data into Excel. Step 4: Customize the Chart. Next, highlight the cell range A1:C11, then click the Insert tab along the top ribbon, then click the Scatter icon within the Charts group: The following scatter plot will automatically appear: The blue dots represent the sales each year for Product A and the orange dots represent the sales for Product B each year. Excel inserts the chart. Select the data you want to use for Select the two columns of data that you want to plot on the scatter plot. Choose Chart: From the drop-down menu, choose the style of scatter plot that best fits your data. This time, Excel won’t know the X values automatically. Step 2: Determine the variables you want to display on the scatter plot and label the columns accordingly. Jan 20, 2024 · Select the scatter plot by clicking anywhere on it to launch the three icons on the right of the plot. Once the data is selected, go to the "Insert" tab on the Excel ribbon. Check "Axis Titles": In the "Chart Elements" menu, check the box Feb 5, 2024 · In this forum, we are Microsoft consumers just like yourself. From the chart options, select any chart suitable for your data. Under Chart group, you will find Scatter (X, Y) Chart. In the Edit Series window, click in the first box, then click the header for column D. The scatter plots can show correlations visually. Finally, customize your scatter plot, add data labels if desired, and save it. Excel will automatically create a Scatter chart (or scatter plot or X Y chart) shows relationship between two variables. Mar 15, 2021 · In this tutorial, I’m going to show you how to easily add a trendline, equation of the line and R2 value to a scatter plot in Microsoft Excel. Select the scatter plot design that you want to use, such as “Scatter with Straight Lines and Markers”. Select the scatter plot option from the chart menu. Next, highlight the cell range A2:B15. Jan 31, 2021 · The following scatterplot will appear: Step 3: Add a Regression Line. Then select the Data Labels and click on the black arrow to open More Options . B. It uses dots to plot the values over the X and Y axis. Next, highlight cells A2:B17. May 20, 2023 · Step 3: Insert the Scatter Plot Chart. Select “Scatter” to create a scatter plot of the data. To add awesome custom error bars, execute the following steps. To customize the y-axis values on your scatter plot in Excel on your MacBook Pro to show only the specific values (0. Choosing the right scatter plot is crucial. Select a chart to open Chart Tools. Do something similar for the y-axis. Next, let’s create a scatterplot to visualize the dataset. Your scatter plot should now appear on the screen, showing the data you selected. Feb 7, 2023 · Step #1: Set up a helper table. 3. Select the drop-down arrow and choose Line. Navigate to the "Insert" tab in Excel. You can label the data points in the X and Y chart in Microsoft Excel by following these steps: Click on any blank space of the chart and then select the Chart Elements (looks like a plus icon). com/Excel/Resources/How-to-make-a-scatter-plot-in-Excel?utm_source=youtube&utm Feb 19, 2019 · 2) Use an XY/Scatter plot, with the default horizontal axis "turned off" and replaced with a "helper" series with vertical values of 0 and horizontal values as desired in your dataset (this is my preferred method). Look for Charts group. Aug 23, 2023 · First, let’s enter the following values for a predictor variable (x) and a response variable (y) in Excel: Step 2: Create a Scatter Plot. select "Format Data Labels" (note you may have to add data labels first) put a check mark in "Values from Cells". With the dummy data, the chart looks like this when just inserted: Now some formatting changes have to be made to the chart. Select Linear from the Trendline Options. 2. Right-click the chart and choose Select Data. Click on the insert scatter or bubble chart option noted by 3 in the illustration below. If you want to view all of my videos B. Update Chart: If the issue persists, try refreshing or updating the chart. In the Chart group, click on the Insert Scatter Chart icon. Right-click the chart and choose Select Data…. Mar 11, 2020 · For the chart, the remedy is to modify the format. Edit the chart data and check the entries for "Horizontal (Category) Axis Labels". Next, click anywhere on the scatterplot. Using the Excel Scatter Plot (Linear Trendline) Select the X and Y coordinate values and click Insert >> Charts >> Scatter. A huge number of shapes is displayed. It's easier than you might expect, and can reveal important insights about your data. Step 1: Enter the Data. Click on “Scatter” on the “Charts” section. Next, choose the Insert tab and. Set up a separate dummy table as follows: Notice how Advantages of using Scatter Plots in Excel. May 31, 2023 · Often you may want to create a plot of X vs. Select Secondary Axis for the data series you want to show. Jun 28, 2024 · To make a scatter plot with straight lines on an Excel spreadsheet, follow these steps: Begin by making a spreadsheet and adding your X and Y data points to a table. ”. Once you have selected your data, you can insert a scatter plot in Excel by following these steps: Select the data that you want to include in the scatter plot. Then, hold Ctrl and highlight every cell in the range E1:H17. This video sh Learn how to create X/Y Scatter Charts in Microsoft Excel. Sep 2, 2021 · Step 2: Create the Scatterplot. Apr 22, 2024 · Creating a scatter plot in Excel is a handy way to visually represent data points on a graph. Apr 2, 2023 · それでは エクセルの散布図の基本的な作り方 を説明します。. Note: For information about the different types of Jan 11, 2023 · A short video that shows how to make a visualisation in Excel with multiple scatter plots and trend lines. Select the columns that have the data (excluding column A) Click the Insert option. To build the plot, you need to compute the polar coordinates first and, once there, convert them to the x- and y-axis values used by Excel to create the chart. 5. Our second method is to use Excel shapes to add a vertical line to a scatter plot in Excel. In Excel 2013, click the plus icon beside the chart, click on the right-facing arrow Apr 14, 2016 · This is what you want to do in a scatter plot: right click on your data point. Axis Settings: After creating the scatter plot, right-click on the horizontal axis (X-axis), choose "Format Axis," and ensure the axis type is set to "Date Axis. Jul 9, 2024 · Step 4: Choose the Scatter Plot Option. EDIT: Step by Step directions. From the list of Chart elements that open up, check the box for ‘Chart Title’. STEPS: Create a Shape column in our dataset. A scatter plot works by placing one variable on the vertical axis and a different variable on the horizontal axis. Oct 6, 2023 · Select and group data points by category and add a trend line to enhance clarity. With the scatter plot selected, click on the "Chart Elements" button (the plus sign icon) that appears next to the chart. Select More Scatter Charts and choose a chart style. Right click any data point in the chart and choose Add Trendline… from the context menu. We cover scatter plots with one data series and with multiple series, and talk about how to add essential context like trendlines, quadrants, and data labels, and how to customize each of these to your preferences. Click on the Chart: Click on your scatter plot to select it. Create 3 new columns after Product and Sales, named Before, Break, and After. A dialog, panel or similar will open; again depending on the actual software and version. In this tutorial, I will show you how to make a scatter plot in Excel, the different types of scatter plots, and how to customize these charts. com → Diese Excel Vorlage zeigt Dir beispielhaft die Erstellung einer Scatter-Plots (Streudiagramm)→ Ein Streudiagramm, auch Punktwolke genannt, ist die graphisc May 5, 2023 · For the main data series, choose the Line chart type. Adding Vertical Line to Scatter Plot Using Excel Shapes. To create a scatter plot with text labels in Excel, follow these steps: 1. Add up/down bars. May 23, 2024 · Intercept = INTERCEPT (C5:C12,B5:B12) In C15, enter the following formula: =E6*C14+E8. Apr 30, 2024 · Method 3 – Plotting a Graph in Excel with Three Y-Axes. When you finish, click "Apply Filter" or check the box for Auto Apply to see your chart Nov 27, 2022 · Making a Scatter Plot in Excel – Step by Step. Repeat for the other Area data series. The above steps would insert a scatter plot as shown below in the worksheet. Select the value of both the columns you want to plot. Add the interpolation value in the chart. C. Apr 22, 2024 · Step 3: Click on ‘Scatter’. In the Select Data Source dialog box, select the VerticalLine series and click Edit. In the dropdown menu, hover over "Gridlines" and then select "Horizontal Gridlines. Now you'll see the Format Trendline panel on the right side of Excel. Then click the Insert tab along the top ribbon and then click Insert Scatter (X, Y) within the Charts group: The following scatterplot will appear: Each of the (X, Y) coordinates from the dataset are shown on the Mar 16, 2023 · Excel trendline equation is correct only in scatter charts. Oct 18, 2017 · Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers. Once you’ve selected your data, click on the “Insert” tab at the top of the screen. Note: For information about the different types of Select the cells in the formula columns (cells D2:E15) and create the chart using Insert / Scatter Plot on the Ribbon. Step 2: Click on the 'Insert' tab in the Excel ribbon. Place the independent variable on the left column and the dependent variable on the right column. Jul 14, 2020 · The table you posted has two dimensions (city and priority) which makes it hard to plot in Excel. Step 1: Create the Data. Go to the "Insert" tab on the Excel ribbon. Click on the plot to select it, then click on the "Chart Elements" button (the plus icon) that appears to the right of the plot. Select an empty cell. This will automatically add a simple linear regression line to your scatterplot: Step 4: Add a Regression Line Equation Mar 16, 2023 · On the Inset tab, in the Chats group, click the Scatter chart icon. By following the steps outlined in this article and keeping some best practices in mind, you can produce informative and eye-catching scatter plots that will help you make data-driven decisions. See full list on howtogeek. 6. . Select Combo > Cluster Column - Line on Secondary Axis. Open Excel and input your data into separate columns. Apr 15, 2017 · 1. You’ll see different styles such as scatter with straight lines, scatter with smooth lines, etc. Highlight the cells or ranges that contain your table. (This method follows the straight line equation, y = mx + c) 3. Click on the scatter plot icon and choose the type of scatter plot you want to create. For the Vertical Line data series, pick Scatter with Straight Lines and select the Secondary Axis checkbox next to it. Set the number format to Number, with 1 decimal place. Click on it to see the different types of scatter plots you can create. Oct 24, 2023 · Highlight the data series to plot and click on the “Insert” tab in the Excel ribbon. Enter the two variables you want to base the graph on in two separate columns, with the independent variable in the left column and the dependent variable in the right column. Press Enter. Customization options allow users to add a title and align colors with their brand color palette. To turn this scatter plot into a quadrant chart, we’ll first click on the horizontal and vertical gridlines and delete both: Feb 9, 2023 · Then, choose Insert. Next, highlight the cells in the range B2:C9. Step 1: Open Excel and select the data range that you want to include in the 3D scatter plot. click on "select range" and select your range of labels you want on the points. 4. Click Chart Elements. Jan 22, 2024 · 2. First, highlight cells A2:B16 as follows: Next, click the Insert tab along the top ribbon, and then click the first plot option under Scatter: This produces the following scatterplot: Step 3: Add a Trendline. Find out how to organize data, choose chart types, customize axes, add labels, and more. Select the Star shape. Select Design > Change Chart Type. By understandi May 17, 2021 · Add Labels to Scatter Plot Excel Data Points. Next, highlight the cells in the range A2:B16. If you have data for both the X and Y axis, to create the graph you want: choose only the cells that represent your Y axis. Sep 9, 2013 · Select one of the Area data series (still plotted as XY), press Ctrl+1 to open the Format Series Task Pane or Dialog, and choose Secondary Axis. Use the Filter section of the pop-up box to filter by color, condition, or value. Select the scatter plot: Click on the plot area of your scatter chart to select it. or sc bi vn oj ss by el kd gd