Trendline equation excel

broken image

Since both the X and Y axes contain quantitative values, the scatter chart is a valuable tool for studying various shapes or functional forms for a line chart. Depending on the format, we can create the scatter chart to look just like a line chart. In other words, the distance between the values on the X axis will vary depending on the value of the number. In a scatter chart, the X axis operates just like the Y axis. This means that the distance between each category on the X axis will always be the same, even if numbers are used. So far, the charts we have demonstrated in this chapter use categories or qualitative labels for the X axis. What makes this chart different from the other charts demonstrated in this chapter is that values are used on both the X and Y axes.

broken image

This section focuses on the scatter chart Chart used when quantitative or numeric values are required for both the X and Y axes.

broken image

Learn how to adjust the scale of the X and Y axes of a scatter chart.Construct a scatter chart to show the supply and demand curves for a market.

broken image