When might you want to create an X Y (scatter) chart? What type of data might be best suited for a this type of chart?

What will be an ideal response?

When you want to show a relationship between two numerical variables using the X and Y coordinates, an X Y chart may be appropriate. Excel plots one variable on the horizontal X-axis and the other variable on the vertical Y-axis. Scatter charts are often used to represent data in educational, scientific, and medical experiments.