Xy Scatter Chart. A scatter chart in excel normally called as X and Y graph which is also called a scatter diagram with a two-dimensional chart which shows the relationship between two variables. If the data points cluster or bunch in a certain configuration -- for example if they tend to form the shape of a line -- that indicates that the two sets of data are correlated in some way.
Each value pair xy is shown as a point in a coordinate system. In the format pane select the fill and border colours for the marker. Then insert a scatter chart from the pasted values.
Select Series A from the drop down on top left.
Scatter Chart in Excel. To show relationships between two numerical values. If the data points cluster or bunch in a certain configuration -- for example if they tend to form the shape of a line -- that indicates that the two sets of data are correlated in some way. Scatter Charts with Weak Negative Correlation.
