A scatter plot is a built-in chart type in Excel meant to show the relationship between two variables. A scatter plot works by placing one variable on the vertical axis and a different variable on the horizontal axis. Each piece of data is then plotted as a discrete point on the chart. In a scatter plot, both the X and Y axis display values – an XY chart has no category axis.
By convention, the X axis represents arbitrary values that do not depend on another variable, referred to as the independent variable. Y values are placed on the vertical axis, and represent the dependent variable.
Can show the relationship of one variable to another
Visual display of correlation
Ideal for many types of scientific data
Not as well understood as many other chart types
Suitable only for data where correlation is expected
I ran into this chart while looking for examples of XY scatter plots and couldn't resist re-building it, following the instructions outlined way back in 2000 I think. Talk about a blast from the past – Clippy even makes...
Combo charts combine more than one Excel chart type in the same chart. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. In the chart shown in...