Scatter dots trend line chart – View trend of activity between vast categories - Excel Effects
So, the scatter dots chart allows you to visually analyze two variables. On the whole, financial companies, they tend to use this kind of graph to compare money. However, you can also compare height-to-weight, age and smoking, or almost any other combo. Now, notice how we include a trend line, along with the equation of the line and the R-squared value. Good stuff!
You need Excel 2007 or higher or compatible to use this chart.
Click on the button below to download this chart.