Google Scatter Diagram. These charts show your data as points or circles on a graph using x left to right and y top to bottom axes. In a scatter graph both horizontal and vertical axes are value axes that plot numeric data.
The better the correlation the tighter the points will hug the line. It is important to ensure that all other potential variables remain constant. Over here you also see two tabs.
Then click insert chart initially itll create a terrible bar chart where each of the 250 rows of data is represented by a bar.
If the data clearly form a. Scatter charts are known by different names scatter graph scatter plot scatter diagram or correlation chart. The scatter diagram graphs pairs of numerical data with one variable on each axis to look for a relationship between them. A identify the two variables which you want to investigate.