Scatter Plot
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.
Pros
- Can show the relationship of one variable to another
- Visual display of correlation
- Ideal for many types of scientific data
Cons
- Not as well understood as many other chart types
- Suitable only for data where correlation is expected
Chart examples
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...
