trekpax.blogg.se

How to make a scatter chart excel
How to make a scatter chart excel







how to make a scatter chart excel

The main purpose of a scatter plot is to show how strong the relationship, or correlation, between the two variables is. The chart displays values at the intersection of an x and y axis, combined into single data points. Typically, the independent variable is on the x-axis, and the dependent variable on the y-axis. In a scatter graph, both horizontal and vertical axes are value axes that plot numeric data. Adjust the axis scale to reduce white spaceĪ scatter plot (also called an XY graph, or scatter diagram) is a two-dimensional chart that shows the relationship between two variables.

how to make a scatter chart excel

How to organize data for a scatter chart.Do you want to see how the two sets are related to each other? The scatter plot is the ideal graph choice for this. When looking at two columns of quantitative data in your Excel spreadsheet, what do you see? Just two sets of numbers. In this tutorial, you will learn how to do a scatter plot in Excel to create a graphical representation of two correlated data sets.









How to make a scatter chart excel