Salary range is increased only if the excel skill score increases. Salary Range is a dependent variable here. The relationship between these two variables is “as the excel skill score increases the salary range is also increases”. Now each marker represents the salary range against the excel skill score. Step 10: Similarly, Select The Chart title and enter the chart title manually. Select Axis Titles and enter axis titles manually. Step 9: Once you click on that chart, it will show all the options. Step 8: Select Legend and press the delete option. Step 7: Now, each marker looks bigger and looks a different color. Step 6: Go to Marker Options > Select Built-in > Change Size = 25. It will add different colors to each marker. Step 5: Click on the Marker Fill option and select Vary Colours by Point. In Excel 2010 and earlier versions, a separate box will open. On the right-hand side, an option box will open in excel 2013 & 2016. It will show you the below options, and press Ctrl + 1 (this is the shortcut key to formatting). Step 3: It will insert the chart for you. Step 2: Go to Insert > Charts > Scatter Chart > Click on the first chart. This survey is all about excel knowledge score out of 10 and the salary range for each excel score.īy using the X-Y chart, we can identify the relationship between two variables. In this example, I am using one of the survey data. You can download this Scatter Plot Chart Excel Template here – Scatter Plot Chart Excel Template Example #1
0 kommentar(er)
