Example #3 – Using Scatter Chart with smooth Lines In the below scatter chart, we can easily compare the sales figure, which shows up’s and downs depending on the sales value.Īlso, we can check the scatter chart by placing the cursor on the dots so that excel will display the X and Y values, as shown below.Īs we can see in the above screenshot, the local and zonal sales values are almost close to the product name “Braun ES2 Hair Straightener”, which shows the dotted lined with exact merge as shown above. Once we select the specific chart, we will get the below output result as shown below. Step 4 – Click on the second scatter chart called Scatter with smooth lines and markers. Step 3 – Click on the down arrow so that we will get a list of scatter chart as shown below. Step 2 – Now go to the Insert menu and select the Scatter chart as shown below. Step 1 – First, select the entire column cell A, B, and Product Title, Local and Zonal, as shown below. In such a case, we can use excel scatter chat which will give us the exact result to compare it, and we can apply the Scatter Chart with Smooth Lines and Markers by following the below steps. Consider the below example, which shows sales value with local and zonal.Īssume that we need to compare the sales of local and zonal locations.
This example shows how to apply the scatter chart with a smooth line and markers. Example #2 – Using Scatter Chart with Smooth Lines and Markers For example, the X value 38.43 exactly lies with the Y value 3.14. We can see that X and Y values lie between the exact figure with dots in the above result. So that the selected numeric values will get displayed in markers as shown in the below result. Step 4 – Next, select the first option, which shows Scatter with only Markers. Step 3 – Click on the down arrow so that we will get the list of scatter chart list which is shown below. Step 2 – Go to the Insert menu and select the Scatter Chart. Step 1 – First, select the X and Y columns as shown below. To apply the scatter chart by using the above figure, follow the below-mentioned steps as follows.
Note that you can also use the plus icon to enable and disable the trendline.Consider the below table, which has random X and Y values as shown below. The data shows a strong linear relationship between height and weight. Right click any data point, then select "Add trendline".Įxcel adds a linear trendline, which works fine for this data. Trendlines help make the relationship between the two variables clear. If you want a little more white space in the vertical axis, you can reduce the plot area, then drag the axis title to the left. Select the title, type an equal sign, and click a cell. Just like the chart title, we already have titles on the worksheet that we can use, so I'm going to follow the same process to pull these labels into the chart. While I'm here I'm also going to remove the gridlines. Just select the chart, click the plus icon, and check the checkbox. The easiest way to do this is to use the plus icon. Notice the horizontal axis scale was already adjusted by Excel automatically to fit the data. I'll double click the axis, and set the minimum to 100. To help make the relationship between height and weight clear, I'm going to set the lower bound to 100. Next let's adjust the vertical axis scale. Just select the title, type an equal sign, and click the cell. Now, since we already have a decent title in cell B3, I'll use that in the chart. X values come from column C and the Y values come from column D. Here you can see there is one data series. Let's check Select Data to see how the chart is set up. When I click the mouse, Excel builds the chart. The first preview shows what we want - this chart shows markers only, plotted with height on the horizontal axis and weight on the vertical axis. Here I'll select all data for height and weight, then click the scatter icon next to recommended charts. When creating scatter charts, it's generally best to select only the X and Y values, to avoid confusing Excel. Let's create a scatter plot to show how height and weight are related. On this worksheet, we have the height and weight for 10 high school football players. A scatter chart has a horizontal and vertical axis, and both axes are value axes designed to plot numeric data. In this video, we'll look at how to create a scatter plot, sometimes called an XY scatter chart, in Excel.Ī scatter plot or scatter chart is a chart used to show the relationship between two quantitative variables.